...
Open exported .txt file in Microsoft Excel (optional: save the file as a new Excel workbook)
Open Preservica metadata spreadsheet template (USmetadataTemplate.xlsx)
Use the Qualified Dublin Core mapping document CONTENTdm to Preservica Metadata Mapping to copy over content from the exported metadata spreadsheet into the new template
Examples:
Title → title
Call number → not mapping (means this does not need to be transferred to new template spreadsheet)
Subject (LCSH) or Subject (Keyword) → maps to subject
...