How to Export Lists From QuickBooks Online

In this tutorial, you’ll learn how to export lists from QuickBooks Online.

Quick Instructions:

Export Customer, Employee & Vendor lists:

  1. Click the gear icon in the upper right corner
  2. Under TOOLS click Export data
  3. Click the Lists tab
  4. Select the lists you want to export
  5. Click Export to Excel

Export the Chart of Accounts:

  1. Click Accounting -> Chart of accounts
  2. Click the Run Report button on the right
  3. Click the export icon (box with an arrow)
  4. Click Export to Excel

Export Products & Services Lists:

  1. Click the gear icon in the upper right corner
  2. Under LISTS click Products and services
  3. Click the export icon (box with an arrow)

Keep reading for a complete walkthrough with screenshots:

Export Customer, Employee & Vendor Lists

To begin click on the gear in the upper right corner. Under TOOLS select Export data.

Navigating to Export Data in the gear menu in QuickBooks Online
Export Data

When the Export data screen opens you’ll be on the Reports tab. Click over to Lists.

Export Data lists tab in QuickBooks Online
Export Financials

In the lists tab, you have the option to export:

  • Customers
  • Employees
  • Vendors

To the right toggle which lists you’d like to export then click the Export to Excel button.

Exporting data from for all lists in QuickBooks Online.
Export Masters