...
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 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
...