Annotation Spreadsheet Template

This template includes project annotations. Annotations correspond to a given start and end point in the audio or video artifact, and contain information about the AV item. The nature of this information is entirely up to the user. For example, annotations might include a transcript; captions; information about formal features of the media, such as shot sequence, volume, or lighting; historical or cultural context; environmental noise, such as fans or car horns; or conceptual notes or themes. Annotations are linked to an event during the upload process.

Annotations may overlap in time and will appear in the interface in sequence by earliest start time.

Annotation Spreadsheet Template
Start Time: Marks the point in time in hours, minutes, and seconds that is the target of an annotation.
End Time: May be the same as start time for a point in time, or may correspond to the end of a range of time that is the target of the annotation.
Annotation: This is the body of the annotation (e.g., transcription, notes on environmental sounds, formal features, etc.) Basic HTML tags are allowed in the body of annotations, including: b em i italic strong br blockquote p a
Tags (optional): are pipe (|) separated; if a tag is unique across the project, include just the tag; if a tag belongs to multiple groups, the group must also be included with a colon (e.g., “Speakers: Allende Gossens, Salvador, 1908-1973 | Presidents: Allende Gossens, Salvador, 1908-1973 | Frei Montalva, Eduardo, 1911-1982 | Pinochet Ugarte, Augusto, 1915-2006”).

Important Note: In the current version, tags are optional during spreadsheet uploads, but the “tag” header is required. Otherwise, the column can remain blank.