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

Home Page - https://www.devart.com/