Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Getting Started with Tableau
Preparing Your Data
To take advantage of Tableau Desktop, Tableau recommends that you connect to data that is formatted for analysis. Specifically, data that is:
as granular as possible rather than aggregated
organized like a database table
stripped of extraneous information
Tableau prefers data to look like this:
Rather than this:
You can find instructions for structuring your data for analysis with Tableau here.
Loading Your Data
To upload your data into Tableau:
- Open your Tableau application. Once open, on the left corner you can see Connect.
- Select the option that best fits your data type.
- If you cannot find it, click More and then upload your file. You can also connect to public data stored in a server.
- After uploading your data, you will be directed to the Data Source where you can view your data. (See example below.)
- You can edit your data in this section. It is recommended that you make your data as clean as possible in Tableau. This means making sure value labels are used consistently, removing leading zeros or spaces, and missing values and handled appropriately for your type of data.
- To get more information or to edit the data field, hover above the data field. You can view a drop-down arrow and you will see different options available to you.
- If you want to add more files, go to the top left corner of your screen. Once there, click the ADD button and upload your file. Once you upload another file, you will be able to see both files on the left sidebar.
- Tableau automatically assigns data types to your data fields. If for some reason Tableau fails to do so, you can also edit it yourself.
- To edit the data type, you have to go to the sheet tab on the bottom next to data source. (It will be named by default Sheet1). Once you are in the sheet, on the left corner you can see the data fields. Click the icon in front of the data field and change it into the type you want it to be.
More information can be found here.
Example: Tableau Data Source Table