"Anytime," she replied. "Just remember—next time, don't fight the format. Just convert it."
The is a proprietary text file used by QuickBooks Desktop to import and export lists and transactions. While IIF files are useful for QuickBooks users, they are notoriously difficult to read or edit in their raw form. Converting IIF to CSV (Comma-Separated Values) is a common task for accountants and bookkeepers who need to clean up data, perform detailed analysis, or migrate financial records to other platforms like QuickBooks Online. Why Convert IIF to CSV?
df = pd.read_csv('input.iif', sep='\t', dtype=str) convert iif to csv
An IIF file is used by QuickBooks to import or export lists, transactions, and opening balances. It is a text file with a special header row that defines the data type (e.g., !TRNS , !SPL ).
"It looks like a disaster," Arthur grumbled, opening the file in Notepad. The screen was a dense thicket of text. Lines started with cryptic headers like !TRNS , !SPL , and !ENDTRNS . Tabs separated data in a way that made his eyes cross. "Sarah, I just need to put the vendor names and amounts into Excel so I can sort them. The accounting software hides half these columns." "Anytime," she replied
"You just saved me two and a half hours," Arthur said, a grin breaking through his usual stoicism. "And I don't have to worry about misreading the tabs?"
"You can't just open an IIF in Excel, Arthur," Sarah said. "It uses nested transactions. One row is the transaction header, the next rows are the splits. If you open it in Excel now, the tabs will align, but the logic will be broken. You’ll get totals that don’t match reality." While IIF files are useful for QuickBooks users,
The file on his desktop was named Weekly_Sales.iif .
QuickBooks Online and many modern ERP systems do not support direct IIF imports, requiring CSV or Excel formats instead.
Here’s a draft you can use for documentation, a script comment, or a guide on converting an (Intuit Interchange Format) file to CSV .
pip install pandas python convert.py