Devart Excel Add-in Universal Pack allows you to use powerful Excel capabilities for processing and analysis of cloud and database data, edit external data as usual excel worksheets and save data changes back to cloud apps and databases. Universal Pack is a cost-effective way to get Excel add-ins for all the supported data sources. It includes Excel add-ins for the following databases and cloud apps:
- DB2
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SQLite
- BigCommerce
- Dynamics CRM
- FreshBooks
- Freshdesk
- G Suite
- HubSpot
- Magento
- MailChimp
- Marketo
- NetSuite
- QuickBooks
- Salesforce
- Salesforce Marketing Cloud
- Shopify
- SugarCRM
- Zendesk
- Zoho CRM
Key Features:
- Powerful Data Import. With Devart Excel Add-ins you can precisely configure what data to load into the document. Select objects and columns and set complex data filters. If this is not enough, all the power of SQL is to your service both for database and cloud sources.
- Quick Data Refresh. The main Devart Excel Add-ins benefit is an ability to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time. 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.
