Connect Tableau to a Tab Delimiter Text File

This article shows how to connect with the Tab delimiter text file, load its data into the tableau desktop, and design a chart.

The below screenshot shows that each column separates by tab space.

File

Connect Tableau to a Tab Delimiter Text File

Clicking on the text file option will open the window to choose the Tab delimiter file.

Choose the File from hard drive

Video

As you can see, the Tableau desktop loaded the file and automatically separated the columns using a Tab delimiter.

Connect Tableau to a Tab Delimiter Text File 3

If it is not the case, choose the Text File Properties.. option.

Text File Properties

By default, the desktop has chosen Tab as the Field separator. 

Check the Field Separator

If not, it has chosen a comma; the data looks below.

Data For the Wrong Field Separator

Change the Field Separator to Tab from the list of available separators.

Connect Tableau to a Tab Delimiter Text File 7

Drag Education to Columns and Income to Rows shelf. Next, add the Education dimension to the Color shelf and Income to Label. 

Connect Tableau to a Tab Delimiter Text File 8

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.