How to Import Customers into QuickBooks Online from Excel or CSV?

Importing customers into QuickBooks Online is the process of transferring customer contact details, such as names, email addresses, phone numbers, and billing information. It helps businesses quickly set up or update their customer database without manually entering each record, reducing errors and saving significant time.

However, the process is not always seamless. Users often encounter common error messages such as “File format not supported,” “Missing required fields,” “Duplicate customer detected,” or “Invalid email address format.” These issues usually occur due to incorrect file structure, incomplete data mapping, or formatting inconsistencies within the spreadsheet.

In this guide, we’ll discuss when to import customer data, prerequisites before importing, step-by-step methods using the native QuickBooks tool, importing via Dancing Numbers, how to verify imported records, and answer frequently asked questions.

When Do You Need to Import Customer Data into QuickBooks Online?

You typically need to import customer data when:

• You are switching from another accounting software
• You have a large customer list stored in Excel or CSV
• You want to avoid manual data entry errors
• You are setting up a new QuickBooks Online account
• You regularly update customer records in bulk

Prerequisites: What to Prepare Before Importing Customers?

Before importing customers into QuickBooks Online, you must prepare your system, file, and data carefully. Proper preparation reduces import errors, prevents duplicate entries, and ensures smooth data migration.

System and Account Requirements

• Ensure your QuickBooks Online account is active and properly set up before starting the import.
• Verify that you have the required user permissions (admin or standard access with import rights).
• Check the file size before uploading. The file should be up to 2MB or 1000 rows.
• If your customer list is larger than this limit, split it into smaller files and perform multiple imports.
• Avoid importing sub-accounts, as QuickBooks Online does not support them. Convert sub-accounts into parent accounts before importing. After completing the import, you can manually restructure them back into sub-accounts if needed.
• Be careful during re-imports. If you import the wrong file or repeat an import, QuickBooks will not overwrite existing data. Instead, it will create duplicate entries, which you must manually delete or edit.

File Format Requirements (Excel and CSV)

To ensure a successful import, your spreadsheet must follow strict formatting rules:

• Use supported file types: Excel (.XLS/.XLSX) or CSV (.CSV).
• Ensure the spreadsheet does not contain any blank rows, charts, or formulas.
• The file must include only valid contact data.
• The first row should always contain clear headers (e.g., Name, Email, Phone).
• Verify that the spreadsheet is free from errors before uploading.
• Remove any unwanted characters such as quotation marks or colons, as they may cause import failures.

Customer Fields You Can Import from Excel into QuickBooks

When preparing your file, include only supported and properly formatted fields. QuickBooks allows you to import key customer details such as:

• Customer Name (must be unique for each entry)
• Company Name
• Phone Number
• Billing Address
• Shipping Address
• Opening Balance (if applicable)
• Notes or additional customer information

Method 1: Import Customers into QuickBooks Online Using the Native Tool

QuickBooks Online allows you to easily upload customer data from Excel or CSV files. Here are the steps to import customers into QuickBooks Online.

Step 1: Prepare Your Excel or CSV Spreadsheet

Before importing, you must properly structure your spreadsheet to ensure QuickBooks can read and map your data correctly. A properly prepared file reduces errors during import and ensures smooth data transfer. Here are the steps to prepare your spreadsheet:

• Firstly, create a new spreadsheet in Microsoft Excel or Google Sheets.
• Ensure you are working on Sheet 1 and keep all data in a single sheet.
• In the first row, add column headers in capital letters (e.g., NAME, EMAIL, PHONE).
• Make sure there are no blank columns or empty header fields.
• Ensure each row contains complete customer contact information.
• Verify that the spreadsheet structure aligns with QuickBooks import fields.
• Save the file in the correct format, such as .XLS or .XLSX (or CSV if required).
• If you are using Google Sheets, the file will be automatically saved and can be downloaded in Excel format.
• Finally, review all data carefully to ensure accuracy and consistency before moving to the next step.

Step 2: Map Customer Fields to QuickBooks Contact Fields

