> [!WARNING]
> **Preview:** This feature is subject to the "Pre-GA Offerings Terms" in the [General Service Terms](https://cloud.google.com/terms/service-terms#1) 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](https://cloud.google.com/products#product-launch-stages).
>
> If you encounter an issue during the Public Preview of self-service Explores, report it to [upload_file_preview@google.com](mailto:upload_file_preview@google.com) and include the following details:
>
> - A clear description of the problem and the expected behavior
> - Steps to reproduce the issue
> - Any additional relevant details

Using the **Self-service Explores** feature, you can upload data files to Looker and then query and visualize the data in a Looker Explore without needing to configure a LookML model or set up Git version control. The following file types are supported:

- comma-separated files (CSV)
- Excel files (XLS and XLSX)
- Google Sheets files

See the [Before you begin](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#requirements) and [Uploading data to create a self-service Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#upload-data) sections for details on the requirements and procedures.

After you upload your file, Looker analyzes the data: For each of the fields in the data file, Looker automatically detects the data type and applies the appropriate format for the data type. Looker also applies a name and a label for each field. Looker creates a LookML model of the data and persists the data by writing it to the BigQuery database that is [specified by your Looker admin](https://docs.cloud.google.com/looker/docs/2602/admin-panel-self-service-explore#enable_self-service_explores). When the model is ready, Looker displays the [**Edit Self-service Explore** page](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#editing-explore).

After you upload your data, you can do the following:

- [Open the Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#open_explore) to create Looker queries that are based on your uploaded data.
- [Add dimensions and measures to your Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#add_fields).
- [Manage access to your Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#manage_access) so that other users can query your Explore.
- [Certify the Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#certify) so that other users know the data is reliable.
- [Remove the data](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#remove_upload) if you no longer need it.

## Before you begin

To use self-service Explores, you must have the following:

- A Looker instance that is running Looker 25.20 or later and has been [configured by a Looker admin to enable self-service Explores](https://docs.cloud.google.com/looker/docs/2602/admin-panel-self-service-explore).
- A Looker user account with the [`upload_data`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#upload_data) permission, which allows a user to upload data files to your instance.

In addition, to enable uploading data from Google Sheets, you must have the following:

- A Looker instance that is running Looker 26.2
- [The required APIs enabled by your Looker admin](https://docs.cloud.google.com/looker/docs/2602/admin-panel-self-service-explore#enable-apis) in the Google Cloud project that houses your BigQuery database

## Uploading data to create a self-service Explore

> [!WARNING]
> **Warning:** Before uploading your data, note the following:
>
> - Because Looker writes your data to BigQuery, your BigQuery administrators will be able to view the data that you upload.
> - Self-service Explores may be lost in case of an instance migration or a system backup and recovery.

The following sections provide information on uploading data from different sources:

- [Uploading data files from your computer (CSV, XLS, and XLSX files)](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#files-from-computer)
- [Uploading data from Google Sheets](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#from-sheets)

### Uploading data files from your computer (CSV, XLS, and XLSX files)

You can create a self-service Explore from a file on your computer as long as the file meets the following requirements:

- The file must be 100 MB or smaller.
- The file must be a comma-separated values text file (CSV) or an Excel file (XLS or XLSX).
- For CSV files, the first row of data in the CSV file must contain the column names for the file.

> [!NOTE]
> **Note:** If your data file contains only string values in all columns, BigQuery may include the header rows as part of your data and create generic names for each column, such as `string_field_0` and `string_field_1`. In this case, you can [edit the self-service Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#modify_data_fields) and rename the data fields.

To create a self-service Explore from a data file on your computer, follow these steps:

1. From the [Looker main navigation menu](https://docs.cloud.google.com/looker/docs/2602/finding-content#using_the_main_navigation_menu), click the **Create** button.
2. Select **Data upload** from the drop-down menu. This action opens the **Data upload** dialog.
3. In the **Data upload** dialog, select the **Upload from local** tab, and then click the **Choose data** button to navigate to and select your data file. (Alternatively, you can drag a file into the **Data upload** dialog.)
4. If you selected an Excel file that has more than one worksheet, specify which worksheet to upload from the **Sheet in selected Excel file** drop-down menu.
5. Click **Upload**.

When the model is ready, Looker displays the [**Edit Self-service Explore** page](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#editing-explore).

### Uploading data from Google Sheets

Looker supports creating a self-service Explore from a tab in Google Sheets. The following are required:

- A Looker instance that your Looker admin has [configured for Google Sheets uploads](https://docs.cloud.google.com/looker/docs/2602/admin-panel-self-service-explore#requirements)
- A Google Sheets document that you have permission to share, and where the first row of data in the Google Sheets tab contains the column names for the data

> [!NOTE]
> **Note:** If your data contains only string values in all columns, Looker may include the header rows as part of your data and create generic names for each column, such as `string_field_0` and `string_field_1`. In this case, you can [edit the self-service Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#modify_data_fields) and rename the data fields.

To create a self-service Explore from a Google Sheets file, follow these steps:

1. In a web browser, navigate to the Google Sheets document that you want to upload to Looker.
2. In the Google Sheets document, select the tab for the specific Sheet that you want to upload.
3. In the web browser URL, verify that the URL contains the following elements:

   - The spreadsheet ID: This is located in the URL between the `/d/` and the `/edit` or `/view` suffix.
   - The sheet/tab ID: This is the `gid` parameter that provides the ID of the Sheet.
4. Copy the URL for the specific tab in Google Sheets that you want to upload, and keep this browser tab open.

5. In another browser tab, open Looker; then, in the [Looker main navigation menu](https://docs.cloud.google.com/looker/docs/2602/finding-content#using_the_main_navigation_menu), click the **Create** button.

6. Select **Data upload** from the **Create** drop-down menu. This action opens the **Data upload** dialog.

7. In the **Data upload** dialog, click the **Import from cloud** tab.

8. In the **Google Sheets URL** field, paste the URL for the tab in Google Sheets that you want to upload.

9. In the **How to grant Google Sheet permission to Looker** section of the **Data upload** dialog, click the **Copy** button to save the Looker service account email to your clipboard. Leave the **Data upload** dialog open.

10. Go back to the browser tab that contains your Google Sheet. In Google Sheets, click **Share**.

    > [!TIP]
    > **Tip:** If you don't have permission to share the Google Sheets document, you can make a copy of the Google Sheets document, and then use the copy's URL to upload the data.

11. In the **Share** dialog, do the following:

    - Paste the Looker service account email into the **Add people, groups, spaces, and calendar events** field.
    - In the drop-down menu next to the input field, select **Viewer**.
    - Clear the **Notify people** checkbox.
    - Click **Share**.
12. Return to the **Data upload** dialog and click **Continue**.

When the model is ready, Looker displays the [**Edit Self-service Explore** page](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#editing-explore).

## Opening a self-service Explore

You can open a self-service Explore in two ways:

- From the Looker **Explore** menu, select the Explore from the **Self-service Explores** section.
- From the **Edit Self-service Explore** page for the self-service Explore, click the **Explore Data** button.

You can use a self-service Explore much in the same way as any other Looker Explore, including performing the following tasks:

- [Query your data](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores) in the Explore.
- [Filter and limit](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting) your results to just the data you're interested in.
- [Merge results from different Explores](https://docs.cloud.google.com/looker/docs/2602/merged-results).
- [Use table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations) to create ad hoc Explore metrics.
- [Use custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields) to create ad hoc dimensions and measures.
- [Create visualizations](https://docs.cloud.google.com/looker/docs/2602/creating-visualizations).
- [Save Explore queries as Looks](https://docs.cloud.google.com/looker/docs/2602/saving-and-editing-looks).
- [Add Explore queries to dashboards](https://docs.cloud.google.com/looker/docs/2602/creating-user-defined-dashboards#creating_a_dashboard_from_a_look_or_an_explore).
- [Share data](https://docs.cloud.google.com/looker/docs/2602/sharing-data) with other users.

In addition, you can prompt Looker to [update the data](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#update-data) if the information in your data file has changed since you initially uploaded it.

## Editing a self-service Explore

After you upload a data file, you can edit the Explore's data fields and manage user access from the **Edit Self-service Explore** page.

There are two ways to access the **Edit Self-service Explore** page:

- When you first upload a data file, Looker will automatically display the **Edit Self-service Explore** page for your data upload.
- Otherwise, from the Looker **Explore** menu, select the Explore from the **Self-service Explores** section. In the Explore page, click the **Edit data fields** link from the bottom of the field picker panel in the Explore:

  ![The Edit data fields link on the Explore page.](https://docs.cloud.google.com/static/looker/docs/images/explore-self-service-edit-2520.png)

From the **Edit Self-service Explore** page, you can do the following:

- [Rename the Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#rename)
- [Modify the data fields](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#modify_data_fields)
- [Add dimensions and measures](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#add_fields)
- [Manage access to the self-service Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#manage_access)
- [Open the self-service Explore](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#open_explore)
- [Remove the data upload from your instance](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#remove_upload)

### Rename the Explore

To rename a self-service Explore, follow these steps:

1. In the Explore page, click the **Edit data fields** link from the bottom of the field picker panel in the Explore.
2. In the **Edit Self-service Explore** page, click the name of the data upload and then enter a new name.
3. Press the **Enter** key to save the name.

The self-service Explore's new name will now be used as the title in the Explore window when you open the Explore, and in the **Self-service Explores** section of the Looker **Explore** menu (you may have to refresh your browser to see the updated name in the **Explore** menu).

### Modify data fields

On the **Edit Self-service Explore** page, the **Data Fields** tab lists the fields that Looker generated from your data file.

You can't delete a generated field; you can only hide it, either by selecting **Hide** from the field's gear menu in the **Data Fields** table, or by clicking the field's **Edit** button and selecting the **Hide this field from Explores and visualizations** checkbox.

To edit a field in a self-service Explore, follow these steps:

1. From the **Edit Self-service Explore** page, in the **Data Fields** tab, click the **Edit** button in the field's row of the **Data Fields** table.
2. In the **Edit** dialog, you can do the following for a field:

   - If a formatting option other than the default is needed, select one from the **Format** drop-down.
   - Edit the name in the **Name** field. The name is used to identify the field in LookML, such as when you want to reference the field to [create a new dimension or measure](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#add_fields) in the self-service Explore.
   - Edit the label in the **Label** field. The label appears in the field picker and in the data table of the Explore.
   - Select **+ Add Description** to add a description, or edit the existing description. The description gives other users more context or information about the field. The description appears in the tooltip for the field in the field picker and in the data table of the Explore.
   - Use the checkbox to hide or display the field in Explores and visualizations.
3. After making your edits, click **Save**.

### Add dimensions and measures

You can build your own dimensions and measures for your self-service Explore. They are defined based on existing fields in the Explore or from [Looker expressions](https://docs.cloud.google.com/looker/docs/2602/creating-looker-expressions), and they remain available to all users of your self-service Explore.

To add a dimension or measure to your self-service Explore, follow these steps:

1. From the **Edit Self-service Explore** page, in the **Data Fields** tab, click the **Add Dimension** or **Add Measure** button.
2. In the **Create Dimension** or **Create Measure** dialog, use the **Expression** box to enter a [Looker expression](https://docs.cloud.google.com/looker/docs/2602/creating-looker-expressions) that calculates the value for your dimension or measure, using any [Looker functions and operators](https://docs.cloud.google.com/looker/docs/2602/functions-and-operators). The [Creating Looker expressions](https://docs.cloud.google.com/looker/docs/2602/creating-looker-expressions#seeing_all_suggestions) documentation page describes how the Looker expression editor suggests field names and displays syntax help for any functions that you use.
3. To use a formatting option other than the default formatting, select a formatting option in the **Format** drop-down.
4. Specify a name in the **Name** field. The name is used to identify the field in LookML, such as when you want to reference the field to [create a new dimension or measure](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#add_fields) in the self-service Explore.
5. Specify a label in the **Label** field. The label appears in the field picker and in the data table of the Explore.
6. Optionally, select **+ Add Description** to add a description that will give other users more context or information about the custom dimension. The description appears in the tool tip for the field in the field picker and in the data table of the Explore.
7. Optionally, select the **Hide this field from Explores and visualizations** checkbox if you want to hide the field.
8. Click **Save**.

On the **Edit Self-service Explore** page, your created fields appear under the generated fields in the **Data Fields** table.

### Updating the data for a self-service Explore

When you create a self-service Explore, Looker uploads the data from your file at the time of the upload. Subsequently, if the data in your file changes after you created the self-service Explore, you can update the data by following the steps in this section.

Note the following for updating the data for a self-service Explore:

- You can update data only for self-service Explores that you created.
- If any of the fields have been changed since the self-service Explore was created, Looker will automatically resolve all backwards-compatible changes.
- If a field from the originally uploaded file is changed in a significant way, such as if the column is renamed or if the data type is changed, Looker will present a **Review changes** dialog that lists the differences. The **Review changes** dialog will list the old name or data type as "Removed," and the new name or data type as "Added." In the dialog you can apply the changes or cancel the data upload. If you confirm the changes, Looker will permanently delete the removed fields from your self-service Explore.

To update the data for a self-service Explore, follow these steps:

1. From the **Edit Self-service Explore** page, click the **Update data** button.
2. In the **Update data** dialog, depending on how you initially created the self-service Explore, do one of the following:

   - If you initially created the self-service Explore by [uploading a file from your computer](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#files-from-computer), click **Choose data** to navigate to the file on your computer.
   - If you initially created the self-service Explore by [specifying a Google Sheets document](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#from-sheets), Looker will upload data from the same sheet of the same Google Sheets document.
3. Click **Continue**.

4. If Looker detects that any of the fields from the original file upload are significantly changed in the new file, Looker will present the **Review changes** dialog:

   - To keep the data from the initial file upload, click **Cancel** to cancel the data update.
   - Otherwise, to accept the updates, click **Confirm**. Looker will permanently delete the removed and renamed fields from your self-service Explore.

If your updated file had no significant changes, or if you confirmed the changes, Looker uploads the data from the specified file to your self-service Explore. When the model is ready, Looker displays the [**Edit Self-service Explore** page](https://docs.cloud.google.com/looker/docs/2602/exploring-self-service#editing-explore).

### Managing access to the self-service Explore

You can share your self-service Explore with other Looker users and user groups by following these steps:

1. From the **Edit Self-service Explore** page, click the **User Access** tab and then click the **Share access** button. (You can also click the three-dot menu at the top of the **Edit Self-service Explore** page and select **Share access**.)
2. In the **Share access** dialog, click the **User or group** field and either select from the drop-down menu or begin typing a username or a group name to filter the menu.
3. In the **Access permission** field, leave the value as **View**.
4. Optionally, click the **Add** button to provide access to another user or group.
5. Click **Share**.

On the **Edit Self-service Explore** page, the **User Access** tab will show the new user or group to which you provided access.

If you want to remove a user or group's access to your self-service Explore, you can click the **Delete user** button in the user or group's row of the **User Access** table.

### Certifying a self-service Explore

Self-service Explores are not based on a LookML model, and therefore their data is considered "ungoverned." When you upload data, the self-service Explore's name is displayed with a yellow "uncertified" badge ![](https://docs.cloud.google.com/static/looker/docs/images/uncertified-content-badge-2520.png) in the **Explore** menu and on the Explore page. This badge indicates that data is both uncertified and ungoverned.

If you have the [`certify_content`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#certify_content) permission, you can add a certification to the Explore so that other users know the data is reliable.

To add a certification to the self-service Explore, perform the following steps:

1. From the Looker **Explore** menu, select the Explore from the **Self-service Explores** section.
2. Click the Explore's gear menu and select **Certify**.
3. In the **Certify this content?** dialog, enter your notes about the Explore, such as the origins of the data and how you know it's valid data.
4. Click **Certify**.

When you certify a self-service Explore, Looker displays a certification badge ![](https://docs.cloud.google.com/static/looker/docs/images/certified-content-badge-2520.png) next to the Explore's name in the **Explore** menu and on the Explore page.

See the [Content certification](https://docs.cloud.google.com/looker/docs/2602/content-certification) documentation page for more information.

### Removing a self-service Explore

You can delete your own data upload and its associated self-service Explore by performing the following steps:

1. From the Looker main **Explore** menu, select the Explore from the **Self-service Explores** section.
2. Click the **Edit data fields** link from the bottom of the field picker panel in the Explore.

   ![The Edit data fields link on the Explore page.](https://docs.cloud.google.com/static/looker/docs/images/explore-self-service-edit-2520.png)
3. On the **Edit Self-service Explore** page, click the three-dot menu.

4. Select **Remove data**.

5. Click **Delete** in the confirmation dialog.

In addition, a Looker admin can delete any user's data upload from the **Self-service Explores** admin page by performing the following steps:

1. From the Looker **Admin** menu, select **Self-service Explores**.
2. In the **Data uploads** table on the **Self-service Explores** page, find the data upload and click the **Delete** button in its table row.
3. Click **Delete** in the confirmation dialog.

## What's next

- Learn more about [creating custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields).
- Learn about [viewing and interacting with Explores in Looker](https://docs.cloud.google.com/looker/docs/2602/viewing-and-interacting-with-explores).