> [!WARNING]
>
> **Preview**
>
>
> This feature is
>
> subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the
> [Service Specific
> Terms](https://docs.cloud.google.com/terms/service-terms#1).
>
> Pre-GA 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).

Using the **Self-service Explores** feature, you can upload CSV, XLS, and XLSX 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. When you upload data, Looker persists your data by writing it to the BigQuery database that is [specified by your Looker admin](https://docs.cloud.google.com/looker/docs/2600/admin-panel-self-service-explore#enable_self-service_explores).

> [!NOTE]
> **Note:** The **Self-service Explores** feature is in preview with limited support. We encourage you to share your feedback to help us improve. To report bugs or issues, send an email to [`upload_file_preview@google.com`](mailto:upload_file_preview@google.com) with the following details:
>
> - A clear description of the problem and the expected behavior
> - Steps to reproduce the issue
> - Any additional relevant details

## 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/2600/admin-panel-self-service-explore).
- A Looker user account with the [`upload_data`](https://docs.cloud.google.com/looker/docs/2600/admin-panel-users-roles#upload_data) permission, which allows a user to upload data files to your instance.

## File requirements

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.

## 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.

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/2600/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, 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 you click **Upload**, Looker uploads your file and analyzes the file's 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.

After Looker has uploaded the file and analyzed the data, Looker creates a LookML model of the data and uploads the data to your BigQuery database. When the model is ready, Looker displays the [**Edit Self-service Explore** page](https://docs.cloud.google.com/looker/docs/2600/exploring-self-service#editing-explore).

After uploading your data, you can do the following:

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

## 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/2600/creating-and-editing-explores) in the Explore.
- [Filter and limit](https://docs.cloud.google.com/looker/docs/2600/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/2600/merged-results).
- [Use table calculations](https://docs.cloud.google.com/looker/docs/2600/table-calculations) to create ad hoc Explore metrics.
- [Use custom fields](https://docs.cloud.google.com/looker/docs/2600/custom-fields) to create ad hoc dimensions and measures.
- [Create visualizations](https://docs.cloud.google.com/looker/docs/2600/creating-visualizations).
- [Save Explore queries as Looks](https://docs.cloud.google.com/looker/docs/2600/saving-and-editing-looks).
- [Add Explore queries to dashboards](https://docs.cloud.google.com/looker/docs/2600/creating-user-defined-dashboards#creating_a_dashboard_from_a_look_or_an_explore).
- [Share data](https://docs.cloud.google.com/looker/docs/2600/sharing-data) with other users.

## 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/2600/exploring-self-service#rename)
- [Modify the data fields](https://docs.cloud.google.com/looker/docs/2600/exploring-self-service#modify_data_fields)
- [Add dimensions and measures](https://docs.cloud.google.com/looker/docs/2600/exploring-self-service#add_fields)
- [Manage access to the self-service Explore](https://docs.cloud.google.com/looker/docs/2600/exploring-self-service#manage_access)
- [Open the self-service Explore](https://docs.cloud.google.com/looker/docs/2600/exploring-self-service#open_explore)
- [Remove the data upload from your instance](https://docs.cloud.google.com/looker/docs/2600/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/2600/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/2600/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/2600/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/2600/functions-and-operators). The [Creating Looker expressions](https://docs.cloud.google.com/looker/docs/2600/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/2600/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.

### 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/2600/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/2600/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/2600/custom-fields).
- Learn about [viewing and interacting with Explores in Looker](https://docs.cloud.google.com/looker/docs/2600/viewing-and-interacting-with-explores).