DATA MART FOR EXCEL (D4E SQL)
WANT TO KNOW MORE: List of Features (with video links)
Standard Version (Free) includes all the core features of D4E:
Store and Manage SQL codes - Ability to store, organize, and manage multiple SQL queries within the tool.
Run SQLs from Command Bar Menu - Business User executes SQL commands directly from menus without needing SQL expertise.
File-based Parameters - Store parameters in files for use within SQL queries, making it easy to manage data-driven queries.
Update Databases - Ability to perform database updates, inserts, and deletes directly from Excel through SQL queries.
Windows Security - Integration with Windows security features to ensure secure access to data and protect sensitive information.
Extensive Logging - Detailed logs of SQL execution, parameter handling, and task statuses for tracking and troubleshooting.
Compiled COM DLL - The application is compiled into a COM DLL Excel addin, ensuring high performance and secure functionality.
=D4ESQL(sheet,column) - Full-featured Excel formula function to use in cells to run SQL code (similar to SQLookup).
D4ESQL Office JS Addin - (From Microsoft Store) Enjoy full-featured SQL (formulas, ODBC, DB Updates) with Excel Web, Mac, and Windows
D4ESQL Google Sheets™ - (From Google) Enjoy full-featured ODBC SQL with Google Sheets.
Read JDBC and ODBC - Access both ODBC and JDBC databases (ODBC via Windows Drivers, and JDBC via Java Integration Proxy.)
Advanced Version (Paid) includes all the core features above, plus:
AI-enabled with AI Assistant - Use the built-in AI Assistant to help create SQL code with ODBC connectors.
Macro Recording and Execution - Record and execute macros to automate repetitive tasks and SQL operations within Excel.
Scheduling - Schedule SQL queries, macros, and other tasks to run automatically at specified times or intervals.
Parameter Prompts - Interactive prompts for users to input parameters at runtime, making SQL queries more flexible and user-friendly.
Complex SQL Replacement - Replace complex placeholders or variables in SQL statements with dynamic values during execution.
Encoding Private Data - Encrypt and store private data securely to prevent unauthorized access to sensitive information.
Excel Ribbons Icons - Custom Excel ribbon icons for quick access to key D4E features, such as running SQL commands and menus.
Excel Task Pane - An interactive task pane within Excel to display logs, run SQL, manage tasks, and interact with D4E more efficiently.
Create Mini Applications - Build custom mini applications within D4E, integrating SQL and Excel to create tailored solutions for specific tasks.
Use with Servers and Devices - Mobile devices can be used to communicate with Excel servers to return real-time SQL outputs remotely.
Read RestAPI Data Sources - Read data sources like SAP, Salesforce, ServiceNow and others using Rest API, JSON with AI Assistance. .
The main use case of the Standard Version is for an unlimited number of SQL Developers to write unlimited number of SQLs in simple agreed formats and store them in Excel spreadsheets, so that select Business Users can easily run them via menus and without SQL knowledge.
These select few Business Users may also upgrade to the Advanced Version to gain additional features that are primarily business-oriented and cost-justified.
Below is the client-server architectural diagram of D4E, that allows for remote execution of SQL.
DOWNLOADS
TECHNICAL DIVE: ARCHITECTURAL DIAGRAMS
To understand why there are many downloadable components of D4E, below is a diagram mapping the functions of these components.
Download D4E Today – Run SQL in Excel Without Coding
Easily connect to your data and empower business users to run SQL from Excel — no coding required.
👉 Start Free, Evaluate Advanced Tools, or Deploy Enterprise-wide.
(By downloading our software, you agree to the conditions of use below.)
Versions (Core Product - Windows COM Add-in)
D4E Standard Version (FREE) - Start instantly with flash reporting using core SQL features.
D4E Enterprise Edition (PAID) - D4E Advanced Version with licensing managed via Microsoft AppSource.
Feature Extension Apps (FREE)
Companion Apps (Cross-platform, Essential Features) - Get directly (FREE) from Microsoft / Google Stores
To install D4ESQL Office JS Addin from Microsoft 365 Store:
- Go to Excel > Ribbon Menu > Add-ins > More Add-Ins > Search for D4ESQL > Add.
To install D4ESQL Google Sheets™ Add-on from Google Store:
- Go to Google Sheets™ > Extensions > Add-ons > Get Add-ons > Search for D4ESQL > Install.
CONDITIONS OF USE:
Unless licensed, this is a limited trial version of Data Mart For Excel (D4E SQL) (aka D4E, D4ESQL, Datamart4Excel, Data Robots for Excellence). You must not use the trial version in a production environment without permission. A normal full license may revert to a trial version, if the main user license or any product license has expired or in any way become invalid. Please visit www.datamart4excel.com and contact us for pricing information to use the full version. You accept that the software program for Datamart4Excel belongs to Caratrel Consultants Pty Ltd. You may not de-compile, de-obfuscate, adapt, translate, or otherwise change Datamart4Excel into any other software program or format. You shall not use trial versions of the software or product libraries in a production environment. You shall not use Datamart4Excel and its license files for any purpose or in any manner other than its intended purpose. You shall not allow Datamart4Excel license files to be used by anyone other than its registered owner. You agree to indemnify and hold harmless Datamart4Excel and its authors, against any claim resulting from loss of any kind as a result of using Datamart4Excel.
Google Sheets™ is a trademark of Google LLC.
Microsoft Excel™ and Microsoft 365™ are trademarks of the Microsoft group of companies.
+61 (0) 418 217 114
Caratrel Consultants Pty Ltd ©2025 All Rights Reserved. (All names and trademarks are the property of their respective owners.)
DATA MART FOR EXCEL (D4E SQL)
FREE SUPPORT