Bulk Uploading with Spreadsheet Templates and Examples
This guide provides instructions and templates for uploading project information to AVAnnotate in bulk via spreadsheets. AVAnnotate will take .CSV, .TSV, Excel, and .VTT files.
1. Project Level: Include one Event and one Tag spreadsheet.
- Event Spreadsheet Template: Each row in the event spreadsheet is a unique Event in the project. Note: Events may include multiple AV files. See below.
- Tag Spreadsheet Template: Each row in the tag spreadsheet is a unique tag in the project.
2. Event Level: Annotation Spreadsheet Template (or “sets”) correspond to each AV file. AV files may have multiple corresponding annotation sets. Events may have multiple corresponding AV files with multiple annotation sets.
- Annotation Spreadsheet: Each row in an annotation spreadsheet is a single annotation corresponding to a timestamp on the AV file.
Important Note: On annotation spreadsheets, all cells must be filled out. Start time, end time, and annotation are all required. Tags are optional, but the Tags header cannot be deleted. If the tag column is used, all tag cells must be completed.
Spreadsheet Examples
Sample Audio Spreadsheets:
- Leslie Flint’s Spiritualism
These event, tag, and annotation spreadsheets represent two events included in an AVAnnotate project about Leslie Flint’s direct voice mediumship. Flint example spreadsheets - Zora Neale Hurston
These event, tag, and annotation spreadsheets represent a multi-event project including three recordings created by Zora Neale Hurston. Hurston example spreadsheets
Sample Video Spreadsheets - -Camille (1921)
These event, tag, and annotation spreadsheets represent a single video event about the 1921 film adaptation of “La Dame aux Camélias” (1848) by Alexandre Dumas, fils. Camille example spreasheets