The Sitecore Content Hub has the ability to export the metadata of the data being managed in the Sitecore Content Hub. To change this item, you can use the Export Profile feature provided in the Administration Tool to change the items to be exported.
![](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F7qIqSZxygsAIfJwEGNSRoH%2F05eed7b430944cdc7c6e41bf4bd81c52%2Fchexportexcel11.png&w=3840&q=75)
Content Hub - Adjust Excel export items related to assets
Digital Asset ManagementPublished: 2021-11-01
Check the default behavior
Let's select some assets and choose the Export menu in Excel.
![chexportexcel01.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2Fh3Cw3JpuriEv4Kvvc1F3F%2Ff2a0ba75212c6be6fa8f0a63f1782050%2Fchexportexcel01.png&w=3840&q=75)
The following screen appears as a dialog.
![chexportexcel02.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F25T8biHheKiwAK8wH6wKCo%2Fa9a604ba631662a31b7d03c08fd157c3%2Fchexportexcel02.png&w=3840&q=75)
In this case, we prefer to see the schema items as they are, so we will run the program without checking any of them.
After a few moments, an Excel file will be prepared and its contents will look like this
![chexportexcel03.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F5ngNJ1UfK0W4AbKDJs4o9W%2Fab8fc5eb1b07a4ed6303b878701c05c7%2Fchexportexcel03.png&w=3840&q=75)
You will see the following items come up.
- id
- identifier
- Title
- Description#en-US
- FileName
- VisionDescription
- VisionOcrText
- AssetTypeToAsset
- DRM.Restricted.RestrictedToAsset
- AssetMediaToAsset
- TagToAsset
- VisionColorToAsset
- FinalLifeCycleStatusToAsset
- ContentRepositoryToAsset
- CreatedBy
- CreatedOn
- ModifiedBy
- ModifiedOn
Confirmation of settings
Check the section referring to the export settings. You are working in the Administrative Tools page - select Assets and click on the Selection button.
![chexportexcel04.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F3uhbtnNuvzaPhaEWzFyh3z%2F6d22792337be1f912a67e4f4df6d7d49%2Fchexportexcel04.png&w=3840&q=75)
If you look at the Selection screen, you will see the Export section in the Excel settings. Here you will see that you can select the Add Definition button, select M.Asset.
![chexportexcel05.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2FgPXykMTuV6x0UR9kP7pAz%2F8f984be1fbb01962e74b1f9fd6a509b2%2Fchexportexcel05.png&w=3840&q=75)
If you refer to the export profile, you will see that there is an AssetProfile entry.
![chexportexcel06.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F5ysJBah1ZQJ9XrUlIIrwzw%2F0448d835692d7702b0742d8bc2c59555%2Fchexportexcel06.png&w=3840&q=75)
Extend the schema of M.Asset
To create the data for export, we do a schema. First, add a member named CustomText to the M.Asset summary of the schema.
![chexportexcel07.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F6HsXOzUleqgvwvtO23HKS5%2F363e9e75dd6b04058dcf47a9b64e4faf%2Fchexportexcel07.png&w=3840&q=75)
Apply the changes and verify that the items are valid.
![chexportexcel08.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F3KCA5HpFK42ieJg6fVw4sd%2F0c77a56c91d98dbd5ea588f51baaba47%2Fchexportexcel08.png&w=3840&q=75)
Now that the custom text has been added to the assets to be exported, the data is ready for the demo.
Edit Export Profile
This time we will create a new Export profile. Open the Export Profile in the Administration Tool.
![chexportexcel09.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F4AsoWWjEcNnZJLi9Y9Xpm0%2Fb92424c7191841b6cf32acecaceaa9ac%2Fchexportexcel09.png&w=3840&q=75)
Open AssetProfile and check the items and you will see the following
![chexportexcel10.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F5pSKIc9Om9j6Op0we2bCzy%2F05b7b6c714c229504276c2ed51660c4a%2Fchexportexcel10.png&w=3840&q=75)
Change to Text mode and add an item. This time, assuming that a text area named CustomText has been added to the M.Asset schema, we will add CustomText to Properties.
{
"properties": [
"Title",
"Description",
"FileName",
"CustomText",
"ProductName",
"ProductId",
"TagToAsset",
"VisionDescription",
"VisionOcrText"
],
"relations": {
"AssetTypeToAsset": {
"exportRelatedEntities": false
},
"DRM.Restricted.RestrictedToAsset": {
"exportRelatedEntities": false
},
"AssetMediaToAsset": {
"exportRelatedEntities": false
},
"TagToAsset": {
"exportRelatedEntities": false
},
"ProductCategoryToAsset": {
"exportRelatedEntities": false
},
"ProductFamilyToAsset": {
"exportRelatedEntities": false
},
"VisionColorToAsset": {
"exportRelatedEntities": false
},
"BrandToAsset": {
"exportRelatedEntities": false
},
"FinalLifeCycleStatusToAsset": {
"exportRelatedEntities": false
},
"ContentRepositoryToAsset": {
"exportRelatedEntities": false
}
},
"includeSystemProperties": true,
"publicLinks": {
"asset": false,
"masterfile": false
},
"version": "1.1"
}
The export profile has been updated.
Export again
Select the asset again and perform the export. We have specified Japanese and English as the language for exporting. After a few moments, the file will be ready, and when you download and open the Excel file, you will see that it has been changed as follows.
![chexportexcel11.png](/_next/image?url=https%3A%2F%2Fimages.ctfassets.net%2Fzi1ovlormku8%2F7qIqSZxygsAIfJwEGNSRoH%2F05eed7b430944cdc7c6e41bf4bd81c52%2Fchexportexcel11.png&w=3840&q=75)
We were able to verify that the export items have been changed.
Summary
In this case, we have edited an existing profile and changed the items. In the Excel export setup described in this article, it is possible to create a new profile and use it as the basis for the export. This allows for the output of Excel data to be tailored to each page, so that it is possible to create export profiles, and then separate which pages are exported.