How to download suppliers list from your QBO account?

Learn how to download your suppliers/vendors list from QuickBooks Online (QBO), making it easy to manage and access supplier data for better financial control.

Export Supplier Data from QuickBooks Online to a CSV File

Let's understand how to download supplier data from QuickBooks Online (QBO) into a CSV file and upload it to any platform of choice.

To download a CSV of suppliers from QuickBooks Online, follow these steps:

Log in to your QuickBooks Online account.

QuickBooks Online sidebar with Suppliers highlighted under Bookmarks, opening the list of suppliers to export.

Please go to the "Suppliers" tab on the left sidebar to view the list of your suppliers.

Click on the gears icon located at the right corner of your screen.

QuickBooks Online Suppliers list with the gear icon highlighted above the Open Balance and Action columns.

This allows you to select which fields to export, such as address, attachments, tax slip, phone, email, and currency.

QuickBooks Online supplier list settings with Address, Phone, Email and Currency columns checked for export.

After selecting the fields, a window will appear with the option 'Export to Excel'. Click this to download the file to your computer.

QuickBooks Online Suppliers list toolbar with the Export icon highlighted between the print and gear icons.

Once the file is downloaded: Open the downloaded file in Microsoft Excel or Google Sheets.

Exported QuickBooks supplier list in Microsoft Excel with the File tab highlighted above the Supplier and Company columns.

Go to the 'File' tab, select 'Save As' option to copy the file in your computer.

Microsoft Excel File menu with Save As highlighted, used to resave the exported supplier list.

Please ensure the file is saved in 'CSV format'.

Excel Save As dialog with CSV UTF-8 (Comma delimited) selected as the file type for the supplier list.

Your suppliers' information is now in CSV format and ready to be imported into any platform for streamlined management.

Let’s make AP
work for you.