Convierte IIF a CSV online sin QuickBooks, sin software y sin registro. Extrae transacciones, asientos, cuentas, clases, items y listas a Excel.
Los archivos IIF de QuickBooks Desktop ayudan a exportar datos, pero no son comodos para revisar. Este convertidor IIF a CSV conserva tablas, filas TRNS, filas SPL, cuentas, clases, memo y datos de items para abrirlos en Excel o Google Sheets.
IIF file
IIF significa Intuit Interchange Format. QuickBooks Desktop lo usa para exportar cuentas, clientes, proveedores, items, facturas, pagos, cheques, depositos y asientos contables.
Why this IIF to CSV converter
La herramienta no solo copia texto. Lee encabezados IIF, conserva transacciones y splits, permite exportar todos los registros, une archivos y crea CSV compatible con Excel.
How to convert IIF to CSV
Español: upload IIF, preview QuickBooks rows, choose columns, and download CSV.
Step 1
Upload one or more QuickBooks IIF files.
Step 2
Check records, TRNS rows, SPL rows, tables, totals, and warnings.
Step 3
Choose date format and amount layout.
Step 4
Keep account type, class, memo, document number, item data, source row, and extra fields when needed.
Step 5
Download separate CSV files or one merged CSV.
Can I convert IIF without QuickBooks?
Yes. The file is read in the browser and QuickBooks is not required.
Are account types and classes preserved?
Yes, when those fields exist in the IIF file.
Can Excel open the CSV?
Yes. The output is a standard CSV file.
Are journal entries supported?
Yes. Journal entries usually appear as TRNS and SPL rows.
Can I use it for Xero or Wave?
Often yes, but you must map columns in the target app.
IIF to CSV features
Convierte archivos QuickBooks IIF en CSV limpios para contabilidad, migracion, revision de asientos y pequenos negocios.
- Converts QuickBooks IIF files to spreadsheet-ready CSV.
- Reads IIF header rows such as !TRNS, !SPL, !ACCNT, !INVITEM, !CUST, and list tables.
- Exports TRNS and SPL rows for transactions and journal entries.
- Can export all rows for accounts, classes, items, customers, and vendors.
- Keeps date, type, account, name, class, amount, document number, memo, cleared status, account type, item, quantity, and price.
- Supports single amount or debit and credit columns.
- Supports ISO, US, EU, and source dates.
- Keeps IIF table and record type columns for review.
- Adds source row and source file columns for audit work.
- Adds extra IIF fields when a file has uncommon columns.
- Shows preview, counts, totals, and warnings before download.
- Warns about missing headers, no transaction rows, split rows, and multi-table exports.
When IIF to CSV helps
Convierte archivos QuickBooks IIF en CSV limpios para contabilidad, migracion, revision de asientos y pequenos negocios.
- Review a QuickBooks Desktop export in Excel.
- Clean client IIF data before migration.
- Inspect TRNS and SPL rows for journal entries.
- Extract account, class, item, customer, or vendor lists.
- Prepare a CSV for Xero, Wave, or another import workflow.
- Archive QuickBooks Desktop data as a spreadsheet.
- Compare old accounting records outside QuickBooks.
- Batch convert multiple IIF exports.
IIF versus CSV
IIF is made for QuickBooks import and export. CSV is easier to filter, sort, review, share, and map into other accounting software.
Tips for clean IIF to CSV conversion
Keep context columns on until you finish checking the file.
- Keep table and record type columns on for journal entries.
- Use all-record export for accounts, customers, vendors, classes, and items.
- Use ISO dates for import work.
- Use debit and credit columns for accountant review.
- Keep source row numbers when troubleshooting a rejected IIF file.
- Keep extra fields on when the IIF table is unfamiliar.
- Use the UTF-8 marker if Excel shows broken characters.
Create a clean CSV from QuickBooks IIF
Use this converter when an IIF file needs to become a readable spreadsheet.
Keep the original IIF beside the converted CSV for audit and migration records.
