To export customer information from QuickBooks to Excel:
- Click the Tools icon in the top right of Quickbooks.
- Select Export Data
3. Click the 'List' Tab, remove the Employees and Vendors options and click Export To Excel.
To export vendor information from QuickBooks to Excel:
- Click the Tools icon in the top right of Quickbooks.
- Select Export Data
3. Click the 'List' Tab, remove the Customers and Employees options and click Export To Excel.