Skip to content

Free online IIF to CSV converter

Convert QuickBooks IIF accounting data to an editable CSV table.

Convert IIF to CSV online - free

Uploading…

Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.

How it works

  1. 1/3

    Upload your .iif file

    Click to browse to select your file you want to convert or simply drag & drop your file into selected area.

  2. 2/3

    Perform .iif to .csv conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .csv file

    Conversion result is ready to download.

How to convert iif to csv file

Accounting applications, spreadsheets, and tax tools often require CSV instead of QuickBooks’ IIF format for editing, analysis, or import. Converting the file creates a broadly compatible table, but it can also flatten transaction structures that IIF preserves.

What the IIF format is

IIF means Intuit Interchange Format, a text-based accounting exchange format used primarily by QuickBooks Desktop. QuickBooks exports IIF files for transactions, customers, vendors, accounts, items, and other lists, and can import them to transfer data between company files or external systems.

An IIF file is usually tab-delimited rather than comma-delimited. Its rows use record markers such as !TRNS, !SPL, and !ENDTRNS: a transaction may occupy several related rows, while header rows describe the fields. The extension is commonly .iif, and the file can be viewed as plain text.

What the CSV format is

CSV, or comma-separated values, stores a table in which each line normally represents one record and commas separate fields. Spreadsheet programs, databases, tax applications, reporting systems, and data-analysis tools commonly support .csv.

CSV is easier to inspect and edit than IIF and is supported by Microsoft Excel, LibreOffice Calc, Google Sheets, database import tools, and scripting libraries. It is suitable for flat lists and reports, but it does not provide a standard way to represent IIF transaction headers, split lines, account hierarchies, or parent-child relationships.

How to convert IIF to CSV

Using the online converter

  1. Open the IIF-to-CSV converter on 101convert.com.
  2. Choose or drop the source file, such as transactions.iif.
  3. Start the conversion and download the resulting .csv file when processing finishes.
  4. Open the CSV in a spreadsheet and check the delimiter, column alignment, dates, amounts, and transaction totals before importing it into accounting software.

This option runs in a browser and does not require software installation. Avoid uploading files containing sensitive financial or personal information unless the service’s handling and retention terms meet your requirements.

Using LibreOffice Calc

  1. Make a copy of the original IIF file.
  2. Open the copy in LibreOffice Calc. In the import dialog, select Tab as the separator and disable comma separation unless the file visibly uses commas.
  3. Confirm that the preview keeps each field in the correct column and that leading zeros in account, customer, or invoice identifiers are preserved as text.
  4. Use File → Save As, select Text CSV (.csv), choose UTF-8 encoding, and confirm the delimiter used by the destination application.

For a simple tab-to-CSV transformation without spreadsheet editing, a text-processing script can replace tabs with commas only after correctly quoting fields that contain commas, quotation marks, or line breaks. Blindly replacing every tab is unsafe because IIF files may contain multiline or structurally related transaction records.

Quality and compatibility limitations

  • Check the transaction structure. A transaction’s !TRNS row and its !SPL rows may become unrelated CSV rows. Do not import the result into QuickBooks or another ledger until the target system’s required columns and transaction layout have been verified.
  • Reconcile totals. Compare transaction counts, debit and credit totals, tax amounts, dates, and account names with the source IIF or the originating company file.
  • Preserve formatting. Use UTF-8 for names and notes, keep dates in the format required by the destination, and prevent spreadsheet software from converting identifiers, negative amounts, or leading-zero values.
  • Expect data loss. CSV does not retain IIF record markers, import instructions, accounting metadata, or relationships between transaction headers and split lines. Keep the original IIF file as the archival and recovery copy.
  • Inspect delimiters and quoting. Some regional spreadsheet settings use semicolons instead of commas. Fields containing commas must be enclosed in double quotes, and embedded double quotes must be escaped according to CSV rules.

IIF vs CSV: format comparison

How the IIF and CSV formats compare on the properties that matter most for this conversion.

Comparison of the IIF and CSV file formats
Property .IIF Intuit Interchange Format .CSV Comma-Separated Values
Plain-text readable Yes Yes
Data types Typed Typed
Nested structures Yes No
Formulas No No
Multiple tables or sheets Yes No
Typical file size Small Small
Open standard No Yes
Best used for Data exchange Data exchange
Developer Intuit Inc. —
MIME type — text/csv

Information about file extensions and file types is provided by File-Extensions.org

Frequently asked questions

Is the IIF to CSV converter free?

Yes, converting IIF to CSV on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.

How large can my IIF file be?

You can upload IIF files up to 3 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 10 MB per file and 100 files at once, see our plans.

What happens to my uploaded files?

Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.

Do I need to install any software to convert IIF to CSV?

No. The IIF to CSV conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.

Did the conversion fail?

In most cases, the cause is an incorrect file format. Please upload a valid IIF file for this IIF to CSV conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.

Can I edit an IIF converted to CSV?

Yes, the result is an editable plain-text table. However, editing account names, transaction types, dates, or amounts can make the data unsuitable for accounting re-import unless the required field order and values are preserved.

Why do commas, dates, or leading zeros change when converting IIF to CSV?

CSV uses commas, quotes, and line breaks to separate table fields, so values containing those characters must be quoted and may appear different. Spreadsheet programs may also automatically reformat dates, amounts, or leading zeros even when the CSV text itself is correct.

Can I convert CSV back to IIF without losing anything?

Not necessarily, because CSV stores flat table values while IIF can include accounting record types and linked transaction lines. A reverse conversion may require reconstructing missing structure, field relationships, and formatting rules.

Additional formats for
iif file conversion

Reverse conversion

Convert to csv from
other formats

Share on social media:

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.