Once your file is ready, the next step is to connect your spreadsheet columns with QuickBooks Online fields for accurate data placement. In this step, you will upload your file and match each column with the corresponding field in QuickBooks Online. Here are the steps to map your customer fields:

• Firstly, sign in to your QuickBooks Online account.
• Click on the Gear icon in the top right corner.
• Select Import Data from the menu.
• Choose the Customers tile to begin the import process.
• Click Browse, select your prepared file, and then click Next.
• On the “Map your fields” screen, match your spreadsheet columns with QuickBooks fields.
  • Example: Map Customer Name < Name
  • Example: Map Email < Email Address
• Ensure all required fields are correctly mapped without mismatches.
• After completing the mapping process, click Next to proceed.

Step 3: Run the Import and Review Results

In this final step, you will complete the import process and verify that all customer records have been uploaded correctly into QuickBooks Online. Here are the steps to finalize the import:

• Firstly, review the import preview screen carefully.
• Check all customer details displayed before final submission.
• Edit any incorrect information directly on the preview screen if needed.
• Uncheck any customers that you do not want to import.
• Once everything looks correct, click Import to start the process.
• After completion, go to Sales > Customers to verify all imported records.
• Ensure that all customers appear correctly in the list without missing data.
• Finally, confirm that all records are accurate and properly stored in your account.

How to Import Customer and Vendor Contacts from Excel into QuickBooks?

QuickBooks Online allows you to import both customer and vendor contact details from an Excel file in bulk. This method is useful when you want to migrate complete contact lists quickly without entering data manually.

Step 1: Create an Excel File for Importing

In this step, you will prepare a properly formatted Excel file that QuickBooks can read and process without errors. Here are the steps to create and structure your spreadsheet:

• Firstly, create a new Excel spreadsheet on your system.
• After that, ensure that Row 1 contains only column headers and no blank cells or extra titles above it.
• Next, add the following required headers in Row 1:
  • Full Name
  • Company
  • Email
  • Phone
  • Mobile
  • Fax
  • Website
  • Street
  • City
  • State
  • Postal Code
  • Country
• Then, carefully enter the contact details for each customer or vendor in the rows below the headers.
• Make sure each row represents one contact record only.
• After entering all data, save the file in .XLS or .XLSX format.
• Finally, note down the saved file location so you can easily browse and upload it during import.

Step 2: Complete the Importing Process

Once your Excel file is ready, the next step is to upload it to QuickBooks Online and complete the import process for customers or vendors. Here are the steps to finish the import:

• Firstly, sign in to your QuickBooks Online Company Account.
• Go to the Customers menu (or relevant section where import options are available).
• Then, navigate to the Tools section and select Import Data.
• After that, choose either Customers or Vendors, depending on what you want to import.
• Next, click the Browse option to upload your prepared Excel file.
• Locate your saved file and click Open.
• Then, hit the Next button to continue the process.
• Again, click Next after QuickBooks reads and processes the data.
• At this stage, review the imported data carefully and adjust any incorrect field mappings if required.
• Finally, click the Import button to complete the process and successfully add your contacts to QuickBooks Online.

Method 2: Import Customer List into QuickBooks Online Using Dancing Numbers

Dancing Numbers Online is a third-party automation tool that simplifies bulk data import into QuickBooks Online. It is especially useful when dealing with large customer lists or when you want more control, validation, and error handling than the native QuickBooks import tool offers.

Requirements Before Starting the Dancing Numbers Import

Before you begin importing customers using Dancing Numbers, you must ensure that your system, data file, and QuickBooks account are properly set up. This helps avoid errors during syncing and ensures a smooth import process.

Here are the key requirements you need to fulfil:

• Firstly, Ensure you have an active QuickBooks Online account with admin or appropriate access rights.
• After that, create and prepare a clean customer list in Excel (.XLS/.XLSX) or CSV format.
• Make sure your file does not contain blank rows, duplicate entries, or incorrect formatting.
• Then, verify that all required customer fields (such as name, email, phone, and address) are properly filled.
• Ensure your system has a stable internet connection to avoid interruptions during syncing.
• Next, log in to your Dancing Numbers Account and connect it with your QuickBooks Online company.
• Confirm that you have selected the correct company file before starting the import process.
• Finally, review your data once again to ensure it is clean, structured, and ready for bulk upload.

