Skip to content

Tableau and Google Sheets: Step-by-Step Guide To A Quick and Easy Dashboard

Ever wanted to build a quick visualization based on data you have in Google Sheets? Well, you’re not alone.

Connecting Tableau and Google Sheets used to be FRUSTRATING before Tableau Desktop 10

Yes, there are some charts and graphs built in, but they are pretty limited.

Here’s the thing: You can now connect directly to any Google sheet with a few clicks and start visualizing your data in minutes.

Save time by connecting Tableau directly to Google Sheets data

In this step-by-step guide, you will learn

  1. How to upload your data into Google Sheets
  2. Connecting to Google Sheets from Tableau
  3. Create a quick dashboard with Tableau and Google Sheets

Before you get started, you’ll need two things.

Thing 1: A Google account and some data you want to visualize. (You can use mine to follow along with this guide.

Thing 2: Tableau Click here to download a free trial of Tableau

Step 1: Upload your Data into Google Sheets

Note: if your data is already in Google Sheets, you can move on to Step 2 below.

  1. Sign into your Google Account (or sign up)
  2. Go to
  3. Create a new spreadsheet
Sign into your Google Account and Create a new Blank Spreadsheet
  • From the File menu of the new spreadsheet, click Import and find your Excel or CSV data file
Import your data into Google Sheets
  • Click Upload on the next screen
  • Locate your data file on your computer (desktop, My Documents, etc.)
  • Drag your data file into the Google spreadsheet Upload area
Import your data file into Google Sheets
  • Select Replace Spreadsheet to finish the data file upload process
Finish the data file upload process
  • Your data file will automatically be converted into a Google Spreadsheet
  • Give your new Spreadsheet a name and confirm that your data looks good
Give your Google Sheet a name and make sure your data looks okay.

Step 2: Import your Google Sheet Data into Tableau

  1. Open Tableau (reminder: you must have version 10 or higher)
  2. In the Connect section of the screen, click More Servers…
  3. Once the Server section of the screen opens, click Google SheetsOpen Tableau and click
  4. You’ll need to sign into your Google account and allow Tableau to access your Google Sheet.Allow Tableau Desktop to view your Google Sheets data
  5. Select your imported Google Sheet and click Connect to view your data file in TableauSelect your imported data file and click
  6. Now that your data is imported into Tableau Desktop, confirm that everything looks okay and click Sheet 1 to visualize your dataConfirm that your data looks okay, then click Sheet 1 to build your data visualization.

Step 3. Create a Tableau Dashboard using Google Sheets Data

  1. Format Response Rate measure so it’s easier to read
    1. In the Measures section, right-click the Response Rate measure, hover over the Default Properties menu, and select Number Format…Set up the default format for Response Rate since percentages will be easier to read then regular numbers.
    2. Choose Percentage and 1 Decimal Place in the pop-up box.
    3. Now the Response Rate format is set to a percentage instead of a regular number.
  2. Build the visualizations with your Google Sheets data set
    1. Start by changing the visualization type from Automatic to Bar
    2. After that, drag the Age Group and Age Range to the rows of shelf
    3. Next, drag Response Rate from the Measures section to the Text icon on the Marks card to set the label
    4. Then, drag Response Rate from the Measures section to the Size icon on the Marks card to set the bar size
    5. Next, drag Savings Amount to Color to create a stacked bar chart
    6. Adjust the legend colors and add a title as needed.
    7. Lastly, reorder the Age Groups and Savings Amounts to make it easier to follow the chartTableau data visualization using Google Sheets
    8. Repeat these steps as many times as needed. (note: watch how I created the final dashboard in 5 minutes)

That should do it!

Now you know exactly how to create a Tableau Dashboard with Google Sheets data! Congrats!

A quick recap on what you’ve learned:

  1. How to import data from your computer into Google Sheets
  2. How to connect that data from Google Sheets to Tableau
  3. How to create a quick dashboard using Google Sheets data and Tableau

2 thoughts on “Tableau and Google Sheets: Step-by-Step Guide To A Quick and Easy Dashboard”

Leave a Reply

Your email address will not be published. Required fields are marked *