Will this file import into QuickBooks Online?
Find out before you upload. This checks your spreadsheet against QuickBooks Online's real customers rules, maps your columns to its field names, and shows you exactly which rows would be rejected — with row numbers.
Runs in your browser. Nothing is uploaded.
Drop a CSV or Excel file here
Or choose a file — nothing leaves your browser.
QuickBooks caps imports at 1,000 rows, rejects any customer name that duplicates an existing customer, vendor or employee, and refuses colons or quotation marks in the name field.
- Name — used to deduplicate
- Maximum 2 MB or 1,000 rows per import — split larger lists.
- Names must be unique across customers, vendors and employees.
- Names cannot contain a colon (:) or a quotation mark (").
- Only one email address per customer is supported on import.
Common questions
Which columns does QuickBooks Online require for customers?
Name. Rows missing it are rejected. This page checks every row for you and lists the ones that would fail.
Is there a row limit on QuickBooks Online imports?
Yes — 1,000 rows per import. Larger lists have to be split into several files. This page tells you how many files you'd need, and the Split CSV tool will do it.
Why did my QuickBooks Online import fail?
QuickBooks caps imports at 1,000 rows, rejects any customer name that duplicates an existing customer, vendor or employee, and refuses colons or quotation marks in the name field. Drop your file above and you'll get a row-by-row list of what QuickBooks Online would reject, with the row numbers.
Is my file uploaded anywhere?
No. The mapping and validation run entirely in your browser using JavaScript. Your spreadsheet never reaches our servers, which matters when the file is a customer list.
Does it change my data?
It renames your column headers to QuickBooks Online's exact field names and reformats values that QuickBooks Online would otherwise reject — phone numbers, yes/no fields and picklist casing. Every change is listed before you export, and nothing that can't be safely converted is touched.
Field rules sourced from QuickBooks Online's own documentation.