Cdata Software has created The Magento Excel Add-In, which is a powerful tool that allows you to connect with live Magento data, directly from Microsoft Excel. Use Excel to read, write, and update Customers, Inventory, Products, Orders, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Add-in features:
-Bi-directional access: Cdata Add-In provides users with the ability to read and write Magento data form within excel. Live connection: Instead of working with a static data dump in Excel, the Add-In lets you refresh the connection as often as you want, ensuring that you're working with the most up-to-date data when you need it.
-Easy-to-use: The Add-In is easy to install and is used directly from within Excel. You simply need to configure the connection to Magento and logging in.
-Self-contained: The CData Excel Add-In is completely self-contained, so there's no additional software required.
-Familiar: The CData Excel Add-In puts your Magento data in Excel, where you're already comfortable working with data.
https://www.cdata.com/drivers/magento/excel/
