KNOWLEDGE BASE

Data Interpreter Does Not Give The Table Data When Connecting To Excel With Introductory Text


Published: 25 Mar 2021
Last Modified Date: 25 Mar 2021

Issue

Data interpreter does not give the table data when connecting to Excel with introductory text.

 

Environment

  • Tableau Desktop

Resolution

Use a named range with Excel

1. Open the excel file, select the table starting from column headers until the end.
2. Click on formulas, and define name.
3. Reconnect the file to Tableau. You will see the defined name in Tableau. Drag that to the data source pane.
 

Cause

 Introductory text has to be removed for the correct interpretation of the table.
Did this article resolve the issue?