The CData Tableau Connector for Microsoft Excel is built on top of a JDBC driver. This section discusses how to install the connector, set up a data source, and connect from Tableau.

Installing the Connector

Installing the Connector describes how to install the CData Tableau Connector for Microsoft Excel.

Connecting from Tableau

Configuring a Connection shows how to create a Microsoft Excel Data Source from Tableau's Connect To Server window.

Tableau Version Support

The connector supports Tableau Desktop 2020.1 or later and Tableau Prep 2020.4.1 or later. Versions between 2020.1 and 2020.3 of Tableau Desktop are supported via the legacy connector file (cdata.excel.legacy.taco) and versions 2020.3 and higher are supported using the modern connector file (cdata.excel.taco).

For older versions of Tableau, use the CData ODBC Driver for Microsoft Excel or the CData JDBC Driver for Microsoft Excel to connect.

Microsoft Excel Version Support

The CData Tableau Connector for Microsoft Excel supports the Office Open XML spreadsheets used by Microsoft Excel 2007 and later.

Microsoft Excel File Extension Support

The CData Tableau Connector for Microsoft Excel currently supports .xlsx and .xlsm files. However, only read operations are supported for .xlsm files. Modifying data operations may cause loss of or damage to macros.