Devart Excel Add-ins

Devart Excel Add-ins is a powerful bundle of data export tools, which allow you to quickly extract information from cloud storage spaces or databases. The plug-in integrates with Microsoft Excel, allowing you to easily import the data right into the currently opened worksheet. You may also edit the contents of the tables with the dedicated tools.

Wizard-like data import tool

Devart Excel Add-ins is a simple to use plug-in that allows you to transfer data from one environment to another, while maintaining its structure. You may easily import entire tables into Excel, with only a few mouse clicks. The wizard-like import form makes it easy for you to migrate information from the selected database.
The tool supports several types of databases, created with various manager programs: DB2, MySQL, Oracle, PostgreSQL, SQL Server, SQLite. Moreover, you can also extract data from Microsoft Dynamics CRM, Salesforce, SugarCRM and Zoho CRM. The wizard prompts you to choose the database encoding algorithm and the date/time format.

Data importing and editing

Once the connection to the database is established, you can select the desired table and map the fields in necessary. You may also view and modify this association through an SQL query. The wizard can display the data, in the table structure, before you finalize the importing process, allowing you to create a new sheet or append the information on the current one.
The columns, formatting, headers and information are imported into Excel, to a new spreadsheet or on the existing one, as per your option. You may enable the Edit Mode, in order to append or modify the information from the database.

Manage database connections

Devart Excel Add-ins enables you to connect to either of the supported platforms, as long as they are available, and you provide the login credentials. Moreover, the add-in enables you to assign various colors to mark cell function. For example, you can mark the modified cells or indicate erroneous fields.