Overview

Devart Excel Add-ins allow you to link Excel to various data sources and work with live data from these data sources directly in MS Excel.

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.

 

interface

 

ExpandedToggleIcon        Data Source Support

Devart Excel Add-ins are offered for the following data sources:

Oracle
SQL Server
MySQL
PostgreSQL
SQLite
DB2
BigCommerce
Dynamics 365
FreshBooks
Freshesk
Google Workspace (formerly, G Suite or Google Apps) - Google Contacts, Google Calendar, and Google Task
HubSpot
Magento
Mailchimp
Marketo
NetSuite
QuickBooks
Salesforce
Salesforce Marketing Cloud (formerly, ExactTarget)
Shopify
SugarCRM
Zendesk
Zoho Books
Zoho CRM
Zoho Desk

 

More details can be found in the Compatibility article.

 

ExpandedToggleIcon        Devart Excel Add-ins Benefits

Data Import

Devart Excel Add-ins allow you to precisely select the data you want to load into the document. They allow selecting objects and columns and setting complex data filters. If this is not enough, you can compose SQL queries manually for both relational databases and cloud applications.

Learn how to connect to a data source and import data from the Connecting And Importing Data article.

 

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 on the Refresh button on the Devart tab of the ribbon. You can refresh data in your workbook easily whenever you want without repeating the whole import operation each time.

 

Data Modification

You can edit data in Excel just like you usually do it, add or delete rows, modify cell values, etc. After you finished editing, just click Commit and the changes will be posted back to the data source.

See more details in the Modifying Data article.

 

Data Validation

Devart Excel Add-ins validate entered data to make sure it matches to the source column data type. Our product instantly highlights incorrect data, such as incorrect dates, duplicate primary key values, etc, so that you can fix any errors before committing changed data to the data source.

 

ExpandedToggleIcon        See Also