IIF to CSV Converter
Convert QuickBooks Desktop IIF export files to CSV for analysis in Excel, Google Sheets, or any data tool.
Drop your IIF file here
or click to browse
How to export IIF from QuickBooks Desktop
Open QuickBooks Desktop
Launch QuickBooks Pro, Premier, or Enterprise on your computer.
Export to IIF
Go to File > Utilities > Export > Lists to IIF Files. Select the data you want.
Convert to CSV
Upload your IIF file here and download the CSV for Excel or Google Sheets.
About IIF files
IIF (Intuit Interchange Format) is a tab-delimited text format used by QuickBooks Desktop for importing and exporting lists and transactions. While it looks like a spreadsheet, the structure is more rigid — each line begins with a record type (TRNS, SPL, ACCNT, etc.) that defines what the data means.
Converting IIF to CSV flattens this structure into a simple spreadsheet where each row is a transaction. This makes your QuickBooks data accessible in Excel pivot tables, Google Sheets, or any business intelligence tool.
If you need to go the other direction — converting CSV to IIF for importing into QuickBooks Desktop — use our CSV to IIF converter.
Frequently asked questions
How do I export an IIF file from QuickBooks Desktop?
In QuickBooks Desktop, go to File > Utilities > Export > Lists to IIF Files. Choose the lists or transactions you want to export, then save the IIF file to your computer.
What data is included in the CSV output?
The CSV will contain the transaction type (CHECK, DEPOSIT, etc.), date, account name, amount, and memo/description from each TRNS record in the IIF file.
Can I open the CSV in Excel or Google Sheets?
Yes — the output is a standard comma-separated CSV that opens directly in Excel (double-click) or Google Sheets (File > Import). You can then use pivot tables, filters, and formulas on your QuickBooks data.
What if my IIF file has multiple record types?
IIF files can contain ACCNT (accounts), CUST (customers), VEND (vendors), and TRNS (transactions) records. This converter focuses on TRNS transaction records, which is what most users need for bookkeeping and analysis.
Why would I convert IIF back to CSV?
Common reasons: analyzing QuickBooks data in Excel, migrating to a different accounting system, sharing transaction data with someone who doesn't have QuickBooks, or creating reports outside of QuickBooks.