Excel Add-In for Dynamics 365 Business Central

Read, Write, and Update Dynamics 365 Business Central from Excel

The Dynamics 365 Business Central Excel Add-In is a powerful tool that allows you to connect with live Dynamics 365 Business Central data, directly from Microsoft Excel. Use Excel to read, write, and update Items, Sales Orders, Purchase Orders, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

  download   buy now

CData Excel Add-In for Dynamics 365 Business Central
 Included in Excel Add-In Subscriptions: 125+ Excel data access Add-Ins.

Your Dynamics 365 Business Central Data, Your Way!

The Excel Add-In for Dynamics 365 Business Central provides the easiest way to connect with Dynamics 365 Business Central data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live Dynamics 365 Business Central tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.

Bi-Directional Access To Live Dynamics 365 Business Central Data From Excel

The Excel Add-In for Dynamics 365 Business Central is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.

Easy-To-Use, Straightforward Configuration:

  1. Install the Add-In
  2. Login with User & Password
  3. Select Tables

Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.

Select Tables and Columns

Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live Dynamics 365 Business Central Data.

Dynamics 365 Business Central Data With The Full Power of Excel

Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

  • Modify and delete Records.
  • Quickly export and backup data.
  • Operate on data with Charts and Pivot Tables.