Excel
 

Read, Write, and Update Excel Spreadsheets through easy-to-use bi-directional drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.

"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to Microsoft Excel Data from Anywhere!

Easily access live Microsoft Excel data from BI, Analytics, Reporting, ETL, & Custom Apps.







Excel Integration Guides and Tutorials


BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time Excel data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Excel data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze Excel in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Excel in Amazon QuickSight Aqua Data Studio: Connect to Excel in Aqua Data Studio Birst: Build Visualizations of Excel in Birst BIRT: Design BIRT Reports on Excel Clear Analytics: Build Charts with Excel in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Excel in DBxtra Domo: Create Datasets from Excel in Domo Workbench ... Dundas BI: Build Dashboards with Excel in Dundas BI FineReport: Feed Excel into FineReport Google Data Studio: Create Reports from Excel in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Excel JasperServer: Create Excel Reports on JasperReports Server Jaspersoft BI Suite: Connect to Excel in Jaspersoft Studio JReport Designer: Integrate with Excel in JReport Designer KNIME: Enable the Excel JDBC Driver in KNIME LINQPad: Working with Excel in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Excel Power BI Online: Visualize Live Excel in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Excel MicroStrategy: Use the CData JDBC Driver for Excel in MicroStrategy OBIEE: Excel Reporting in OBIEE with the Excel JDBC Driver Pentaho Report Designer: Integrate Excel in the Pentaho Report Designer QlikView: Connect to and Query Excel in QlikView over ODBC R: Analyze Excel in R RapidMiner : Connect to Excel in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel SAP Crystal Reports: Publish Reports with Excel in Crystal Reports SAP Lumira: Consume Excel OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Excel in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Excel in Sisense Spago BI: Connect to Excel in SpagoBI Tableau: Visualize Excel in Tableau Tableau Online: Build Excel Visualizations in Tableau Online Tableau Server: Publish and Share Excel Dashboards with Tableau Server TIBCO Spotfire: Operational Reporting on Excel from Spotfire Server TIBCO Spotfire Server: Operational Reporting on Excel from Spotfire Server Visio: Link Visio Shapes to Excel

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with Excel connectivity to ETL/ELT tools for replication — our Excel integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Excel to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.

Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous Excel Replication to Amazon Redshift Amazon S3: Automated Continuous Excel Replication to Amazon S3 Apache Cassandra: Automated Continuous Excel Replication to Apache Cassandra AWS Glue: Connect to Excel in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Excel to SQL Server Clover ETL: Connect to Excel in CloverETL CSV: Automated Continuous Excel Replication to Local Delimited Files IBM DB2: Automated Continuous Excel Replication to IBM DB2 FoxPro: Work with Excel in FoxPro Google BigQuery: Automated Continuous Excel Replication to Google BigQuery Google Cloud SQL: Automated Continuous Excel Replication to Google Cloud SQL Heroku / Salesforce Connect: Replicate Excel for Use in Salesforce Connect Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Excel Jaspersoft ETL: Connect to Excel in Jaspersoft Studio Microsoft Access: Automated Continuous Excel Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Excel Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Excel MongoDB: Automated Continuous Excel Replication to MongoDB MySQL: Automated Continuous Excel Replication to MySQL Oracle Data Integrator: ETL Excel in Oracle Data Integrator Oracle Database: Automated Continuous Excel Replication to Oracle PostgreSQL: Automated Continuous Excel Replication to PostgreSQL Replicate to CSV: PowerShell Scripting to Replicate Excel to MySQL Snowflake: Automated Continuous Excel Replication to Snowflake SQL Server: Automated Continuous Excel Replication to SQL Server SQLite: Automated Continuous Excel Replication to SQLite Talend: Connect to Excel and Transfer Data in Talend

Data Management


By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Excel data from a wide range of database management applications.

Popular Data Management Tool Integrations


DBeaver: Connect to Excel in DBeaver DbVisualizer: Connect to Excel in DBVisualizer DB Artisan: Manage Excel in DBArtisan as a JDBC Source DB Artisan: Connect to Excel in DBArtisan Informatica Enterprise Data Catalog: Add Excel to Informatica Enterprise Data Catalog MySQL Workbench: Query Excel in MySQL Workbench RazorSQL: Connect to Excel in RazorSQL SQuirreL: Connect to Excel in Squirrel SQL Client

Developer Tools & Technologies


The easiest way to integrate with Excel from anywhere. Our Excel drivers offer a data-centric model for Excel that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


.NET Charts: DataBind Charts to Excel .NET QueryBuilder: Rapidly Develop Excel-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Excel Apache Spark: Work with Excel in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Excel IFTTT Flows in Azure App Service ColdFusion: Query Excel in ColdFusion DevExpress: DataBind Excel to the DevExpress Data Grid EF - Code First: Access Excel with Entity Framework 6 EF - LINQ: LINQ to Excel EF - MVC: Build MVC Applications with Connectivity to Excel Filemaker Pro: Bidirectional Access to Excel from FileMaker Pro Go: Write a Simple Go Application to work with Excel on Linux Google Apps Script: Connect to Excel in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Excel Entities in Java IntelliJ: Connect to Excel in IntelliJ JBoss: Connect to Excel from a Connection Pool in JBoss JDBI: Create a Data Access Object for Excel using JDBI JRuby: Connect to Excel in JRuby NodeJS: Query Excel from Node.js NodeJS: Query Excel as a MySQL Database in Node.js PHP: Access Excel in PHP through the Cloud Hub PHP: Natively Connect to Excel in PHP PowerShell: Pipe Excel to CSV in PowerShell PowerBuilder: Connect to Excel from PowerBuilder PyCharm: Using the CData ODBC Driver for Excel in PyCharm Python: Connect to Excel in Python on Linux/UNIX Ruby: Connect to Excel in Ruby SAP UI5: Integrate Real-Time Access to Excel in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Excel in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Excel WebLogic: Connect to Excel from a Connection Pool in WebLogic


When Only the Best Excel Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:


Using the Excel Drivers

[more articles...]


Other Microsoft Excel Drivers

 
 
Products


SOLUTIONS


Support
Purchase
Company
Subscriptions