Spreadsheet Ingest Templates

Last Updated, April 29, 2024.

 

The spreadsheet ingest template provides users the ability to upload multiple rows of objects (media) to the repository by using a spreadsheet. To help make the process less prone to errors and to save users time with data entry, the spreadsheet ingest template includes data validation capabilities for certain fields. This process allows you to select from a drop-down menu the values that are valid for that field. The template is in Microsoft Excel (.xlsx) format and for best results we recommend using this file with the desktop version of Microsoft Excel. Additional documentation on using this with Google Sheets is coming soon.

 

Spreadsheet Ingest Templates with Examples by Content Type

As we continue to improve the spreadsheet ingest template based on user feedback, we recommend you download the latest version each time you are preparing for a large ingest. If you are new to the spreadsheet ingest process, the following templates provide examples of how to enter content into the spreadsheet based on frequently utilized formats and use cases.

Spreadsheet Ingest Template Examples

To download the training version which includes examples of how to populate the sheet click the link below and download the Microsoft Excel file to your local machine.

 

Spreadsheet Ingest Template - Blank with All Columns

For those ready to populate the spreadsheet with their own content, the CTDA Modern Islandora Spreadsheet Ingest Template All Columns template includes all of the column headers available to ingest content. 

You will also need to map the CTDA network folder to add your objects to be ingested as part of the spreadsheet ingest process.

Once your content is uploaded, the file name for your files in the digital_file column must include the following path as a prefix /opt/ingest_data/group#/ followed by your file name (ex. /opt/ingest_data/34/myfilesname.pdf ).

Download this Spreadsheet Template to Begin Populating With Your Content

To download the spreadsheet template to begin populating it with your own content click the link below and download the Microsoft Excel file to your local machine. 

 

Using the Spreadsheet Ingest Template

The spreadsheet ingest template includes validated fields to help users enter content that will not generate errors for those fields that have a list of expected values that must be utilized.

After you download the spreadsheet template open the file in Microsoft Excel of Google Sheets to familiarize yourself with the template.