---
title: "Export Excel data"
slug: "export-excel-data"
abstract: "How to export Excel data."
---
# Export Excel data

Exporting data as an Excel spreadsheet gives you an easy way to edit, add, or delete information about multiple entity definitions at the same time. When you've made the necessary changes, you can [import the file](https://doc.sitecore.com/ch/en/users/content-hub/import-excel-data.html "Import Excel data") to apply those changes to Sitecore Content Hub.

## Before you begin

- Ensure you have either a [blank page](https://doc.sitecore.com/ch/en/users/content-hub/create-a-page.html "Create a page") or an existing page suitable for exporting data. This page must include a [**Search** component](https://doc.sitecore.com/ch/en/users/content-hub/search.html "Search") and a [**Selection** component](https://doc.sitecore.com/ch/en/users/content-hub/selection.html "Selection").

## Configure the Search component

To configure the **Search** component:

1. On the component’s details page, on the **Filters** tab, add the desired definition as a filter (for example, *M.Asset*).
2. In the left pane, in the **Tools** section, turn on the **Selection** switch.
3. On the **Selection** tab, in the **Shared pool** menu, click **Create new** and create a new selection pool.
4. In the left pane, turn off the **Grid** switch and turn on the **Table** switch.
5. On the **Template** tab, select the **Table without image** option.
6. On the **Fields** tab, add the required fields, such as **FileName**.
7. Click **Save and close**.

## Configure the Selection component

To configure the **Selection** component:

1. On the component’s details page, on the **General settings** tab, turn on the **Enable export to Excel** switch.
2. On the **Operations** tab, click **Add definition** and select the desired definition (for example, *M.Asset*).
3. On the **Export Excel settings** tab, click **Add definition** and add the definition.
4. To use an [export profile](https://doc.sitecore.com/ch/en/users/content-hub/create-an-export-profile.html "Create an export profile"), click :mdiPlus: **Add export profile**.
5. Click **Save and close**.

## Export content data

To export content data:

1. On the menu bar, click the entity you want to export (for example, assets).
2. On the desired page, select the item or items you want to export, click **Actions** :mdiDotsHorizontal:, and select **Export to Excel** :mdiCloudDownloadOutline:.
3. In the **Export to Excel** dialog, fill in the following fields:

    | Field name | Description |
    | --- | --- |
    | **Filename** | A name for the exported file. The *.xslx* extension is added automatically. |
    | **Cultures** | Lets you apply one or several cultures to the exported file. |
    | **User-friendly column headers** | Lets you apply meaningful labels to column headers, instead of them being given technical member names. |
    | **User-friendly cell values** | Lets you add extra columns with meaningful labels for every value. |

    > [!warning]
    > If you turn on the **User-friendly column headers** switch, you will not be able to reimport the file.

4. Click **Export**.

> [!tip]
> When the export is complete, go to [**Downloads**](https://doc.sitecore.com/ch/en/users/content-hub/download-order.html "Download order") to download it. You can see the progress of any active exports on the [**Current activity**](https://doc.sitecore.com/ch/en/users/content-hub/current-activity.html "Current activity") tab of the **Stats** page, which you can access from the **Manage** page. An export is considered healthy if the majority of its finished jobs have completed successfully.

## Public links export settings

Exporting public links is supported for *M.Asset* entities only. To do this, apply the following settings:

```json
"publicLinks": {
    "asset": false,
    "masterfile": false
  }

```

The **asset** parameter triggers the export of completed and active public links for assets, while the **masterfile** parameter triggers the export of completed and active public links for master files.

> [!tip]
> For another example of exporting data to an Excel file, see [Export users](https://doc.sitecore.com/ch/en/users/content-hub/edit-excel-data.html "Edit Excel data"), which explains how use an export profile to export specific user data.