The QuickBooks Import Excel and CSV Toolkit: What It Is and How to Use It

Guide · Updated July 2026 · ~11 min read

You have a spreadsheet of 400 customers and a QuickBooks Desktop company file that needs them in it. Someone told you to "download the Import Excel and CSV toolkit" — and the first surprise is that it is not a program at all. The second, for most people landing on this search, is that it has nothing to do with QuickBooks Online.

Below: what the toolkit is, the record types it really handles, the menu path it documents, the failures that eat an afternoon, and the QuickBooks Online equivalent. Every path, quote and limit comes from Intuit's current help articles, dated where it matters.

What the toolkit actually is (documentation, not software)

Intuit's article Import/export CSV files in QuickBooks Desktop (updated 6/1/2026) says it plainly: "To import lists in CSV format, you must first install the QuickBooks Import Excel and CSV toolkit. This toolkit contains instructions, sample files, and a reference guide for supported fields."

Instructions, sample files, a reference guide — no features. The import engine already lives in the product under File > Utilities > Import > Excel Files. What you download is a WinZip self-extracting archive containing exactly four things, in Intuit's words:

1. Import from Excel and CSV Manual — "A PDF document with instructions, best practices, and notes."
2. CSV Examples Folder — "4 sample CSV files, one for each type of list."
3. XLS Example Folder — "A sample Excel file containing 4 worksheets, one for each type of list."
4. Allowed fields — "A reference guide explaining what fields are available for Excel and CSV import."

Intuit does not say which four lists the samples cover, but the Excel import article scopes Advanced Import to Customer, Vendor, Items and Chart of Accounts — the reasonable inference.

The Allowed fields guide is the real reason to download the archive: without an authoritative column list per list type you are guessing at field names, and guessing is where imports fail.

Which QuickBooks products it applies to

The applicable-products list is QuickBooks Desktop Pro Plus, Premier Plus, Accountant Desktop Plus, and Enterprise Diamond, Gold, Platinum and Accountant. QuickBooks Desktop Mac Plus is not listed, and every step references the Windows desktop and a WinZip Self-Extractor .exe. Treat it as Windows QuickBooks Desktop only.

Context matters. Intuit confirms "QuickBooks Desktop isn't available to new subscribers in the United States. The deadline to purchase a new subscription was September 30, 2024." Pro Plus, Premier Plus, Mac Plus and Desktop Enhanced Payroll are no longer sold; existing subscribers can keep renewing; Enterprise is unaffected; the change is U.S.-only. And "older versions such as QuickBooks Desktop 2023 will stop getting support after May 31, 2026."

So the toolkit is not retired — both articles referencing it were refreshed in 2026 and still tell you to install it — but it serves an installed base. Buying QuickBooks new in the US? Skip to the QuickBooks Online section.

Downloading and opening it

Intuit links the download from the words "file download window"; the target is a single file, QuickBooks_Import_Excel_and_CSV.exe, at https://support.quickbooks.intuit.com/support/pages/Executable/QuickBooks_Import_Excel_and_CSV.exe. That is the link Intuit publishes — fixed and unversioned, with no version, file size or release date anywhere.

Intuit's steps: save it to your Windows desktop, double-click to open the WinZip Self-Extractor window, Browse to a folder (your Desktop is fine), Unzip, Close, then open the QuickBooks Import Excel and CSV folder. Nothing is registered or installed; you have a folder of documents.

And one non-negotiable, from Intuit's Desktop import overview (updated 6/1/2026): "Backup your data: You cannot undo an import. Always create a backup of your company file before performing any import operation."

Exactly which record types it handles

This is where most of the internet gets it wrong: search results will tell you the toolkit imports invoices, bills, expenses and bank transactions. Intuit's Excel import article says, verbatim: "You can import Customer, Vendor, Items, and Chart of Accounts from an Excel spreadsheet."

Four list types. No transactions.

