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
How Devart Excel Add-ins Can Help You
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
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.
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.
