Select Page

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

Download the free PDF version of this guide

Want to save some time or keep a copy of this guide for yourself? Download the PDF version of this guide for free right now.

  • Full checklist of the 3 steps needed to connect Tableau and Google Sheets
  • Printable 1-page PDF with detailed step-by-step instructions
  • Keep as a reference to create Tableau Dashboards using Google Sheets data quickly

Download Now

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 docs.google.com
    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 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 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!

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 into Tableau
  3. How to create a quick dashboard using Google Sheets data and Tableau

Download the free PDF version of this guide

Want to save some time or keep a copy of this guide for yourself? Download the PDF version of this guide for free right now.

  • Full checklist of the 3 steps needed to connect Tableau and Google Sheets
  • Printable 1-page PDF with detailed step-by-step instructions
  • Keep as a reference to create Tableau Dashboards using Google Sheets data quickly

Download Now

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

Download the FULL listing of 10 free data visualization books covering dozens of topics across 100s of pages. All nice and neatly organized in an awesome Google Sheet for you to print or copy.

All set! Check your email :)

Tableau Dashboards: Beginner’s Guide (Free PDF)

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(Free List)

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

This 4-page example PDF lists 10 examples of slope graphs curated from around the web with author links for each one. You'll also see the 16-minute walkthrough video where I create an interactive Tableau Dashboard from scratch. 

You have Successfully Subscribed!

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.

Tableau Tutorial Chart Redesign

You have Successfully Subscribed!

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!