Devart Excel Add-ins Reviews

16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.8 out of 101

Do you work for this company?

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-1 of 1)

No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.


Read this authenticated review

Devart Excel Add-ins Scorecard Summary

Feature Scorecard Summary

Pre-built connectors (1)
7
Connector modification (1)
7
Support for real-time and batch integration (1)
8
Data quality services (1)
8
Data security features (1)
8
Monitoring console (1)
9

About Devart Excel Add-ins

Devart Excel Add-ins allow you to use Excel capabilities for the processing and analysis of data from cloud applications and relational databases, edit external data such as Excel spreadsheets and save data changes back to the data source you have imported them from.

List of supported data sources:
  • Oracle Database
  • SQL Server
  • MySQL
  • PostgreSQL
  • SQLite
  • Salesforce
  • Dynamics CRM
  • Zoho CRM
  • SugarCRM
  • DB2

Devart Excel Add-ins Features

Has featureConnect Microsoft Excel to various data sources
Has featureWork with live data directly in Excel
Has featureModify external data easily
Has featurePowerful 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, not only for relational databases, but for cloud applications too.
Has featureQuick 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.
Has featureEasy 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.

Devart Excel Add-ins Screenshots

Devart Excel Add-ins Integrations

Zoho CRM, SugarCRM, Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, SQLite, DB2, Mailchimp, QuickBooks Online, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Salesforce CRM

Devart Excel Add-ins Competitors

CData Excel Add-in, MySQL for Excel, Spreadsheet Add-In

Pricing

Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?No
EditionPricing DetailsTerms
Standard Edition99.95

Devart Excel Add-ins Support Options

 Free VersionPaid Version
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media

Devart Excel Add-ins Technical Details

Deployment Types:On-premise
Operating Systems: Windows
Mobile Application:No
Supported Languages: English