Data Connection with Microsoft Excel

Step1: Click on the Microsoft Excel option given in the data tab.

Tableau Data Connection with Microsoft Excel

Step2: In the next screen,

  1. Select the Microsoft Excel file you want to connect such as sample-superstore.xls.
  2. Click on open option.
Tableau Data Connection with Microsoft Excel

Step3: It connects the Microsoft Excel file to Tableau. The sheets present in the Microsoft Excel file are shown on the left-hand side of the window.

Tableau Data Connection with Microsoft Excel

Step4: You can drag one or more sheets from the sheets data tab such as Orders.

Tableau Data Connection with Microsoft Excel

Then the data source looks like the below image:

Tableau Data Connection with Microsoft Excel

And the worksheet looks like:

Tableau Data Connection with Microsoft Excel




Latest Courses