How to export customer list from QuickBooks to excel? 7 steps to solve your issue.

How to export customer list from QuickBooks to excel? 7 steps to solve your issue.

If you are using QuickBooks then rest assured that you will never lose your customer contacts. This is because the software saves the list of your contacts and other relevant info. automatically, and within itself. This makes it really convenient for the QB user to invoice their customers as and when required without any loss of time and energy. Since customers are of prime importance to any business thus here is how to export customer list from QuickBooks to excel.

Are you a Quickbooks user?

If you ever want your customer list to be used externally, then all you need to do is export the file to excel. If you are new to using QuickBooks and don’t know “How to export customer list from QuickBooks to excel” then just follow the step by step process here.

Steps to export customer list from QuickBooks to Excel.

Using the functionality (customer center) within the program you can easily transfer your customer list from Quickbooks to excel with ease. All you would need is to download the file in a .csv format. To download your file, follow the steps below:

  1. Login to your QuickBooks account.
  2. From the top navigation menu, locate and click on the customer center You will now see a different window being displayed.
  3. If you have a list of selected customers that you want to export then choose them one at a time. To see the list of all the customer, click on the customers & Jobs tab and you will now be able to view the complete list.
  4. Filters come in handy if you want to export the list of only those customers who fulfilled certain action. E.g. customers who live in a certain location and visit you frequently. To apply filters, click on the down arrow under view tab and specify your criteria.
  5. To download your report to excel, click on the excel tab at the top of your displayed window. Choose to click on “Export customer list” tab.
  6. From your active screen, choose to create a new worksheet. If you want your excel file to be nicely formatted with all the values separated by comma’s then click on the Advanced tab. Check mark the box where it says, keep comma separated values within your Excel file.
  7. Finally when you are ready with your specified criteria then click on the Export button. Your file will now be successfully exported in a .csv format with excel.

Exporting or downloading a file from QuickBooks is not a complicated process at all, but if you are new to using a program then you may face issues. Though we tried to cover every aspect of your query “How to export customer list from QuickBooks to excel”, but if you still find issues then do write to us in the comment section below. If you need any instant help then give us a call and talk to our QuickBooks proadvisor now.

Still in Doubt…!

Request a Call Back

Talk to our Quickbooks Proadvisor and resolve your issue over a phone call.

We gaurantee 100% satisfaction

You can even give us a call at our Quickbooks Technical Help for USA, UK and Canada at ✆ +1800-940-7442 and talk to our Proadvisor now.

Related Articles:

Report Your Issue

(Didn't find what you were looking for! Report your issue and get customized help from our QuickBooks experts.)

QuickBooks Version:
Edition Year:
No of User: Licence
HELP Needed:
Operating System:

What is Qbpro?

We are a Quickbooks and TurboTax consulting firm that takes care of all the issues that people might ever face within these programs. If you are using any of the above platforms and are continuously faced with bugs then we are here to help. You can connect with us for errors related to Quickbooks or TurboTax via any of the medium below:

What Our Clients Say...

Here is what people have to say about us.

Areas we serve:

We are proud to announce that we are covering entire Canada. Thus if you face any issues now, give us a call as our proadvisors work 24/7 to get your issues fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Me

Leave a Message

Disclaimer: is a reputable QuickBooks® Consulting firm that provides professional support services related to your accounting software. It is also a front-runner in providing 3rd party technical support services for quickbooks.


"Get QuickBooks Support, no matter where you are living in Canada. Just Call and get issues fixed."

Alberta British Columbia Manitoba New BrunswickNewfoundland and Labrador Northwest Territories Nova ScotiaNunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon


Are you confused and not able to manage your books on QuickBooks…!

Dial us: ✆ +1800-940-7442

Still facing issues

Get Help For Your QuickBooks Accounting Software

Resolve your every issue on a
Free 30 minutes call

Enter your details to get a cheat sheet of 96 awesome tricks to use Quickbooks like a pro.

We hate SPAM and promise to keep your email address safe.

Get FREE 30 minutes, Resolve your issues now!

Call Now: 1-800-940-7442