QuickBooks Desktop can import transactions — invoices, bills, purchase orders, checks, deposits, journal entries, credit memos and estimates all appear in Intuit's supported-import-data list. But the mechanisms differ. Intuit documents four routes: standard file formats (Excel or .CSV) for "general data transfer of lists and transactions"; Templates for invoice and other form templates; Intuit Interchange Format (IIF) to "import and export complex data structures"; and Bank Data via Web Connect .qbo files, which "requires you to sign in to your Intuit Account within QuickBooks Desktop."

So: lists via Excel/CSV, complex transaction structures via IIF, bank feeds via Web Connect. Hand a workbook of 2,000 invoices to the toolkit and you are using the wrong tool.

Step by step: importing customers, vendors or items

1. Prepare the sheet

Open the sample XLS and the Allowed fields guide side by side and match the sample's headers rather than inventing your own — mapping is far easier when the names line up.

For inventory items, turn inventory on first: Edit > Preferences > Items & Inventory > Company Preferences tab, and set Inventory and Purchase Orders are Active (Admin, single-user mode).

Sub-items have a naming rule that catches everyone. The parent must already exist or appear above the sub-item in the sheet, and "the Item Name would be formatted with the Parent separated from the Sub-Item by a colon" — so Widgets, then Widgets:Widget001.

2. Open Advanced Import

Go to the File menu, select Utilities then Import and then Excel Files. On the Add/Edit Multiple List Entries prompt select No, then select Advanced Import.

3. Map the columns

Browse to the Excel file, pick the correct sheet, tick This data file has header rows. On the Choose a mapping dropdown select Add New, name the mapping (they are reusable — name it something you will recognise next month), pick the Import type, map the QuickBooks columns to your Import Data columns, and Save. Then Preview to verify the mapping, and Import.

Do not skip Preview. It is the only checkpoint between your spreadsheet and a company file you cannot roll back.

4. Handle duplicates and read the error log

If a name already exists you get a Duplicate Record Found prompt with three choices, verbatim:

• "Keep the existing data and discard the import data."
• "Replace the existing data with import data, ignoring blank fields."
• "Replace the existing data with import data, including blank fields."

Then Apply or Apply to all. The gap between the two replace options is where data quietly dies: including blank fields means an empty cell in your sheet wipes the existing QuickBooks value. For a partial update, choose ignoring blank fields.

QuickBooks then reports how many records imported and how many errored, and you can select Save for the error log. Save it every time.

The failures that actually happen

Account names that do not match the chart of accounts exactly. Item and customer records reference accounts by name. If your sheet says "Sales Income" and QuickBooks holds "Sales - Income," the row errors. Export the chart of accounts and paste the real names in.

Date formats. Excel displays a date one way while storing something else, and text-stored-as-date columns are a classic cause of rows that look fine and still fail — our guide to cleaning messy data in Excel covers the trap.

Required fields missing. The Allowed fields reference tells you what each list type needs. A blank name column is obvious; less obvious are fields that only become mandatory once a related field is populated.

Duplicates already in your source sheet. Two rows for the same customer, spelled slightly differently, give you either a duplicate prompt or two records. Watch for near-matches like "Acme Ltd" versus "Acme Limited."

Items Advanced Import cannot create. Verbatim: "You cannot import Subtotal, Payment, and Sales tax items via the Advanced Import function, but you can import them in an IIF file."

Existing inventory quantities. Verbatim: "Existing inventory items: You CANNOT update their Quantity On Hand (QOH), the value on hand (VOH), or average cost." New items can carry QOH, VOH and an average cost — and when they do, "QuickBooks enters an Adjust Quantity/Value on Hand debiting the item's asset account and crediting Opening Balance Equity," which your accountant will need to reclassify. Also, with Advanced Inventory and Multiple Inventory Sites enabled, "you must disable Multiple Inventory Sites before importing" quantities or values.

Intuit publishes no row or record limit for Desktop Advanced Import. The 1,000-row and 100-invoice caps you may have read about are QuickBooks Online limits — do not transfer them to Desktop.

