Excel Add-In for Microsoft Dynamics NAV
Read, Write, and Update Dynamics NAV from Excel
The Dynamics NAV Excel Add-In is a powerful tool that allows you to connect with live Dynamics NAV data, directly from Microsoft Excel. Use Excel to read, write, and update Dynamics NAV Items, Sales Orders, Purchase Orders, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Install the Add-In, configure your Dynamics NAV connection, and go!
Your Dynamics NAV data, your way!
The Excel Add-In for Dynamics NAV provides the easiest way to connect with Microsoft Dynamics NAV data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live Microsoft Dynamics NAV tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.
Access Dynamics NAV data directly from Excel
Direct Access
Bi-Directional access to live Microsoft Dynamics NAV Data from Excel
The Excel Add-In for Dynamics NAV is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.
Setup
Easy-to-use, straightforward configuration
- Install the Add-In
- Login with user & password
- Select tables
Installing the CData Dynamics NAV Excel Add-In creates a dedicated toolbar in Excel, giving users instant access to Microsoft Dynamics NAV data for faster data analysis and reporting. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.
Data Selection
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 Microsoft Dynamics NAV Data.
Data Analysis
Microsoft Dynamics NAV 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.
FAQs
Frequent Dynamics NAV Excel connectivity questions
Common questions about integrating Dynamics NAV with Microsoft Excel.
Popular Excel Videos:
Download the Dynamics NAV Excel Add-In
Building custom dashboards & reports that connect with live Dynamics NAV data has never been easier. Download the CData Excel Add-In for Dynamics NAV now, and get connected.