In order to Export any type of .xlsx excel sheet out of rightsHUB, you will need to first set up an Export Template.
First, go to Content Manager - Exports
Then, click the Export Template tab and hit Create.
Fill in the Template Name, the Export Type and set the starting Tab/Row/Column for the data.
Hit Save and then upload your Template excel sheet.
From there, take the time to match each column with the matching rightsHUB data field.
Any blank/unmatchable columns should be skipped.
Once all fields are matched, make sure to hit Save.
You're now ready to use your new Export Template to Export your metadata sheets.
And if you are having continued issues with Exporting, make sure to check the formatting of your data fields in the Template.
Alternatively, you can create an Export Template from an Import Template by clicking 'Generate Export Template' when inside of the relevant Import Template.