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

Devart is a great tool for the cost

Rating: 8 out of 10
April 23, 2021
IncentivizedVetted ReviewVerified User
Devart Excel Add-ins is being used at my organization to help manage a few different SQL server management tasks including but not limited to - source control, unit testing, s...
Continue reading
Scott Kennedy
Director - Marketing
Director, eCommerce Analytics and Digital Marketing
Franklin Sports
Devart Excel Add-ins3 years of experience

Devart excel add-in review

Rating: 8 out of 10
January 24, 2019
IncentivizedVetted ReviewVerified User
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...
Continue reading
Verified user
Analyst
Devart Excel Add-ins3 years of experience
Log in with LinkedIn to see content from your network
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 Integrations

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

View all reviews
(1-1 of 1)

Devart is a great tool for the cost

Rating: 8 out of 10
Incentivized
April 23, 2021
SK
Scott Kennedy
Director, eCommerce Analytics and Digital Marketing
Franklin Sports (Sporting Goods, 201-500 employees)
Vetted Review
Verified User
Devart Excel Add-ins
3 years of experience
View profile
Use Cases and Deployment Scope
Devart Excel Add-ins is being used at my organization to help manage a few different SQL server management tasks including but not limited to - source control, unit testing, schema comparisons, event profiling, dev ops automation, index management analysis and query builder. There are more use cases for the Devart Excel Add-ins above and beyond what we are using it for.
Pros
  • Source control
  • Unit testing
  • Schema comparisons
Cons
  • The data pump feature breaks sometimes
  • The profile usage monitoring is slow
  • The event profiler is delayed
Likelihood to Recommend
Devart Excel Add-ins is really good for data comparison of one database table against another database table. There are plenty of times where the business users need help understanding with their Power BI data models are not connecting correctly and I use this tool to break down the differences between the tables they are trying to connect.
Devart Excel Add-ins Feature Ratings
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
Return on Investment
  • The data compare option saves our dev team a lot of time
  • The documenter feature is nice to use for explaining table definitions
  • The event profiler is great for usage metrics
Alternatives Considered
Microsoft Excel is the most used tool in the software universe. As such, asking Microsoft Excel to be the tool used post data acquisition makes a ton of sense. Almost everyone we hire has some idea on how to use this tool, which decreases the time spend training new employees.
Other Software Used
Return to navigation