# How to Connect a Google Sheets Report to Data Studio

> **Note:** In this article, we'll show you how to use Google Sheets as a data source for Data Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Data Studio charts for visually engaging presentations.

## Activate the Spreadsheet Addon

<iframe src="https://www.youtube.com/embed/bdwY8yCSE7c" width="560" height="315" title="Video" allowfullscreen></iframe>

## Using the Spreadsheet Addon

The spreadsheet addon is included in our Grow, Pro, and Custom (formerly Enterprise) plans. It enables you to use all of our connectors with Google Sheets and Excel, though only Google Sheets can be connected to Data Studio.

## Create a Report in Google Sheets

The addon panel is similar to the connector configuration page in Data Studio except that you create each table individually. When creating a report to connect to Data Studio, make sure the date range matches the one you are using in your Data Studio report.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-1.png)

Deselect **Show report header** under **Options**.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-2.png)

Make a note of the name of the report and the sheet you wish to connect.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-3.png)

## Connect the Sheet to Data Studio

Click **Add data** at the top of the screen.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-4.png)

Select **Google Sheets**. This is a free connector provided by Google.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-5.png)

Select the report and sheet you wish to connect. Leave **Use first row as headers** checked.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-6.png)

Click **Add**, then click **Add to Report**.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-7.png)

## Verify and Edit Your Data

Select **Manage added data sources** under **Resource.**

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-8.png)

Click **Edit** next to the spreadsheet.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-9.png)

Verify each field has the correct label and type. If needed, modify the field type. Select the arrow and choose the correct type from the drop-down menu.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-10.png)

## Use Your Sheet in Charts

Select your spreadsheet under **Data Source** to use it in a chart.

![](https://knowledge.powermyanalytics.com/application/reports/images/how-to-connect-a-google-sheets-report-to-looker-studio-11.png)
