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 to apply those changes to Sitecore Content Hub.

Before you begin

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. On the Functionality tab, 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. On the Output tab, turn on the Table switch and turn off the Grid switch.

  5. In the Template section, select the TableNoImage option. You can identify this option by its tooltip.

  6. In the Fields section, 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, click plus sign Add export profile.

  5. Click Save and close.

Export content data

To export content data:

  1. On the menu bar, click the entity you wish to export (for example, assets).

  2. On the desired page, select the item or items you wish to export, click Actions more options icon, and select Export to Excel export to excel.

  3. In the Export to Excel dialog box, 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 to download it. You can see the progress of any active exports on the 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.

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

RequestResponse
  "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, which explains how use an export profile to export specific user data.

Do you have some feedback for us?

If you have suggestions for improving this article,