The no-toolkit alternative for small list jobs

For a few dozen names, skip all of this: Lists > Add/Edit Multiple List Entries accepts Ctrl+C from Excel and Ctrl+V into the window, and offers Copy Down and Duplicate Row. Its stated boundary: "This is for list information (name, description, etc.) and cannot be used to import transactions (invoices, bills, etc...)."

If you are on QuickBooks Online, there is no toolkit

QuickBooks Online has no toolkit download at all — sample files come from inside the product, and the accepted formats are broader. Intuit's import FAQ (updated 7/1/2026): "You can use a CSV (Comma Separated Values) file, Google Sheets, or an XLS/XLSX file to import information to QuickBooks Online."

The path is Settings (gear) > Import data, then pick the record type. The surface is far wider than Desktop's four list types — eighteen in all, from Bank Data, Customers, Vendors and Chart of Accounts through Invoices, Bills, Checks, Deposits, Journal Entries, Purchase Orders and Time Activities. Note that "Importing Bills is restricted to QuickBooks Online Advanced and higher subscription tiers in the US region." Order matters: lists first — Chart of Accounts, Customers, Vendors, Employee, Class, Locations, Products and services — then "import Transactions in any order."

The hard limits, verbatim: "You can only import spreadsheets with less than 1,000 rows." The first row is consumed for mapping, so "your first row's content isn't imported." You cannot import a contact that already exists, there is no bulk undo or delete for imported contacts, and QuickBooks Online "doesn't import currency details from a contact list."

Invoices add their own: each line item "needs its own invoice number, customer, invoice date, due date, and item amount"; "a maximum of 100 invoices at a time"; no negative charges "such as discounts or credit memos"; and the one that stops people cold — "Important: If you have set up sales tax in your account, you can't import invoices this way."

For the two jobs people most often force through a CSV import we have walkthroughs: importing journal entries into QuickBooks Online from Excel and pulling the QuickBooks general ledger into Excel.

Desktop toolkit versus QuickBooks Online import

The other route: write via the API instead of a CSV template

Everything above is file-shaped: match a spreadsheet to a template, map columns, check the preview, keep a backup because there is no undo. For seeding a company file once, that is the right approach and the toolkit plus Advanced Import is all you need.

It fits the recurring version badly — the monthly batch of entries, the supplier list that keeps changing. For that, HISAB 360 is one option: a paid add-in for Windows desktop Excel (365 or 2019+) with an AI chat panel docked in the sheet. You authorise QuickBooks Online over OAuth, keep the data in a normal worksheet, describe what you want in plain English, and it writes records through the API — so the spreadsheet-import caps above are not the constraint, and updates, voids and deletes are possible where the API allows. The same connection reads invoices, bills, payments, journals, contacts and reports back into the sheet, and Xero, Zoho Books, Odoo, FreshBooks and Sage connect the same way. There is a 15-day free trial of every feature plus 50 HISAB AI credits, no credit card, once per machine.

The honest limits: Windows desktop Excel only — not Mac, not Excel on the web — and paid after the trial, with no permanently free tier ($7/month if you bring your own AI provider key, $10 or $20/month for HISAB AI, or $199 perpetual; see pricing). It does not help with QuickBooks Desktop, where the toolkit path above remains the route. And any write to a ledger should be reviewed before you approve it and reconciled afterwards.

Before you import anything

Back up the company file. Read the Allowed fields guide for your list type. Reuse the exact chart-of-accounts names. De-duplicate and normalise the sheet, dates included. Order sub-items under their parents. Preview before Import, save the error log, and on duplicates choose "ignoring blank fields" unless you mean to overwrite with blanks.

The toolkit is not glamorous — a PDF, some samples, a field reference — but that field reference is the difference between a clean import and an afternoon of error logs. Beyond the four list types, the honest answer is IIF, Web Connect, or an API-based tool such as HISAB 360's ERP write-back.

Frequently asked questions

Try HISAB 360 on your own workbook

HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.