Page scope

Follow the steps on this page for opening:

• .csv files exported from the CollectionSpace application

• CSV Importer templates

• reports created by the CSV Importer that you will use to prepare additional import batches

• any other .csv data you will be using to prepare data for ingest via the CSV Importer

If you do not follow these steps, you will may run into things like:

• garbled diacritics or other special characters

• leading or trailing zeroes from record number fields being dropped (if “010.10” is interpreted as a number by the application, it will be changed to “10.1”)

• date values being “helpfully” changed to another format

• non-date values being interpreted as and changed to dates

• long numeric IDs (such as ISBNs) being converted to scientific notation format

You may not notice these changes, but if you save them and import them via the CSV Importer, you run the risk of adding incorrect data.

We are providing this small sample CSV for you to download and use to experiment with your own CSV workflows: csv_unforced_quotes.csv. This file contains data formats that will clearly illustrate whether the process you use to open it changes the data:

idNumber,note,date,otherId
20220831.009,"Something, something",2022-08,9784326784987
20220831.010,Something something,9/1/2022,9784326784988
20220831.011,"CSV, not really a standard format",01-04,9784326784989