2026-11-11 · QuickBooks Online

How to Import Customers, Vendors and Products into QuickBooks Online from Excel Without Duplicates or Errors

One of the first chores in a new QuickBooks Online (QBO) file is entering your lists. Typing in hundreds of customers, dozens of vendors and a few hundred products one at a time can take days, and every manual entry is a chance for a typo or a duplicate. QBO lets you bring lists in all at once from Excel, CSV or Google Sheets, but an uncleaned file tends to produce errors or duplicate names, and once a list is in, there is no bulk undo.

This is part 3 of our QBO beginner series. Part 1 (opening balances and chart of accounts setup) and Part 2 (chart of accounts examples by industry) covered the accounts. This post covers getting your customers, vendors, and products and services into QBO cleanly, from preparing the file to checking the results.

Who this is for: Owners who already keep customer, vendor or product lists in a POS system or spreadsheet / anyone moving to QBO from QuickBooks Desktop or another program / anyone who tried an import and got stuck on error messages or duplicate names / retail stores, beauty supply shops and restaurants with too many items to enter by hand.

1. Ground rules before you import

Here are the rules from Intuit's help articles. Following them up front prevents most import errors.

TopicRulePractical tip
File typesCSV, Excel (.XLS/.XLSX), Google Sheets. Customers and vendors can also come from Outlook or Gmail CSV exportsCSV or .XLSX causes the fewest problems
How much per importCustomers/vendors: up to 2 MB or 1,000 rows per file / Products and services: 1,000 rows at a time (one article says 'less than 1,000 rows')Split into files of about 900 rows
First rowUsed as column headers for mapping; not importedWithout a header row, your first customer is lost
SheetsData must be on the first sheet of the workbookSave each sheet as its own file
Not allowedFormulas, charts, blank rows, error values such as #REF! or #N/AUse Paste Values to strip formulas
NamesMust be unique across the customer, vendor and employee lists; no colons (:) or quotation marks (")If a company is both a customer and a vendor, tag one of the names
UndoNo bulk undo or bulk delete for imported contacts; a product import can't be undoneReview carefully on the review screen

Order matters too. Intuit recommends importing lists before transactions, and lists in this order: chart of accounts → customers → vendors → employees → classes → locations → products and services. Products need an income account, so your chart of accounts should be settled first.

Six-step flowchart: gather, clean, split, import in order, map and review, verify
Figure 1. The six-step import workflow. Cleaning and splitting first removes most mapping errors.

2. Step 1: Gather and clean your lists

Export your customer, vendor and product lists from your POS, previous accounting software or spreadsheets, then clean them in this order:

  1. Keep the originals untouched. Work on a copy and date the file name (for example, customers_clean_v1).
  2. Remove duplicates. Sort by name so near-duplicates such as 'Sunrise Nail' and 'Sunrise Nail Spa' line up next to each other. Merge rows that are the same customer.
  3. Pick a naming convention. Decide whether to use the company name or a 'Store - Area' format, and apply it everywhere. Replace colons and quotation marks with hyphens or remove them.
  4. Find names that appear on more than one list. A name already used by a customer, vendor or employee won't import, so add a tag such as ' (V)' on the vendor side.
  5. Keep one email per cell. Contact imports bring in only one email address.
  6. Remove formulas and blank rows. Copy everything and Paste Values, then delete blank rows and total rows.
  7. Delete columns you don't need. QBO drops fields it can't map, so removing them first keeps mapping simple.
Before and after comparison of a customer sheet: names with colons and quotes, two emails in one cell, a duplicate row, a formula and a blank row are cleaned up
Figure 2. Customer sheet before and after cleanup (sample values). The left sheet would cause errors or duplicates.

Sample customer sheet

Below is a cleaned customer sheet. You can name columns however you like and match them during mapping, but headers that resemble QBO's field names make mapping faster.

NameCompanyEmailPhoneStreetCityStateZIP
Sunrise Nail - HendersonSunrise Nail LLCa@example.com702-555-0101100 Sample AveHendersonNV89000
Blue Lotus SalonBlue Lotus Incinfo@example.com702-555-0102200 Test BlvdLas VegasNV89100
Golden SupplyGolden Supply Cosales@example.com213-555-0103300 Demo StLos AngelesCA90000
Sample values — fictional names and addresses

Intuit lists character limits for each field, including 100 for the name, 50 for company, 100 for email, 21 for phone numbers and 30 for ZIP. The address imports as the billing address, and a blank country defaults to your home country.

3. Step 2: Split large files

Customer and vendor files can be up to 2 MB or 1,000 rows, and product files up to 1,000 rows, so splitting at roughly 900 rows gives you a safety margin. Sort alphabetically and split A–K and L–Z so you can tell which file you've already uploaded. Every file needs the same header row.

4. Step 3: Import customers and vendors

  1. Go to Settings (⚙) and choose Import data (or type 'Import data' in the search bar). For customers, you can also start from the customer list in Customer Hub with New customer ▼ → Import customers.
  2. Choose Customers (or Vendors).
  3. Click Browse to upload the file, or Connect to sign in to Google for Google Sheets. Click Next.
  4. On the mapping screen, use the ▼ under Your Field to match each QBO field to a column in your file. If nothing matches, choose No Match.
  5. On the review screen, fix any cells shown in red and uncheck rows you don't want. Edits here don't change your original file.
  6. Confirm the count and click Import.
Simplified illustration of the import mapping screen: QBO fields matched to file columns on the left, four tips on the right
Figure 3. Field mapping screen layout (illustration only, not an actual QBO screen)

What's different for vendors

Vendors use the same screen with Vendors selected. Intuit's field list includes vendor-only fields such as Tax ID (20 characters) and Report basis (cash or accrual; blank defaults to cash), while customers have a Resale Number field (16 characters). Never put real tax ID numbers in files you share, and consider entering them directly on each vendor record after the import. The 1099 setting isn't in the import field list, so review it vendor by vendor after the import (year-end 1099 prep is covered in part 16).

NameCompanyEmailPhoneReport basis
Golden Supply (V)Golden Supply Coap@example.com213-555-0103accrual
Pacific Nail WholesalePacific Nail Wholesale Incorder@example.com626-555-0104
Sample values

Tip — leave the Opening Balance column empty. Contact imports offer an Opening Balance field, but entering open invoices and bills one by one as of your start date lets you track exactly which items are still open. Decide which approach to use based on the opening balance principles in part 1 and your accountant's input. If your opening balances are already tangled, see how to clean up Opening Balance Equity.

5. Step 4: Import products and services

Before importing products, decide each item's type. Intuit describes four:

TypeUsed forExamplesTracks quantity
InventoryProducts you buy and sell and track quantities forGel polish at a beauty supply, clothing stockYes (Plus and Advanced plans)
Non-inventoryItems you buy or sell without tracking quantityDisposable supplies, small add-onsNo
ServiceServices you provideManicures, alterations, delivery feesNo
BundleSeveral items sold together as oneGift sets, service-plus-product packages—

Per Intuit's help article, inventory features come with Plus and Advanced. Plan features change, so check Intuit's current plan information.

Decision tree for item type: bundles go to Bundle, services to Service, items without quantity tracking to Non-inventory, and tracked items on Plus or higher to Inventory
Figure 4. Decision tree for choosing a product/service type

Product import steps

As of 2026, Intuit says the product import screen is rolling out in two versions: a new batch import screen and the older upload screen. Go to Settings (⚙) → Import data → Products and Services. A spreadsheet-style batch screen means you have the new version; a file upload screen means the old one.

  1. In the new version, choose Import CSV → Download a sample file, and paste your list into the sample's columns. Using the sample file is safer than inventing your own headers.
  2. Upload the file, click Next, match your CSV headers to QBO fields in the dropdowns, and pick the date format.
  3. Fix cells highlighted in red using the error message, or correct the file and upload it again.
  4. Check the overwrite box only when you intend to update existing items. Overwrite replaces values for items with an identical name and can't be undone.
  5. Click Save (Import in the old version).
Product/Service nameTypeSKUSales priceIncome accountCategory
Gel Polish 15ml - RedInventoryGP-015-RD8.50Sales - Retail ProductsPolish:Gel
Nail Files 100pkNon-inventoryNF-10012.00Sales - Retail ProductsTools
Delivery FeeServiceDLV-0115.00Delivery IncomeServices
Sample values — use the column names in QBO's sample file

Key product import rules from Intuit:

6. Step 5: Verify after the import

  1. Compare counts: rows in your cleaned file (minus the header) versus records in the QBO list.
  2. Spot-check five records: open five at random and confirm name, email, address, price and linked account.
  3. Save the failed rows: put any rows you unchecked because of errors in a separate file (for example, customers_failed.csv), fix them and import them again.
  4. Don't re-upload the same file. Re-importing contacts doesn't overwrite existing records, and names that already exist can't be imported, so you'll get duplicates or errors. Re-import only the failed rows.

7. Worked example: a fictional beauty supply store

Say 'Desert Glow Beauty Supply', a fictional store in Las Vegas, is moving its POS lists into QBO Plus. (All names and figures are sample values.)

ListOriginal rowsCleanupFiles importedResult
Customers (salons)1,340Deleted 37 duplicates, fixed 12 names with colons2 (652 + 651 rows)1,303 added
Vendors86Added ' (V)' to 5 names shared with customers1 (86 rows)86 added
Products & services612Typed as 540 Inventory / 60 Non-inventory / 12 Service1 (612 rows)611 added, 1 error
Sample values

The one product error came from a subaccount ('Sales:Retail') in the income account column. Switching it to the parent account and re-importing that single row fixed it. Inventory as-of dates were set to the books start date, 01/01/2026. Finally, five customers and five products were spot-checked, and the original, cleaned and failed-row files were saved together in one folder.

8. Common mistakes

SymptomCauseFix
First customer missingNo header rowAdd column names in row 1
'Name already exists' errorSame name on the customer, vendor or employee listTag one of the names
Same customer twiceUncleaned file uploaded twiceMake the duplicates inactive, then re-import only failed rows
Only one email came inSeveral emails in one cellKeep one primary email
Account error on productsSubaccount enteredUse the parent account
Second sheet ignoredData not on the first sheetSave each sheet as its own file

If you're moving from QuickBooks Desktop, read our Desktop to Online migration guide before importing lists from Excel. If the conversion brings your lists over, you don't need to import them again.

9. FAQ

Q1. Can I delete an imported list all at once?

According to Intuit, there's no bulk undo or bulk delete for imported contacts, and a product import can't be undone. Wrong records have to be made inactive or fixed one by one, which is why the review step matters most.

Q2. How do I import 1,500 customers?

The limit is 1,000 rows per import (and 2 MB for customers and vendors), so split the list into two files, each with the same header row.

Q3. I only want to update prices on existing products.

The overwrite option replaces values for items with an identical name. Because it can't be undone, export your current list as a backup first and import a file containing only the items you're changing.

Q4. Can I set a foreign currency for an overseas vendor?

Contacts import in your home currency by default. Intuit says multicurrency must be turned on before the import to assign a different currency. Multicurrency is covered in part 15.

Q5. I'm on Essentials. Can I import inventory items?

Per Intuit's help article, inventory features are in Plus and Advanced. On other plans, set items up as Non-inventory or Service, and review your plan if you need inventory tracking (inventory basics are in part 20).

10. Self-check list

Related posts

This post is general educational information, not tax, legal or financial advice. The right treatment depends on each business's situation. QBO screens, menu names, plan features and prices change often, so check the current screens and Intuit's official guidance before you act. All business names, addresses, emails and figures in this post are fictional examples.

QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

Sources

← All articles Privacy