February 6, 2023

How to Import Customer Data Into QuickBooks Online From an Excel File

Written By

Rachel Barnett

In this tutorial, you’ll learn how to import your customer data into QuickBooks Online from an Excel file.

Quick Instructions:

Click the gear in the upper right corner
Under TOOLS click Import data
Click Customers
Click Browse, select your Excel file, click Open
Click Next in the lower right corner
Check matched mappings are correct
Map any fields that weren’t automatically mapped
Click Next
Double-check the list of what’s importing
Click Import in the lower right corner

Keep reading for a complete walkthrough with screenshots:

Upload Your Customer List into QuickBooks Online

To start click the gear in the upper right corner. Under TOOLS click Import data.

On the Import Data screen you have several options, click on Customers.

In this example, we’re uploading an Excel file. In the Select a CSV or Excel file to upload box click Browse. Find your file and click Open. Then click Next in the bottom right corner.

On the next screen, map the fields in your uploaded file to fields in QuickBooks Online.

My example file only had customer names with the heading Customer. It automatically matches it to the QBO Name field.

It will try to match as many fields as it can. These fields will have a little green checkmark flag next to them. Double-check that it matched correctly and match up any other fields you have in your file. Then click Next in the bottom right corner.

Next, it shows you a list of the customers that are ready to import. Double-check again that it matches the file you’re uploading.

Here you can see a side-by-side of my customer data file and what’s importing into QuickBooks.

When you’re ready click the green Import button in the lower right corner.

To view your imported customers in QuickBooks click Sales -> Customers in the left side menu.

I had no customers in QuickBooks before this so I can quickly see that all of my customers imported successfully.

You now know how to import your customer list into QuickBooks Online from an Excel file.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a video if you prefer to watch a walkthrough.

If you have any questions about importing data into QuickBooks Online click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?

Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.