Convert IIF to XML Online

Convert IIF to XML Online

An IIF file is a flat, tab-delimited dump that only QuickBooks Desktop truly understands. Feed it to a database, an ERP, or a modern accounting API and the import breaks. Converting IIF to XML turns those cryptic tab-separated rows into clean, self-describing data any system can read.

Quick answer: Upload your .iif file and the CoolUtils online converter parses the QuickBooks header rows (the lines that begin with an exclamation mark) and their data rows, then rewrites every account, list, and transaction as nested XML elements with named tags. Click Convert, download the .xml, and import it into any database, ERP, or accounting tool. Free, no signup, no software.

• Structured, named tags — each IIF column becomes a readable XML element instead of an anonymous tab-separated field
• Hierarchy preserved — a transaction (TRNS) and its split lines (SPL) nest as parent and child nodes, keeping the record intact
• Portable to any system — XML imports into SQL databases, ERPs, and ETL pipelines that reject raw IIF
• Human-readable — open the output in any text editor or browser and see exactly what every value means
• No QuickBooks required — the converter reads the IIF text directly, so Intuit software need not be installed

What Is IIF?

IIF (Intuit Interchange Format) is a plain-text, tab-delimited file that QuickBooks Desktop uses to import and export lists and transactions. Every line is a row of tab-separated fields. Header lines start with an exclamation mark and name the columns for a section; the data lines below them supply the values. A single IIF file can hold several sections at once — chart of accounts (ACCNT), customers (CUST), vendors (VEND), and transactions (TRNS/SPL/ENDTRNS). The format is compact but proprietary, position-sensitive, and easy to break, which makes it a poor fit for anything outside QuickBooks.

What Is XML?

XML (Extensible Markup Language) is an open, hierarchical, self-describing data format. Instead of anonymous tab-separated columns, each value sits inside a named tag, and related records nest inside one another. XML is understood by virtually every programming language, database, and integration platform. Because the structure and the field names travel with the data, an XML export of a QuickBooks file can be validated, transformed with XSLT, queried with XPath, or mapped directly into another accounting system without guesswork about which column means what.

Online Converter vs Desktop Converter — IIF to XML

Batch CLI example: CSVConverter.exe C:\iif_files\*.iif C:\xml_output\ -cXML

How to Convert IIF to XML

1. Click Choose File and select your .iif export from QuickBooks
2. The converter reads the header rows (lines beginning with !) to learn each section's columns
3. Select XML as the output format
4. Click Convert — each record type is written as a named XML element with its fields as child nodes
5. Click Download to save the .xml file
6. Import the XML into your database, ERP, or accounting system

When Do You Need IIF to XML?

• Migrating off QuickBooks — move accounts, customers, vendors, and history into a new platform that speaks XML
• Feeding a database or warehouse — load QuickBooks records into SQL or an ETL pipeline for reporting
• Building integrations — hand structured XML to an API or middleware instead of parsing tab-delimited text by hand
• Auditing and review — read every transaction and split line in a clear, tagged layout
• Long-term archival — store financial exports in an open, self-describing format that outlives the IIF spec

• Command line support
• API integration
• 24/7 offline availability
• Enterprise licensing