Excel Add-In

Excel Add-In

Compatible With: Community 1.3, 1.4,, 1.4.2, 1.5, 1.6, 1.6.1,, 1.7, 1.8, 1.8.1, 1.9, 1.9.1, 1.9.2, 1.9.3

Tech Specifications

Current Version:
Stable Build
21 September, 2017
Extensions, Reporting & Analytics
License Type:


The Excel Add-In is a powerful tool that allows you to read, write, update, and delete live Magento data, directly from Microsoft Excel.

Other Extensions by CData Software


Back to top

The Excel Add-In for Magento provides the easiest way to connect with Magento data in Microsoft Excel. Microsoft Excel is a spreadsheet application developed by Microsoft and has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Users simply supply their Magento credentials via the connection wizard to create a connection and can immediately begin working with live Magento tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.

NOTE: Microsoft Excel is a separate product. Additional fees may apply

Bi-Directional Access To Live Magento Data From Excel

The Excel Add-In for Magento 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 Magento 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 Magento Data.

Magento 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.

Release Notes

Back to top


  • Compatible with CE: 1.3 1.4 1.4.2 1.5 1.6 1.6.1 1.7 1.8 1.8.1 1.9 1.9.1 1.9.2 1.9.3
  • Stability: Stable Build
  • Description:



Back to top
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Q & A

Back to top


Back to top