97

Data Connection with Microsoft Excel

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

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.

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.

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

Then the data source looks like the below image:

And the worksheet looks like:

---