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 this web data 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.

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 beta@tableau.com. If you have a particular sheet that's causing problems, you can share it with us by emailing tableaugs100@gmail.com.

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


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

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

What about Excel file in Office 365?

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!


Amazing feature!!!

I'm glad that you like the feature!

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

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?



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."

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

Hi Diego,

you can sync in tableau server


I've created reports based on Google Sheet and synced them to the server, but my co-workers can't see them. They get an error, that they have to log into Google Tables database in order to view the reports. Is there any way that they can see the reports without logging into Google?

Google Sheets connector is unfortunately not perfect. After much investigation today I found that if you are importing historical financial data into your Google sheets and connecting to it via API that Google will prevent the api from transferring the information. In Googles own words "Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you will see a #N/A error in place of the values in the corresponding cells of your spreadsheet." Back to the drawing board for finding security analysis data.

Does anyone have to sign in, every time or multiple times when they connect to Google Sheets or publish? My connections all work and publish to our server but I wish the "Remember this computer" function actually worked.

is this not available for tableau public? cant connect to the other server tho

Subscribe to our blog