MOST POPULAR

HOW TO ADD A CUSTOMER | GET STARTED TUTORIAL

How to import and add customers

Learn how to easily and efficiently manage your customers.

Adding customers will help you keep track of all your outgoings and incomings. You can easily import a list of customers from existing spreadsheets.
How to import and add customers

Benefits include

Image Alt Text

Conveniently manage

all your customers
Image Alt Text

Quickly and easily

manage money-in transactions

Image Alt Text

Record payments

against customer invoices

Step-by-step guide

Adding a customer from the Customers & leads tab

Step 1

  • From the left menu, select Customers & leads.
  • Select the Customers tab.
A person is walking with a laptop on her lap.

Step 2

  • Select Add customer manually.
  • Add a Display Name for your customer and email.
  • Add as much additional information as you want to record for your customer, including telephone numbers, address, and payment information.
Image Alt Text

Step-by-step guide

Import customers from a CSV file

Step 1

  • Go to Customers & leads, then select Customers.
A person is walking with a laptop on her lap.

Step 2

  • Select Import Customers.
Image Alt Text

Step 3

  • Click Browse, select your excel file and Open, then Next
Image Alt Text

Step 4

  • For each of the QuickBooks Online (QBO) fields on the screen, choose one of your excel columns. This action tells QuickBooks which columns in your excel spreadsheet get pulled into which QuickBooks field. Click Next when you have completely mapped your fields to QuickBooks.
  • Learn more about how to name your columns and what information will be imported here.
Image Alt Text

Step 5

  • The next page shows your data and where it's going into QuickBooks. Make sure you check the box on the left for all the items you want to import.
  • When you're ready, click on Import.
Image Alt Text

Related Resources

Image Alt Text
HOW TO

How to edit customer information

Change details such as payment methods or billing address.

Image Alt Text
VIDEO

Send an invoice

Learn how to send an invoice.

Image Alt Text
VIDEO

Send invoice reminders

Get paid faster by sending invoice reminders automatically.

Need more help?

Get started icon

Getting started hub

All you need to start getting the most out of QuickBooks.

Help icon

Visit support site

Search thousands of help articles on our Support Site.

Search button icon

Use help button

Use the help button from any page within QuickBooks Online to search articles or connect with an expert.

Community icon

Ask the community

Get help and links to useful resources from other small businesses using QuickBooks.