Skip to main content
TrustRadius
Devart Excel Add-ins

Devart Excel Add-ins

Overview

What is Devart Excel Add-ins?

Devart Excel Add-ins allow you to use Excel capabilities to import, process, and analyze data from cloud applications and relational databases. The Excel Add-ins also allow users to make data changes and then save those changes back to the data…

Read more

Learn from top reviewers

Return to navigation

Pricing

View all pricing

Excel Add-in Database Pack

$399.95

On Premise
one-time fee

Excel Add-in Cloud Pack

$499.95

On Premise
one-time fee

Excel Add-in Universal Pack

$599.95

On Premise
one-time fee

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.devart.com/excel-addins/

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $399.95 one-time fee
Return to navigation

Product Details

What is Devart Excel Add-ins?

Devart Excel Add-ins allow users to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets.

With Devart Excel Add-ins users can get data with a visual Query Builder or with SQL and refresh the queried external data in a workbook. External data can be edited as it is usually done in Excel, and then saved back to the data source.

Supported databases:

  • Oracle Database
  • SQL Server
  • MySQL
  • PostgreSQL
  • SQLite
  • DB2

Supported Cloud Applications:

  • BigCommerce
  • Dynamics CRM
  • FreshBooks
  • Freshdesk
  • G Suite
  • HubSpot
  • Magento
  • MailChimp
  • Marketo
  • NetSuite
  • QuickBooks
  • Salesforce
  • Salesforce Marketing Cloud
  • Shopify
  • SugarCRM
  • Zendesk
  • Zoho CRM

Devart Excel Add-ins Features

  • Supported: Connects Microsoft Excel to various data sources
  • Supported: Data Import: Users can precisely configure what data to load into the document.
  • Supported: Quick Data Refresh: Draws from different data sources to Excel with a single click without repeating the import operation.
  • Supported: Data Modification: Data can be edited in Excel against the data source, with changes posted back to the data source.

Devart Excel Add-ins Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of

Devart Excel Add-ins Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported LanguagesEnglish
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-1 of 1)

Devart excel add-in review

Rating: 8 out of 10
January 24, 2019
Vetted Review
Verified User
Devart Excel Add-ins
3 years of experience
Devart Excel Add-in is being used by specific departments of our organization as some departments don't require this feature for their job function. It helps a lot for all the users as it keeps the documents and databases in the cloud - hence making it possible to use them anywhere. We are able to go to meetings and share documents online with the help of this.
  • Devart Excel Add-in supports connectivity with various databases - which really helps to customize and massage data.
  • Since data is available in cloud, it is easily accessible everywhere.
  • It can also be integrated with SSIS components making it possible to resolve complex problems.
Cons
  • It has room for improvement in terms of security and making it possible for large organizations like us to use it in a more secure way with integrating with our in-house security systems.
  • Pricing could be reduced further for it to be adopted world-wide.
  • it isn't foolproof. Excel has no means of checking for human error during data entry, which means that the wrong information can skew all the results - sometimes severe.
  • Users unfamiliar with Excel syntax may also find entering calculations and calling up other functions a bit frustrating until they get a solid understanding.
One of the biggest benefits of Excel is its primary function: The ability to organize large amounts of data into orderly, logical spreadsheets and charts. With the data organized, it's a lot easier to analyze and digest, especially when used to create graphs and other visual data representations. Excel crunches numbers almost instantly, making batch calculations much easier than working things out yourself with a calculator. Depending on your understanding and skill with Excel, the formulas and equations are used to quickly compute both simple and complex equations using large amounts of data.


Data Source Connection
N/A
N/A
Data Transformations
N/A
N/A
Data Modeling
N/A
N/A
Data Governance
N/A
N/A
  • It had a positive ROI as we used it on its strengths. We could save time and make some of our processes simpler.
  • It does help us up to a certain limit - but it acts as a part of our general IT infrastructure. It cannot solve our direct business objectives.
  • It cannot be expanded in all directions as we need a lot more native coding and IT infrastructure.
Devart Excel stacks up very well against its alternatives. It has significant advantages as it keeps getting an update. Features are very much suitable for smaller organizations. For larger organizations the features cannot be used directly because of the size of the company and more native requirements of IT software requirements.
Return to navigation