The Excel Add-In is a powerful tool that allows you to read, write, update, and delete live Magento data, directly from Microsoft Excel.
OverviewBack 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:
- Install the Add-In
- Login with Magento User & Password
- 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 NotesBack to top
- Compatible with CE: 1.3 1.4 18.104.22.168 1.4.2 1.5 1.6 1.6.1 22.214.171.124 1.7 1.8 1.8.1 1.9 1.9.1 1.9.2 1.9.3
- Stability: Stable Build