Steps to Import Customer List Using Dancing Numbers Online

In this process, you will upload your Excel or CSV file into Dancing Numbers, map the data fields, and complete the import into QuickBooks Online in a structured flow.

Step 1: Start the Import Process and Upload File

In the first step, you need to initiate the import process and upload your customer file into the system. Here are the steps to start the import process and upload a file.

• Click on the Start button under the import box
• Then click on “Click to browse or drag and drop files here.”
• Select your Excel or CSV file from your system
• Wait for the file to upload successfully

Step 2: Select File Type and Data Category

In this step, you will define what type of data you are importing and how QuickBooks should recognize it.

• Under Select Excel sheet to use, choose the correct sheet containing customer data
• Under Select a QuickBooks transaction or list, choose Customer
• Then click on the Next button to proceed

Step 3: Confirm and Proceed

In this step, you will confirm your selection before moving to data mapping.

• A dialog box will appear after clicking Next
• Click OK to confirm
• Review the displayed information on the screen
• Then click Next to continue

Step 4: Map or Match Fields

In this step, you will align your Excel columns with QuickBooks fields to ensure correct data placement.

• Match fields manually using the drop-down options for each column
• Or click on Field Match to auto-map columns automatically
• If needed, click Save As to store your mapping for future use
• You can later use Load Map to reuse saved mappings and save time
• After completing mapping, click Next

Step 5: Review Final Preview

In this step, you will verify the data before final import.

• Review the final preview of all customer records
• Click Next after confirming everything is correct
• Check for any missing or incorrect information on the next screen
• Select the appropriate payment method and payment type if required

Step 6: Import the File into QuickBooks

In the final step, you will complete the import process and transfer data into QuickBooks Online.

• Click on Import File
• Then click OK to confirm
• Wait while the system processes and imports all customer records
• Once completed, you will see a success message:
  • “The file has been successfully imported.”
• Finally, verify the imported customers inside QuickBooks Online to ensure accuracy

Is the Dancing Numbers Import Manual or Automatic?

Yes, Dancing Numbers is a semi-automated accounting tool that simplifies data management in QuickBooks by handling import, export, and deletion processes. Though you need to upload and map the data, the tool automatically processes and imports it into QuickBooks.

How to Verify Your Imported Customer Data in QuickBooks Online?

After importing your customer data, it is important to verify everything carefully to ensure accuracy, prevent duplicates, and maintain clean records for reporting and accounting.

Step 1. Review the Imported Customer List

In this step, you need to open the customer section in QuickBooks Online to see all the records that were imported.

• Open the QuickBooks Online dashboard
• Click on the Sales or Customers menu
• View the full list of imported customers

Step 2. Match the Imported Record Count

In this step, you should compare your original file with QuickBooks data to ensure no customer records are missing.

• Count total rows in your Excel or CSV file
• Match it with the QuickBooks customer list
• Identify missing entries if numbers do not match

Step 3. Check Individual Customer Details

Here, you must verify whether each customer record has been imported correctly with accurate information.

• Click on random customer entries
• Verify name, email, phone number, and address
• Ensure no fields are blank or incorrect

Step 4. Identify Duplicate Entries

In this step, you should look for repeated customer records that may have been created during re-imports.

• Scan customer list for repeated names
• Check for similar email or phone numbers
• Merge or delete duplicates if found

Step 5. Fix Missing or Incorrect Data

Here, you need to correct any incomplete or wrongly mapped information after import.

• Edit missing or incorrect fields manually
• Correct formatting issues in emails or addresses
• Save updated customer profiles

Step 6. Confirm Overall Data Accuracy

In the final step, you should review the entire dataset to ensure everything is clean, consistent, and ready for use.

• Recheck the complete customer list
• Ensure uniform formatting across records
• Confirm data is ready for reporting and transactions

---

Frequently Asked Questions