What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Export a Customer List From QuickBooks
QuickBooks Online and Desktop

How to Export a Customer List From QuickBooks, With the Columns You Need

The fast way is one icon above your customers page. It gives you names, contact details and balances in a spreadsheet. When you need more control over the columns, such as billing and shipping addresses side by side, the Customer Contact List report is the better export. Desktop has its own Excel button in the Customer Center.

Export customers in two clicks

QuickBooks Online: open your customers page and click the Export icon next to Print, above the list. The menu is Sales, Customers in the classic layout, or Customer Hub, Customers & leads in the newer one.

Sales Customers Export icon

QuickBooks Desktop: open the Customer Center, click Excel at the top, and choose Export Customer List.

Customers Customer Center Excel Export Customer List

Need chosen columns? Run the Customer Contact List report, change its columns, then export it.

Reports Customer Contact List Export

Customers page export or contact report?

Customers page icon

Quick and fixed

  • Two clicks from the list you already have open.
  • Comes with Intuit's set of columns, including the open balance.
  • Good for a quick check, or for sending the accountant who owes what.
Customer Contact List report

Slower, but your columns

  • You choose every column and the sort order.
  • Shipping addresses, terms and custom fields can come along.
  • Better for a mailing, or for importing into another system or a second QuickBooks company. Importing from Excel covers the receiving end.

If the file is going into another tool, use the report, and match its columns to what that tool's import asks for.

Exporting the Customer Contact List report

In QuickBooks Online, this is the route that lets you decide every column before the file is made.

  1. 1

    Run Customer Contact List

    Reports Search: Customer Contact List

    Type the name in the search box on the Reports page. It's a list report, so there's no date range to set.

  2. 2

    Choose which fields come along

    Open the report's customize or column options and tick what you need: email, phone, billing address, shipping address, terms, notes and so on. Untick the ones you don't, so the sheet's easier to use.

    Watch for: the filter for inactive customers. Decide whether former customers belong in this file before you export.

  3. 3

    Sort it the way you want it

    Sort by name, city or anything shown. The file comes out in the order and with the columns you see on screen.

  4. 4

    Export

    Choose Export to Excel, Export as CSV, or Export to Google Sheets. CSV is the one most mailing tools and CRMs expect for an import.

    Watch for: leading zeros. Excel can strip them from ZIP codes when it opens a CSV. Import the file as text, or check a few New England addresses afterward.

Missing customers and broken columns

The file has fewer customers than you expected

How you'll know: Customers you know exist aren't in the spreadsheet.

Fix: The export follows what's on screen. A filter for active only, or a search left in the box, cuts the list. Clear them and export again.

Sub-customers and projects show up as their own rows

How you'll know: One client appears several times, once per job.

Fix: That's how QuickBooks stores them. Sort by the parent customer name, or filter the rows out in the spreadsheet if you only want the top level.

Emails or addresses are missing

How you'll know: The quick export has the customer but not the field you needed.

Fix: Use the Customer Contact List report above and add the column. If it's blank there too, it was never entered on the customer record.

Desktop's Excel option won't work

How you'll know: The button is grayed out, or Desktop can't find Excel.

Fix: Desktop builds the file through the Excel on your computer, so the install has to be working. Our export to Excel guide has the fix.

Exporting customers and other QuickBooks data

How do I export data from QuickBooks in general, not just the customer list?

Every report and list has its own export. In QuickBooks Online, Settings, then Export data also bundles your reports and lists into one .zip of Excel files, which is handy before an audit or a move. Estimates and purchase orders aren't in that bundle, since they don't post to the books. Desktop exports reports from each report's Excel button.

How do I export customer data that includes more than just names and emails?

Run the Customer Contact List report and add the columns you want, such as phone, billing and shipping addresses, terms or notes, then export it as Excel or CSV. On Desktop, the Customer Center's Excel menu exports the list with its fuller set of fields.

Does exporting the customer list change anything in QuickBooks?

No. An export only reads your data and writes a copy to a file. Customers, balances and history stay exactly as they were, and you can export as often as you like.

Can I edit the exported list and import it back?

QuickBooks Online can import customers from a spreadsheet, but the import is built for adding customers, not for updating ones already there, so edits in the file won't flow back into existing records. Change those in QuickBooks itself, and keep the import for new customers or a fresh company. See adding a customer.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.