...
The column headers in your spreadsheet need to align with the field names in the database, and the content of your spreadsheet needs to align with the CollectionSpace data model (e.g. dates into date fields).
To use the CSV Importer, data must be saved as a .csv file. Data from Open Office, Excel, Google Sheets, and other spreadsheet applications can all be saved as .csv files.
Data can be imported into a single procedure or authority at a time. Secondary imports can create relationships between existing records , add images and other “blobs” to Media Handling records and/or or create hierarchies.
Instructions for generating templates to help organize and format your data for import. | |
---|---|
Instructions for properly formatting field-level data to ensure a successful import. | |
Instructions and tips for using the CSV Importer to create or update Procedural and Authority Term records, and to create Relationships between records. | |
Instructions for saving files generated in Open Office, Excel, or Google as a CSV. | |
Specific instructions for: importing images or other files on Media Handling procedures; preparing delete batches |