How To Export Customer List from QuickBooks to Excel

January 4, 2022

Fixing a robot

How To Export Customer List from QuickBooks to Excel

Here is a quick 1-minute guide on how to export your customer list from QuickBooks to Excel.


1. Go to QuickBooks

2. Open your Reports

Open your Reports

3. Click on Customer Contact List

Click on Customer Contact List

4. Click on the Download/Export Icon

Click on the Download/Export Icon

5. Select "Export to Excel"

Select "Export to Excel"

Before you leave! There is a much faster way to do this

Connect QuickBooks to your Google Sheet and import your Customer List from QuickBooks to your spreadsheet without any manual work.

Want to update your Customer List in your spreadsheet? No problem, just refresh your spreadsheet and your Customer List will be up-to-date. 

Join hundreds of accountants and finance teams on LiveFlow


Try LiveFlow for free here

How do I get started?

  1. Install LiveFlow for free here
  2. Open a Google Sheet → Open Extensions → Click LiveFlow
  3. Connect your QuickBooks account — And to make it even better, you can connect unlimited QuickBooks accounts.
  4. Select reports and choose Customer List
  5. Click Create Live Report and your customers will now be synced to your Google Sheet
  6. To refresh your Customer List, simply head to ExtensionsLiveFlowRefresh All Reports and your data will now be up-to-date

Why you should use LiveFlow instead of manually importing and exporting to Excel?

  • You can connect unlimited QuickBooks accounts! Working with 20 clients or have 5 different entities? No problem at all.
  • Save countless hours of manual work, and spend more time growing your business.

Try LiveFlow for free here

Loved by hundreds of finance professionals automating financial workflows with LiveFlow

  • Cheryl Lanahan, Plumbooks - "LiveFlow saves me time and tedium - no more downloading, copying and pasting into my spreadsheet. I LOVE it!!"
  • Jana Kovacovska, TinyCFO - "Automating whatever can be automated is always a good idea, LiveFlow helps with that"
  • Dan DeGolier, AscentCFO - "Our initial impression of LiveFlow is that it can be a big time-saver! We're excited to partner with them"
  • Josh Greenbaum, CFO Minded - "I just linked my first client and I honestly love this tool you’ve built!"

Try LiveFlow for free here

Learn more about LiveFlow here:


Continue reading

Bring financial data into Google Sheets. Fast.

Try out our Google Sheets Add-On and bring your P&L, Balance Sheet and Cash Flow into Google Sheets in no time.

Capterra & LiveFlow
G2 & LiveFlow Reviews
LiveFlow reviews on Product Hunt
Check it out!