cancel
Showing results for 
Search instead for 
Did you mean: 
DaveHydock
Level 1

Exporting Client List from QBO to Excel

I want to export my client list from QBO to Excel for the purposes of doing a mailing.  However, when I do so, Quickbooks exports not only the client name, but every single transaction we've had with them.  This results in duplicate info.   How do I export the name only, and not the sales history?  

1 Comment 1
Shania_C
QuickBooks Team

Exporting Client List from QBO to Excel

A warm welcome to you in the Community space, @DaveHydockLet me help you export the clients list from QuickBooks Online to Excel.

 

When exporting from a Reports page, you have the option to customize the customer's data and export it to Excel. However, if you need to make more specific changes to the information, you can follow the steps below to do so. 

 

  1. Go to Reports.
  2. Under the Sales and Customer section, select Customer Contact List.
  3.  Customize
  • Select Columns
  • Select the eye icon to hide a column (hide all lists except customers' full name column)
  • You have to option to Save customization at the upper right or directly Export to Excel.
     

 You may refer to this article if you want to export your QuickBooks Online reports and lists, so you can easily download the data, entered into your file to your local hard drive.

 

If you have other questions or need assistance, please feel free to reach out. Keep Safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us