Excel and CSV connections in Tableau - Step-by-Step Guide

Introduction

This feature lets you bring data from Excel or CSV files into Tableau. It helps you start analyzing your data quickly without needing complex setups.

When you have sales data saved in an Excel file and want to create a dashboard.

When you receive monthly reports as CSV files and want to combine them in Tableau.

When you want to explore customer lists stored in Excel spreadsheets.

When you need to update your Tableau report with new data from a CSV file regularly.

When you want to join data from multiple Excel sheets for a complete view.

Steps

Step 1: Open Tableau Desktop

- Start screen

You see options to connect to data sources including Excel and Text file

💡 Make sure your Excel or CSV file is saved locally or accessible on your computer

Step 2: Click

- Connect pane on the left, under 'To a File', select 'Microsoft Excel' or 'Text file'

A file browser window opens to select your data file

Step 3: Navigate and select your Excel or CSV file

- File browser window

Tableau loads the file and shows sheets or tables available for connection

Step 4: Drag the desired sheet or table to the canvas area

- Data Source tab

Tableau previews the data in a grid view for you to check

Step 5: Review and adjust data types or rename columns if needed

- Data Source tab, under the data preview grid

Data is ready for analysis with correct types and names

Step 6: Click 'Sheet 1' tab at the bottom

- Tableau workbook interface

You open a new worksheet to start building visualizations from your Excel or CSV data

Before vs After

Before

No data connected in Tableau, blank workbook with no sheets loaded

After

Excel or CSV data loaded and previewed in Data Source tab, ready for visualization

Settings Reference

File Type Selection

📍 Connect pane under 'To a File'

Choose the correct file type to connect your data source

Default: None

Data Interpreter

📍 Data Source tab, top right corner

Helps clean and organize Excel files with extra formatting or headers

Default: Off

Data Type Editing

📍 Data Source tab, column headers in data preview

Ensure columns have correct data types like text, number, or date

Default: Automatic detection

Common Mistakes

Selecting the wrong file type when connecting (e.g., choosing Text file for an Excel file)

Tableau cannot properly read the file structure, causing errors or no data shown

Always pick 'Microsoft Excel' for .xlsx or .xls files and 'Text file' for .csv files

Not using Data Interpreter on complex Excel files

Data may appear messy with extra headers or formatting included

Turn on Data Interpreter to clean up the Excel file automatically

Ignoring data type mismatches in columns

Incorrect data types can cause errors in calculations or visualizations

Check and manually correct data types in the Data Source tab before analysis

Summary

Excel and CSV connections let you quickly load spreadsheet data into Tableau for analysis.

Choose the correct file type and use Data Interpreter for cleaner Excel data.

Always verify and adjust data types to ensure accurate visualizations.