How to export vendor list from your Microsoft Dynamics 365 account?

Learn how to easily export your vendor list into a CSV file from your Microsoft Dynamics 365 account, ensuring you have a comprehensive record of your vendors for efficient data management.

Export Vendor Data from Microsoft Dynamics 365 to a CSV File

Let's explore how to export supplier/vendor information from your Microsoft Dynamics 365 accounting software into a CSV file. This article will provide you with step-by-step instructions on how to download your vendor data and prepare it for upload with Finofo's platform.

Dynamics 365 Business Central home page with the Vendors link highlighted next to Customers and Items.

From your Dynamics 365 dashboard, navigate to the 'Vendors' section. Here, click on 'Reports', then select 'Vendor Listing'.

Dynamics 365 Business Central Vendors page with the Reports menu open and Vendor - Listing highlighted.

On the Vendor Listing page, find and click on 'Send to'. This action will redirect you to a page where you can select the report layout.

Vendor - Listing report options in Dynamics 365 Business Central with the Send to button highlighted.

Choose 'Microsoft Excel Document (data only)', then click 'OK' to initiate the download of an Excel file to your computer.

Business Central Choose file type dialog with Microsoft Excel Document (data only) selected and OK highlighted.

Once the file is downloaded, open it in Microsoft Excel and review the content. You now have a file containing your supplier information.

Let’s make AP
work for you.