About exporting data to an Excel or CSV file
Using the Customer or Vendor Center, you can export data about the
people you do business with and the transactions associated with them.
What fields are exported?
QuickBooks exports all customer fields that can be imported except for Preferred Send Method, Price Level, and Preferred Payment Method.
QuickBooks exports all vendor fields that can be imported.
Click the Center containing the list you want to export.
Display the customers or vendors you want to export.
If necessary, click the Customers & Jobs or Vendors tab.
(Optional) Click the View drop-down arrow and select a filter.
By filtering the list, you can determine whether QuickBooks exports all
list entries or only those that meet certain criteria.
In the Center, click the Excel drop-down arrow and select Export Customer List or Export Vendor List.
In the Export window, choose whether to create a new worksheet, update an existing worksheet, or export to a comma separated values (.csv) file.
Click the Export button.
You can also export transactions displayed in the Transactions tab.