Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel in the same way that you work with usual Excel spreadsheets.
With Devart Excel Add-ins you can obtain precisely the data you need with visual Query Builder or with SQL, and then refresh the queried external data in a workbook with a single click. The external data can be edited in Excel, and then saved back into the data source.
Key Features include:
- Connect Microsoft Excel to a variety of data sources.
- Work with live data directly in Excel.
- Modify external data easily.
Devart Excel Add-ins allow you to configure what data to load into the document. They allow you to select objects and columns and set complex data filters.
Devart Excel Add-ins is a very useful utility and can be beneficial for numerous applications, however the main benefit is that it allows you to periodically obtain the data from various data sources and push it to Excel with a single click, without having to repeat the whole import process every time. It lets you refresh the data in your workbook whenever you need to.
Supported databases include Oracle, MySQL, SQL Server, PostgreSQL, SQLite, and DB2.
Supported cloud apps inlcude: Salesforce, Dynamics CRM, Zoho CRM, Sugar, QuickBooks, FreshBooks, MailChimp, Bigcommerce, Magento, and Salesforce Marketing Cloud.