Javatpoint Logo
Javatpoint Logo

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
Next TopicTableau Extracting Data




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

Agile Tutorial

Agile
quality assurance Tutorial

QA
Angular 7 Tutorial

Angular 7
Data Science Tutorial

D. Science
ReactJS Tutorial

ReactJS
Software Engineering Tutorial

Software E.

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal A.
Interview Questions

Interview
Company Interview Questions

Company

Trending Technologies

Artificial Intelligence Tutorial

AI
AWS Tutorial

AWS
Selenium tutorial

Selenium
IoT Tutorial

IoT
Cloud tutorial

Cloud
Hadoop tutorial

Hadoop

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

DS
DAA tutorial

DAA
Operating System tutorial

OS
Computer Network tutorial

C. Network
Compiler Design tutorial

Compiler D.
Computer Organization and Architecture

COA
Discrete Mathematics Tutorial

D. Math.
Ethical Hacking Tutorial

E. Hacking
Computer Graphics Tutorial

C. Graphics
html tutorial

Web Tech.
Cyber Security tutorial

Cyber Sec.
Automata Tutorial

Automata
C Language tutorial

C
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control S.