Feature | Free Edition | Standard Edition | Enterprise Edition |
Getting Data |
Loading data from database tables, views, and stored procedures | ✓ | ✓ | ✓ |
Loading data from web data sources (XML, JSON, CSV, HTML) | ✓ | ✓ | ✓ |
Loading data from XML, JSON, CSV, HTML, and plain text files | ✓ | ✓ | ✓ |
Loading data from Excel workbooks | ✓ | ✓ | ✓ |
Loading data from CSV files | ✓ | ✓ | ✓ |
Loading data from DBF files | ✓ | ✓ | ✓ |
Saving Data |
Saving data from Excel to SQLite | ✓ | ✓ | ✓ |
Saving database table data from Excel to server databases | ✓ | ✓ | ✓ |
Saving data loaded from views and stored procedures | x | ✓ | ✓ |
Saving data from Excel to OData web services, including ODataDB | x | ✓ | ✓ |
Saving data from Excel to REST API web services, including DBGate | x | ✓ | ✓ |
Saving data to databases and services using cell change handlers | x | x | ✓ |
Saving data to databases and services using VBA | x | ✓ | ✓ |
Saving data to CSV, HTML, and SQL INSERT | ✓ | ✓ | ✓ |
Advanced UI Features with No Coding |
The Reports tab to create interactive reports | ✓ | ✓ | ✓ |
The ribbon Query List to switch queries | ✓ | ✓ | ✓ |
Ribbon controls to change query parameters and WHERE fields | ✓ | ✓ | ✓ |
User's table views to apply saved views in one click | ✓ | ✓ | ✓ |
Encrypting Excel connection string passwords | ✓ | ✓ | ✓ |
Keeping formulas on data refresh | ✓ | ✓ | ✓ |
Keeping comments on data refresh | ✓ | ✓ | ✓ |
Opening the last opened workbook at startup | ✓ | ✓ | ✓ |
Interactive cells to change Excel AutoFilters | ✓ | ✓ | ✓ |
Table cursors and interactive fields to view and edit data | ✓ | ✓ | ✓ |
Pivot tables as data editors | ✓ | ✓ | ✓ |
Task panes to show images | ✓ | ✓ | ✓ |
Task panes to edit cell contents | ✓ | ✓ | ✓ |
Task panes to select validation list values | ✓ | ✓ | ✓ |
Task panes to view and edit row values | ✓ | ✓ | ✓ |
Double-click calendars to input dates | ✓ | ✓ | ✓ |
Context menus to create Outlook tasks, appointments, and emails | ✓ | ✓ | ✓ |
SaveToDB Wizards |
Database Connection Wizard | ✓ | ✓ | ✓ |
Web Data Connection Wizard | ✓ | ✓ | ✓ |
Text File Connection Wizard | ✓ | ✓ | ✓ |
Pivot Table Connection Wizard | ✓ | ✓ | ✓ |
DB RTD Connection Wizard | ✓ | ✓ | ✓ |
Data Publishing Wizard | ✓ | ✓ | ✓ |
Data Merge Wizard | ✓ | ✓ | ✓ |
Connection Change Wizard | ✓ | ✓ | ✓ |
Table Format Wizard | ✓ | ✓ | ✓ |
Developer Tools | ✓ | ✓ | ✓ |
Application Installer | ✓ | ✓ | ✓ |
Application Workbooks | ✓ | ✓ | ✓ |
Developer-Customizable Features |
Saving changes to target tables and views | x | ✓ | ✓ |
Saving changes using stored procedures or SQL codes | x | ✓ | ✓ |
Saving changes using REST API | x | ✓ | ✓ |
Saving changes using server-side cell change handlers | x | x | ✓ |
Saving Excel formulas in a database | x | ✓ | ✓ |
Saving Excel comments in a database | x | ✓ | ✓ |
Saving bulk changes using procedures with JSON parameters | x | ✓ | ✓ |
Dynamic JSON forms | ✓ | ✓ | ✓ |
Data translation | ✓ | ✓ | ✓ |
Dynamic column headers for multi-tenant applications | x | x | ✓ |
Dynamic Excel validation lists | ✓ | ✓ | ✓ |
Dynamic parameter value lists | ✓ | ✓ | ✓ |
Configuring list dependencies | ✓ | ✓ | ✓ |
Converting loaded text values to formulas | ✓ | ✓ | ✓ |
Converting loaded text values to hyperlinks | ✓ | ✓ | ✓ |
Saving and loading Excel table formats | ✓ | ✓ | ✓ |
Customizable ribbon action menus | ✓ | ✓ | ✓ |
Customizable Excel context menus including drill-down queries | ✓ | ✓ | ✓ |
Showing table data, HTML, XML, and images in context task panes | ✓ | ✓ | ✓ |
Showing table descriptions in context task panes | ✓ | ✓ | ✓ |
Generating application workbooks from a database | ✓ | ✓ | ✓ |
Using the add-in as a VBA library | ✓ | ✓ | ✓ |
Supported Database Platforms |
SQL Server, Oracle Database, MySQL, PostgreSQL | ✓ | ✓ | ✓ |
SQLite | ✓ | ✓ | ✓ |
Snowflake | ✓ | ✓ | ✓ |
Supported HTTP Authentication Schemes |
Basic, Windows, Forms | ✓ | ✓ | ✓ |
OAuth1, OAuth2 | ✓ | ✓ | ✓ |
Supported Operating Systems |
Windows 7/8/10/11 | ✓ | ✓ | ✓ |
Supported .NET Framework Versions |
.NET Framework 4.7.2+ | ✓ | ✓ | ✓ |
Licensing |
License | MIT | EULA | EULA |
Commercial Use | ✓ | ✓ | ✓ |