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 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.
Vizable

Explore data on an iPad, free.

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 Online Training

One-hour sessions led by a Tableau pro.
Whitepapers

Technology, trends, and tips.
On-Demand Webinars

Learn from experts.
Product Demos

Live, online product walkthroughs.

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
Consulting 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

Data Interpreter

Pivot

Metadata Grid

Split

Custom Split

Show Chapters

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

Almost there!

Data Prep with Text and Excel Files

Data Set

Solution Workbook

Transcript

Connecting to Data

Try Tableau for free