QuickBooks Online Contact Imports: Size Limits and Duplicate Rows Catch Users Out
We look at why contact imports into QuickBooks Online fail on file size, formatting, and duplicates, and the steps that finally get the list in.
Moving a customer or vendor list out of Outlook, Gmail, Excel, or Google Sheets into QuickBooks Online is one of those jobs that looks trivial and rarely is. The import tool accepts a file only under narrow conditions. Community threads on this keep circling the same three failures: oversized files, spreadsheets that fail the format check, and duplicate contacts left behind by a second attempt. The accepted solution reads less like a trick and more like a preparation routine, and it is worth walking through.
The size ceiling comes first
QuickBooks Online accepts import files of at most 2 MB or a thousand rows. Lists bigger than that must be split and imported in several passes. That catches people moving over from an old setup with decades of customers on file. There is no setting to raise the ceiling, so the only route for a long list is to divide it and repeat the import until everything is in.
A second import never replaces the first
The most common complaint follows a first attempt that went wrong. If a file imports incorrectly and has to be run again, QuickBooks Online does not overwrite the earlier entries. It appends the rows a second time, and the customer or vendor list fills up with doubles. The accepted fix is blunt: delete the contacts from the failed import before trying again, or edit each one individually. With a thousand-row list, neither option is pleasant. That is why the guidance pushes all the checking before the first upload rather than after it.
Names, addresses, and nested entries
Every name in the file has to be unique. The rule reaches across record types: a vendor cannot share a name with a customer, and neither can share one with an employee. Colons and quotation marks in a name also block the import. Only one email address comes through per contact, which matters when an email export stores several addresses for the same person; the rest can be added later inside the software.
Nested entries add a second snag. Linked child records, such as sub-customers attached to a parent, cannot be imported at all. The recommended path is to turn them into ordinary standalone entries before the import, then restructure the relationships once the list is in.
Strict rules for the spreadsheet itself
The sheet gets inspected as closely as the data behind it. Column headers must sit on the first row, and every contact must sit on the first worksheet. The sheet must contain no formulas, no charts, and no blank rows. Any cell error, from a broken reference to an unknown name or a missing value, stops the upload cold.
Exported CSV files deserve a look before they go anywhere near the importer. An email export is rarely tidy, and a stray blank line or leftover formula from an intermediate spreadsheet is enough to fail the check. Scanning the file in Excel or Google Sheets first takes minutes; redoing a failed import with duplicates takes much longer.
Getting the contacts out of the email client
Both Outlook and Gmail hand over contacts as a CSV file, and that file is the bridge into QuickBooks. Outlook’s import and export wizard does the job: pick the option to export to a file, choose the comma-separated format, and select the folder where the addresses live. Gmail exports its contacts the same way from the contacts screen. Once the file is saved, all the cleaning work happens in a spreadsheet before the import ever starts.
The sequence that works
Strip it down to an order of operations and the problem shrinks. Export the contacts to CSV. Open the file and remove formulas, charts, blank rows, and cell errors, and confirm the headers sit on row one of the first sheet. Check each name for uniqueness and for colons or quotation marks. Split the list if it runs past the size limit. Delete any contacts left over from an earlier failed attempt. Then import, list by list, and tidy the remainder inside QuickBooks rather than in the file.
Nothing here is difficult, but nearly all of it happens before the import button rather than after. The users who get stuck tend to be the ones who uploaded a raw email export and then tried to repair the damage with a second upload. The accepted answer’s lesson is easy to restate: clean the sheet, respect the ceiling, and expect duplicates if the first pass goes wrong. The same routine pays off on the other list imports QuickBooks Online supports as well.