无需 QuickBooks、无需安装软件、无需注册，即可把 IIF 转 CSV。可导出 transactions、journal entries、accounts、classes、items 和 lists 到 Excel。
QuickBooks Desktop IIF 文件适合导出数据，但不适合人工检查。这个 IIF 转 CSV 工具把 TRNS、SPL、账户、类别、memo 和 item 数据整理成可读表格。
IIF file
IIF 是 Intuit Interchange Format。QuickBooks Desktop 用它导出账户、客户、供应商、商品、发票、付款、支票、存款和日记账分录。
Why this IIF to CSV converter
工具会读取 IIF 表头，保留 transaction 与 split 行，可导出全部记录，并生成适合 Excel 的 CSV。
Relevant searches
IIF 转 CSV 免费在线, IIF to CSV 无需 QuickBooks, QuickBooks IIF CSV, 打开 IIF 为 CSV, IIF CSV 会计, IIF CSV 记账, IIF 无需注册, batch IIF to CSV, 提取 IIF 数据到 CSV, IIF viewer CSV online
How to convert IIF to CSV
中文: 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
把 QuickBooks IIF 文件转换成清晰 CSV，用于会计检查、数据迁移、日记账分录和小企业记录。
- 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
把 QuickBooks IIF 文件转换成清晰 CSV，用于会计检查、数据迁移、日记账分录和小企业记录。
- 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.
