The CollectionSpace CSV Importer is a tool used to import data saved in a spreadsheet directly into CollectionSpace. You may use the tool to create entirely new records and relationships, or to make updates to existing records. Data in the spreadsheet must be formatted properly for a successful import. Key elements include (all discussed in greater detail below):
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 and/or or create hierarchies.