[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-25。"],[],[],null,["# Connect to Microsoft Excel\n\nThe Looker Studio Microsoft Excel connector lets you access the data stored in a local Excel worksheet. Looker Studio stores copies of your uploaded worksheets in a Cloud Storage bucket.\n\nHow to connect Looker Studio to Excel\n-------------------------------------\n\nAn Excel data source can connect to a single worksheet in an Excel workbook.\n\nTo connect to Excel, follow these steps:\n\n1. [Sign in to Looker Studio.](https://lookerstudio.google.com)\n2. On the Looker Studio home page, in the top left, click add **Create** , and then select **Data Source**.\n3. Select the **Microsoft Excel** connector.\n4. In the **Available Files** section, click **+ New** to upload an Excel spreadsheet, or select a previously uploaded Excel spreadsheet.\n5. In the **Worksheets** section, select the worksheet to use for the data source.\n6. Configure any of the data source options (see the **General options** section for more details).\n7. In the upper right, click **CONNECT** .\n 1. The worksheet is added to your Available Files list.\n 2. The data source fields panel appears.\n 3. The data source is now connected to your [dataset](/looker/docs/studio/dataset).\n\nAll the columns you've included in the connection now appear as fields in the data source. See [Create and edit data sources](/looker/docs/studio/about-data-sources) to learn more about configuring your data source.\n\n### General options\n\nWhen you're setting up the Excel Connector, you can configure the following options:\n\n- **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.).\n- **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.\n- **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`.\n- **Select rows to skip** lets you specify certain rows that Looker Studio should ignore when it creates the data source.\n- **Select columns to skip** lets you specify certain columns that Looker Studio should ignore when it creates the data source.\n\nYou can also configure these options later by [editing the data source connection](/looker/docs/studio/edit-the-data-source-connection).\n\n### Field editing in reports\n\nThe **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](/looker/docs/studio/edit-fields-in-your-reports).\n\nConfigure the data source\n-------------------------\n\nThe 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](/looker/docs/studio/model-your-data).\n\nControl who sees the data\n-------------------------\n\nAt the top of the fields panel, you can change the data credentials. Credentials control who can see the data that this data source provides.\n\n**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.\n\n**VIEWER'S CREDENTIALS**, on the other hand, require each user of the data source to provide their own credentials to access the dataset.\n\n**SERVICE ACCOUNT CREDENTIALS** rely on a special type of Google Account that represents a non-human user that can authenticate and be authorized to access data.\n\n[Learn more about data credentials](/looker/docs/studio/data-credentials-article).\n\nCreate a new report from the data source\n----------------------------------------\n\nTo create a new report from the data source, follow these steps:\n\n1. In the upper right, click **CREATE REPORT**. The report editor appears.\n2. Click **ADD TO REPORT** .\n 1. This action adds the data source to the report.\n 2. You can now create charts and controls that get their data from this data source.\n\n### New to Looker Studio?\n\nTake the [Create a report tutorial](/looker/docs/studio/tutorial-create-a-new-report).\n\nDelete or download Excel spreadsheets\n-------------------------------------\n\nThe **Available Files** section lists the Excel spreadsheets that you have previously uploaded. You can delete spreadsheets to free up space and download spreadsheets to your device.\n\nWhen you're using the Excel connector in Looker Studio, the following storage limits apply:\n\n- If you don't have Looker Studio Pro, you can store up to 2 GB in Excel data sources.\n- If you have Looker Studio Pro, you can store up to 5 GB in Excel data sources.\n\nTo delete or download spreadsheets, follow these steps:\n\n1. [Sign in to Looker Studio.](https://lookerstudio.google.com)\n2. On the Looker Studio home page, in the top left, click add **Create** , and then select **Data Source**.\n3. Select the **Microsoft Excel** connector.\n4. The **Available Files** section lists the Excel spreadsheets that you have previously uploaded. Click the three-dot menu next to the spreadsheet that you'd like to delete or download, and then choose one of the following options:\n\n- To delete the spreadsheet, click **Delete**. Important: Deleting an Excel file will also delete any data sources that use the file, potentially impacting charts and reports.\n- To download the spreadsheet, click **View in Cloud** . Looker Studio opens the Cloud Storage bucket where your spreadsheet is stored. Click the three-dot menu next to the spreadsheet that you'd like to download, and then select **Download**.\n\nLooker Studio Pro features\n--------------------------\n\nIf you have Looker Studio Pro, you can store up to 5 GB in Excel data sources instead of 2 GB.\n\nIf you store more than 2 GB in Excel data sources and then downgrade from Looker Studio Pro, spreadsheets that you have already uploaded won't be affected. However, you won't be able to upload new spreadsheets until your total storage is less than 2 GB.\n\nNotes\n-----\n\nNote the following requirements and limitations for sheets that are uploaded with the Excel Connector:\n\n- If you don't have Looker Studio Pro, you can store up to 2 GB in Excel data sources.\n- If you have Looker Studio Pro, you can store up to 5 GB in Excel data sources.\n- You can only upload Excel files up to 100 MB.\n- The header row must be a **single row**.\n- All cells within a column should be of the **same type**.\n- Excel Online spreadsheets are not supported.\n- Password-protected files are not supported.\n- Macros are not supported.\n- Pivot tables are not supported.\n- An Excel spreadsheet can be used by one or more data sources.\n- The **Available Files** section lists only the Excel spreadsheets that you have previously uploaded, not spreadsheets uploaded by other members of your organization.\n\nRelated resources\n-----------------\n\n- [About data sources](/looker/docs/studio/about-data-sources)"]]
