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
Ranked in these QuestionsQuestion Ranking
Pros
Pro Data update, insert & delete
Full power of Excel to perform mass data update, insert, and delete operations against data source. After editing is finished - click Commit, and the changes will be posted back to the data source.
Pro Windows scaling
Fully support Windows scaling for high-DPI devices. Also, display progress of commit changes operations.
Pro Quick Data Refreshing
Allows to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time.