Excel files

If you want to connect to an Excel file, follow these steps:

  1. Click on Microsoft Excel in the list of available connections when you open Tableau.
  2. Search for your file in your computer, double-click on it, and Tableau automatically opens the file.
  1. The different tables are displayed on the left, as in the following screenshot:
  1. Drag and drop the table you want to analyze on the Data Source part, on the right.
If your file is not clean or contains, for example, a title or merged cells, try to click on Use Data Interpreter to clean your file.

Connecting to an Excel file is straightforward. Let's now try another type of file: a ...

Get Getting Started with Tableau 2018.x now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.