How do I create an Import Template?

In order to Import any type of .xlsx excel sheet into rightsHUB, you will need to first set up an Import Template.

First, go to Content Manager - Imports.

Then, click the Import Template tab and hit Create.

Fill in the Template Name, the Import Type and set the starting Tab/Row/Column for the data

Hit Save and then upload your Template excel sheet

(Make sure the version you upload has Headers only, no catalogue data should be present in it!)

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 Import Template to Import your metadata sheets.

Remember, any excel with identical headers & headers can now be imported using this single Template.

And if you are having continued issues with Importing, make sure to check the formatting of your data fields in the Template.

Alternatively, you can create an Import Template from an Export Template by clicking 'Generate Import Template' when inside of the relevant Export Template.