Connect to Google Sheets

Connect to a Google Sheets worksheet or range.

Google Sheets is part of the Google Docs suite of productivity apps. Google Sheets lets you create and format online spreadsheets, and work on them simultaneously with other people. The Data Studio Google Sheets connector allows you to access data stored in a Google Sheets worksheet.

All of the columns you've included in the connection now appear as fields in the data source. See Work with data source fields to learn more about configuring your data source.

Options

Use first row as headers causes the data source to use the first row in your worksheet as the field names in the data source. If this option is not selected, the field names will use the column index (A, B, C, etc.)

Include hidden and filtered fields lets you include or exclude these fields from the data source. The default value is to include them. This option only applies to filters, not to filtered views. Learn more about filters in the Sheets Help Center.

Optional Range lets you define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: e.g., A1:Z26.

Field editing in reports

The Field Editing in Reports data source option allows report editors to change field definitions at the chart level. Editing field definitions in the report makes customizing your reports faster and easier. Learn more.

Configure the data source

The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Learn more about working with data source fields.

Control who sees the data

In the upper right of the fields panel, you can change the data source credentials. Credentials control who can see the data provided by this data source.

USING OWNER'S CREDENTIALS lets other people view or create reports that use this data without requiring them to have their own access to the data set.

USING VIEWER'S CREDENTIALS, on the other hand, requires each user of the data source to provide their own credentials to access the data set.

New to Data Studio?

Notes

Data Studio requires that the range or worksheet selected be in a tabular format.

The header row must be a single row.

All cells within a column should be of the same type.

The range or worksheet you select should represent a table. Mixing other non tabular data, charts, sparklines, or other non-data information will result in data quality issues in your reports.

Once you connect to a spreadsheet, you may only append, or remove columns from the sheet. Rearranging, inserting, or removing columns other than the last one is currently not supported and can lead to data quality issues. If you need to rearrange columns, you should create a new data source.

Troubleshooting

If you're having trouble connecting to your spreadsheets, consider the following:

Data Studio does not support accessing files on Team Drive. Please ensure that your Sheets are stored in standard Drive folders.

Make sure that you are using the same account for both Data Studio and Google Drive. If you've accidentally connected Data Studio to a different Drive account, you can remove that connection, then reconnect using a different account.