Data Prep with Text and Excel Files

Skip to main content

Menu

Back Products Overview

Tableau Desktop

Analytics anyone can use.

Learn More

Tableau Prep

Data prep anyone can use.

Learn More

Tableau Server

Analytics for organizations.

Learn More

Tableau Online

Cloud analytics for organizations.

Learn More

More Tableau Products

Tableau Mobile

Publish interactive data on websites.
Tableau Public

Publish interactive data on websites.
Embedded Analytics

Read Tableau Desktop files for free.
Developer Tools

Extend Tableau to fit your organization's needs.
Pricing

Explore our pricing options.

Back Solutions Overview

Industries

Explore Tableau’s solutions for your industry.

Learn More

Departments

See what’s possible for your department.

Learn More

Technology

Learn how we integrate with your data source.

Learn More

Free Training Videos

Learn Tableau with these bite-sized videos.

Learn More

eLearning

Interactive, self-paced learning at scale.

Learn More

Classroom Training

Multi-day courses offered around the world.

Learn More

More Ways to Learn

Live Training

One-hour sessions led by a Tableau pro.
Whitepapers

Technology, trends, and tips.
On-Demand Webinars

Learn from experts.

Back Community Overview

Forums & User Groups

Share knowledge and ideas with other Tableau users.

Visit the Forums

Partners

Find a partner to help you make the most of Tableau.

Find a Partner

Events

Stay up-to-date with the latest virtual and in-person events.

Learn More

More About Community

Back Support Overview

Desktop Support

Resources for Desktop authors.

Learn More

Prep Support

Resources for Prep.

Learn More

Server Support

Resources for Server administrators.

Learn More

Online Support

Resources for Tableau in the cloud.

Learn More

More Support

Tableau Help
Services

Jump-start your deployment or dashboard.
Customer Portal

Manage your Tableau accounts, product keys, and support cases.
Knowledge Base

Explore technical articles.

Back About Us

Mission

This matters to us.

Learn More

Leadership

Our top brass.

Learn More

Newsroom

Extra, extra! Read all about it.

Learn More

More About Our Company

Tableau Foundation

Let's build a better world with data.
Investors

News, events, and investor releases.
Careers

Join our team.
Research

Warning message

Having trouble? Make sure JavaScript is enabled.

Business E-mail

Country/Region

State/Province

Business Postal Code

I'd like to hear from Tableau in the future. (You can opt out at any time)

We respect your privacy | Having Trouble?

Data Prep with Text and Excel Files

6:33 min

MP4

Learn how to use various features of the Data Connection window to tidy up messy Excel files.

Applicable Versions:

9.3, 9.2, 9.1, 9.0

Tableau Desktop

Tableau Prep

Tableau Server

Tableau Online

More Tableau Products

Industries

Departments

Technology

More about our solutions

Free Training Videos

eLearning

Classroom Training

More Ways to Learn

Forums & User Groups

Partners

Events

More About Community

Desktop Support

Prep Support

Server Support

Online Support

More Support

Mission

Leadership

Newsroom

More About Our Company

Data Prep with Text and Excel Files

Data Set

Solution Workbook

Transcript

Connecting to Data

Try Tableau for free

More Tableau Products

More about our solutions

More Ways to Learn

More About Community

More Support

More About Our Company

Almost there!

Data Prep with Text and Excel Files

Data Set

Solution Workbook

Transcript

Connecting to Data

Try Tableau for free