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:
On the component’s details page, on the Filters tab, add the desired definition as a filter (for example, M.Asset).
On the Functionality tab, turn on the Selection switch.
On the Selection tab, in the Shared pool menu, click Create new and create a new selection pool.
On the Output tab, turn on the Table switch and turn off the Grid switch.
In the Template section, select the TableNoImage option. You can identify this option by its tooltip.
In the Fields section, add the required fields, such as FileName.
Click Save and close.
Configure the Selection component
To configure the Selection component:
On the component’s details page, on the General settings tab, turn on the Enable export to Excel switch.
On the Operations tab, click Add definition and select the desired definition (for example, M.Asset).
On the Export Excel settings tab, click Add definition and add the definition.
To use an export profile, click Add export profile.
Click Save and close.
Export content data
To export content data:
On the menu bar, click the entity you wish to export (for example, assets).
On the desired page, select the item or items you wish to export, click Actions , and select Export to Excel .
In the Export to Excel dialog box, fill in the following fields:
A name for the exported file. The .xslx extension is added automatically.
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.
Public links export settings
Exporting public links is supported for M.Asset entities only. To do this, apply the following settings:
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.
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.