CSV to IIF List Import — Customers, Vendors & Accounts
Migrating lists into QuickBooks Desktop usually means retyping names one at a time. Load a CSV or Excel export instead and get a tab-delimited .iif list file for customers, vendors, items, or your chart of accounts.
Runs in your browser — your file never leaves your computer
- 1Load
- 2Map
- 3Review
- 4Download
What this tool accepts
A spreadsheet of names, written as a QuickBooks list import for customers, vendors, items, or accounts.
Files
CSV, XLS, or XLSX with one name per row
Columns
- Name — required — the customer, vendor, item, or account name
- Type — optional — account or item type; defaults apply when blank
Output
.iif · one !CUST, !VEND, !ITEM, or !ACCNT section per list type.
Then import in QuickBooks Desktop: File → Utilities → Import → Import IIF Files
How to use this file in QuickBooks Desktop
Work on a backup. Run File → Back Up Company first; imports are easiest to undo on a copy of the company file.
- Back up your company file first (File → Back Up Company), then export your list from the old system as CSV or Excel.
- Load the file here and pick the list type: customers, vendors, items, or accounts.
- Choose the column that holds the name. For accounts and items, optionally choose a column with the account or item type.
- Download the .iif and import it: File → Utilities → Import → Import IIF Files in QuickBooks Desktop.
- Check the list for duplicates or merged names — QuickBooks adds names rather than updating existing ones.
Import path: File → Utilities → Import → Import IIF Files