Create a Looker Studio report from 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 others. You can create a Looker Studio report directly from Google Sheets.
Create a report
To create a new report from Google Sheets, follow these steps:
- Navigate to the Google Sheet from which you would like to create a report.
- In the Google Sheets toolbar, click Extensions.
- In the Looker Studio section of the Extensions menu, select Create a new report. Google Sheets displays the Looker Studio report creation panel.
- Optionally, configure report options in Google Sheets.
- Click Create. Looker Studio opens in a new tab and creates a report from the sheet.
- If you don't have a Looker Studio account, you will be prompted to create an account. Enter your country and your company name.
- To save the report, click Save and share.
- If you don't click Save and share, the report will be deleted after 24 hours.
After you save the report, you can edit the report and share the report.
Options
- Use first row as headers causes the data source to use the contents of 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 cells lets you include or exclude this data from the data source. The default value is to include them. This option applies only to filters, not to filtered views. Learn more about filters in the Sheets Help Center.
- Include selected range lets you define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: for example, A1:Z26.
Update the data source
When you create a report from Google Sheets, Looker Studio creates a new data source for the Sheet.
To update the data source, follow these steps:
- If the data in the Sheet has changed, manually refresh your report data.
- If columns have been added or edited in the Sheet, refresh the data source fields.
Things to consider
- By default, the name of the report will be Looker Studio Reporting - <timestamp>, where <timestamp> is the date and time that the Looker Studio eport was created.
- Your data must be in a tabular format. Learn more about how to prepare your Google Sheets to work with Looker Studio.
- Merged cells are not supported. Unmerge all cells before creating a report.
- The header row must be a single row.
- All cells within a column should be of the same type.
- Make sure that your date fields are formatted using the
Datedata type, so that Looker Studio can correctly interpret them as dates for the report.