Connect Directly to Google Sheets in Tableau 10

By Martin Sleeman May 5, 2016

Update: Tableau 10 is here! Download now to try out the feature outlined below.

Got your data in Google Sheets? You can connect directly to your data in Tableau 10!

Here’s how the new Google Sheets connector works.

Connecting to Your Google Sheet from Tableau

To connect to your Google Sheet, simply select the option under “More Servers…” on the Connect menu.

After entering your Google Sheets credentials, you will see the list of available sheets.

Select your sheet and click “connect.”

If you have many Google Sheets and want to find a particular sheet, you can use the search bar to narrow the results. In the example below, I narrowed the results to only sheets containing “consumer” in the name.

If you aren’t sure if this is exactly the sheet you are looking for, you can open it in a web browser by selecting the “open in Google Drive” link below the preview pane.

Once the sheet has been loaded into Tableau, you can drag out the individual sheets from your Google Sheet and join or union them together. You can also union and join Google Sheets with other data sources.

From there you can do all the classic analyses you would on any other data source!

Share Your Google Sheets for Fast Collaboration

It’s easy to share Google Sheets with your colleagues. Use the built-in sharing feature in Google Sheets to share a link to your data source. Your colleagues can then ask their own questions of the data.

In Tableau, you can see all the sheets you have access to as well as who owns the sheets you’re using. For more information on how to share sheets, check out this Google support doc.

To open a Google Sheet you’ve received via a link, simply paste the link into the search bar and click "search." The shared sheet will now be selected for you in the list of sheets.

You cannot union together multiple Google Sheets that span different files.

Got an Error? Try This Fix

If you get an error message when attempting to use a particular Google Sheet, it may be because there are errors on your Google Sheet.

If your Google Sheet has errors like #DIV/0! or #N/A, Tableau can't create an extract and an error message will appear. To resolve this issue, wrap the function with an IFERROR() calculation and have it return a blank or any value that's appropriate.

For example, the sheet below includes a #DIV/0! error.

The solution is to wrap the function in an IFERROR() calculation.

If you have suggestions or feedback on our Google Sheets connector, don’t hesitate to email If you have a particular Google Sheet that's causing problems, you can share it with us by emailing

Join the Beta

Currently in beta, Tableau 10 includes a brand new look and feel, and a host of new features to help you prep, analyze, and share your insights even faster. Check out our Coming Soon page for details.

We have a timeline for getting Tableau 10 out the door, but we’d first like to get solid usage in beta and fix any bugs. We want your feedback as early as possible to catch any issues and ensure the new features are great.

Check out our beta program to learn more and sign up. The beta program is available for existing Tableau customers. Customers with an active maintenance license can upgrade for free when Tableau 10 is released.

Learn More about Tableau 10


Submitted by Joshua M. on

It seems as though it is necessary to sign into Google even to open a sheet shared via link. Is that the case?

Submitted by Martin S. on

Hey Joshua,

Thanks for the reply. Yes, you will need to sign into Google (even though you strictly don't need to) in order to access a shared link. We made that decision because the flow gets complicated if we only sometimes require users to log in to their Google account for the non shared link case.

Thanks again for your interest in Tableau's Google Sheets!
-Martin Sleeman
Product Manager

Submitted by Fernando (not verified) on

What about Excel file in Office 365?

Submitted by Veronica S. on

Amazing feature!!!

Submitted by Martin S. on

Hey Fernando,
Google Sheets won't cover Excel in Office 365, but we are looking at ways of accessing those files in the future. Stay tuned. Thank you for your feedback!


Submitted by Martin S. on

I'm glad that you like the feature!

Submitted by Tausif F. on

I was just discussing about this feature and here it is.

Submitted by Julio M. on

Hi, I have tried to connect with google sheet, I can see the sheet in tableau but when I choose and connect then appeared internal error

can i help me?



Submitted by Clay K. on

I also receive the message "Internal Error - An unexpected error occurred and the operation could not be completed." This message appears a split-second after the message "Loading the data source for the first time. Load time may vary depending on data set size and resources available."

Submitted by Diego (not verified) on

I want to know if there is a way to keep sync the Google Sheets data with tableau.

Submitted by Julio M. on

Hi Diego,

you can sync in tableau server


Add new comment

non-humans click here