A text file where data fields are separated by tab characters instead of commas. The IIF format and some bank exports use tab-delimited structure for data interchange.
Understanding Tab-Delimited File
A tab-delimited file is a plain-text data format where fields (columns) within each row are separated by tab characters (ASCII code 9) rather than commas, semicolons, or other delimiters. The tab character is invisible when viewing the file in a text editor, appearing as whitespace.
Tab-delimited files are functionally similar to CSV files but use tabs instead of commas as the field separator. This format is advantageous when field values contain commas (common in financial descriptions like "Smith, John" or "New York, NY") because it avoids the need for quoting or escaping.
The most prominent use of tab-delimited format in accounting is the IIF (Intuit Interchange Format) used by QuickBooks Desktop. IIF files are tab-delimited with specific column headers and row-type identifiers. Some bank exports and ERP systems also use tab-delimited format for data interchange.
Why It Matters for Ecommerce
If you're working with IIF files for QuickBooks Desktop import, understanding the tab-delimited format is critical. A common error is accidentally converting tabs to spaces or adding extra tabs, which causes columns to misalign and the import to fail or produce incorrect results. Always use a proper text editor (not Word) when inspecting IIF files.
Practical Example
An IIF file uses tabs between columns (shown as → here): TRNS→TRNSID→TRNSTYPE→DATE→ACCNT→AMOUNT→NAME TRNS→1→DEPOSIT→01/15/2026→Checking→1500.00→Amazon SPL→1→DEPOSIT→01/15/2026→Sales Income→-1500.00→Amazon ENDTRNS Each → represents a single tab character. Replacing tabs with spaces would break the import.
Related Terms
CSV (Comma-Separated Values)
A plain-text file format that stores tabular data with values separated by commas (or other delimiters). The most universal format for exporting and importing financial data across systems.
File FormatIIF (Intuit Interchange Format)
A tab-delimited text file format created by Intuit for importing transactions, lists, and budgets into QuickBooks Desktop. Each row type is identified by a keyword header like TRNS, SPL, or ACCNT.
File FormatIntuit Interchange Format (IIF)
The full name of the IIF file format developed by Intuit for bulk-importing data into QuickBooks Desktop. Supports transactions, chart of accounts, customer/vendor lists, and items.
Put This Knowledge Into Practice
Now that you understand tab-delimited file, use PrimeConnect's free accounting tools to convert your ecommerce data into QuickBooks-ready formats — 100% browser-based.
Browse Free Tools