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 *

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

List of 10 Awesome Data Visualization Books

All set! Check your email to download.

Tableau Dashboards
Beginner’s Guide

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.


All set! Check your email :)

Massive List of Tableau Web Data Connectors

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

4-page PDF showing 10 slope graph examples + a video walkthrough

All set! Check your email to download the bonus materials.

Tableau Tutorial Chart Redesign

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

All set! Check your email to download.

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!

Tableau Scatter Plots: The Complete Guide

Get the step-by-step checklist guide to create scatter plots with Tableau


All set! Check your email :)

Rebuild a Busted Chart with Tableau

Enter your best email to get the PDF version of this tutorial + the companion Tableau workbook for free

All set! Check your email to download.

Download the Bonus Materials

Enter your best email to get the PDF checklist version of this guide and the companion Tableau workbook for free.

All set! Check your email :)