Excel Add-ins

Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets.

With Devart Excel Add-ins you can get exactly the data you need with visual Query Builder or with SQL and refresh the queried external data in a workbook any time with a single click. External data can be edited as you usually do it in Excel, and then saved back to the data source.

  • Connect Microsoft Excel to various data sources
  • Work with live data directly in Excel
  • Modify external data easily
Devart ribbon tab

Supported Data Sources

 

How Devart Excel Add-ins Can Help You

Import external data to Excel

Powerful Data Import

Devart Excel Add-ins allow you to precisely configure what data to load into the document. They allow selecting objects and columns and setting complex data filters. If this is not enough, all the power of SQL is to your service, not only for relational databases, but for cloud applications too!

Quick data refresh

Quick Data Refresh

The main Devart Excel Add-ins benefit is that it allows you to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time. You can refresh data in your workbook easily whenever you want.

Edit external data with Excel

Easy Data Modification

You can edit data in Excel just like you usually do it, add or delete rows, modify cell values, etc. Use full power of Excel to perform mass data update, insert, and delete operations against your data source. After you finished editing, just click Commit and the changes will be posted back to the data source.

Discount Programs

Send us a link to your MVP profile and get a free license for any Devart SSIS DataFlow Components!

MS MVP

You can get a significant discount, and even a free license, by spreading a word about Devart Excel Add-ins.

Devart High Five Program for Devart Excel Add-ins