Description

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

Save modified data back to the data source

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.

Additional Information