Page Comparison

Via the CollectionSpace GitHub repository: https://github.com/collectionspace/cspace-config-untangler/tree/main/data/templates. You do not need to know how to use GitHub to generate a data import template.

1. To access the template, first click on the correct release number, then the name of your profile. If you’re not sure what release/profile you’re on, you can check the bottom right corner of your login screen.

2. A list of all templates available for your profile will be shown. 

3. To move the template from GitHub to the spreadsheet program of your choice, click on the Raw button, select all (CTRL-A) from the resulting page, and copy it to your clipboard (CTRL-C).

   1. In Open Office, open a new spreadsheet, click on cell 1A, and paste the data (CTRL-V). If the data is all in one column on the left:

      1. Click on the letter A to select the entire column

      2. Go to the Data menu and select Text to Columns

      3. Under Separation options, select the Separated by radio button and click the checkbox next to Comma

      4. Select OK

   2. In Excel, open a new spreadsheet, click on cell 1A, and paste the data (CTRL-V). If the data is all in one column on the left:

      1. Click on the letter A to select the entire column

      2. Go to the Data Menu, and select Text to Columns 

      3. In the Text Wizard, select the Delimited radio button

      4. Click Next

      5. Select Comma as your Delimiter

      6. Click Finish

   3. In Google Sheets, create a new spreadsheet, click on cell 1A, and paste the data (CTRL-V). If the data is all in one column on the left:

      1. Click on the letter A to select the entire column

      2. Go to the Data Menu and select Split text to columns

4. The correct column headers will be located in Row 7 of your spreadsheet.

5. Tip: Save the template locally after going through this process so you don’t have to do it every time you use the tool. Be sure to check the release notes for new releases, we’ll always note any schema changes that would require an update to your template.