The Looker Studio Microsoft Excel connector lets you access the data stored in an Excel worksheet.
Preview
This product or feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA products and features are available "as is" and might have limited support. For more information, see the launch stage descriptions.
How to connect Looker Studio to Excel
An Excel data source can connect to a single worksheet in an Excel workbook.
To connect to Excel, follow these steps:
- Sign in to Looker Studio.
- On the Looker Studio home page, in the top left, click
Create and then select Data Source.
- Select the Microsoft Excel connector.
- Upload an Excel spreadsheet.
- Configure any of the data source options (see the General options section of this article for more details).
- In the upper right, click CONNECT.
- The data source fields panel appears.
- The data source is now connected to your data set.
Create and then select Data Source.All of the columns you've included in the connection now appear as fields in the data source. See Create and edit data sources to learn more about configuring your data source.
General options
When you're setting up the Excel Connector, you can configure the following 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 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.
- Include specific 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.
- Select rows to skip lets you specify certain rows that Looker Studio should ignore when creating the data source.
- Select columns to skip lets you specify certain columns that Looker Studio should ignore when creating the data source.
You can also configure these options later by editing the data source connection.
Field editing in reports
The Field Editing in Reports data source option lets report editors change field definitions at the chart level. Editing field definitions in the report makes customizing your reports faster and easier. Learn more about editing fields in reports.
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
At the top of the fields panel, you can change the data credentials. Credentials control who can see the data that this data source provides.
OWNER'S CREDENTIALS let other people view or create reports that use this data without requiring them to have their own access to the dataset.
VIEWER'S CREDENTIALS, on the other hand, require each user of the data source to provide their own credentials to access the dataset.
Learn more about data credentials.
Create a new report from the data source
- In the upper right, click CREATE REPORT.
- The report editor appears.
- Click ADD TO REPORT.
- This action adds the data source to the report.
- You can now create charts and controls that get their data from this data source.
New to Looker Studio?
Take the Create a report tutorial. Or learn more about the report editor.
Storage limits
When you're using the Excel connector in Looker Studio, the following storage limits apply:
- You can upload Excel files up to 100 MB.
- You can store up to 2 GB in Excel data sources.
Notes
Note the following requirements and limitations for sheets uploaded with the Excel Connector:
- The header row must be a single row.
- All cells within a column should be of the same type.
- Password-protected files are not supported.
- Macros are not supported.
- Pivot tables are not supported.
Providing feedback
If you encounter any issues while using this feature, or have other feedback for our team regarding this feature, please submit feedback using the Excel Connector for Studio Feedback form.