Add or modify titles from an external source

You can easily import metadata from an external source and add it to your current ONIXEDIT Cloud catalogue. To do so, follow these steps:

1- Download the Excel template

The template contains 100 preformatted lines with all the required ONIX lists already defined. The first line is a complete eBook sample. If you need more lines, you can copy/paste the first one.

2- Enter your title's metadata using the Excel template downloaded at step #1. You can type it one by one or import it from a CSV file or other source. The important thing to remember is that you can neither add, delete nor move the columns of the Excel template. However, for columns validated by a drop down list like Contributor Role, there is no need to provide the complete list value. Only the code is required. But if you prefer not to use the predefined ONIX list, you will have to remove the validation of the column. To do so, follow these steps

• First, click on the Data tab in Excel;
• Second, select the cell(s) for which you want to remove the validation;
• Third, select Data Validation

• Finally, select Any value and click OK.

Excel will then allow you to enter the ONIX code only.

As an example, in the above picture, the first value of the drop down list for Contributor role shows "A01-By (author)". If you import metadata from an external source, you can enter only A01. It will be accepted by ONIXEDIT.

If you need to have the complete reference of all the valid ONIX values, please refer to EDItEUR website.

3- Once your Excel file is completed, go back to your ONIXEDIT Cloud account, select the catalogue where you want to import your metadata and then, use the action "Import metadata from Excel template":

If you did not altered the Excel template (like moving columns around or deleting some) ONIXEDIT will import and convert each line of the Excel file to a corresponding ONIX title. At the end of the import process, you will find your new titles in the Main List.

If some titles already exist (based on the ISBN13), they will be modified by the new imported metadata.