03A - Importing and Editing Annotations in Data Manager

To upload annotations to your audiovisual event in AVAnnotate, you have two options. First, you can create annotations in a Google Sheets template available in the documentation and import that template in AVAnnotate’s Data Manager section. The second option you have is to add individual annotations to your audiovisual event directly in AVAnnotate’s Data Manager section. In this video we will show you how to complete the first option.

Navigate to AVAnnotate’s documentation. Then, go to the Projects tab and you will see the Annotation Spreadsheet Template under the Bulk Uploading section. Select the hyperlink, and then make a copy of the file by selecting File and then Make a Copy. Don’t delete the headers in row 1.

Now, you can start adding your annotations. In column A, add the start time of your annotation, using the format of HH:MM:SS. Next, in column B, add the end time of your annotation using the same format. Column C is where you will include the text of your annotation; you can type directly into this cell.

Please note that basic HTML tags are allowed in the body of annotations to style your text.

Finally, add at least one tag that corresponds to an annotation by inserting the tag name into column D. You can add multiple tags to an annotation by using the pipe (|) symbol on your keyboard.

Once you have added all of your annotations for an audiovisual event into the template, you can select File, Download, and it is suggested that you save your file as a Microsoft Excel spreadsheet.

Finally, navigate back to AVAnnotate. In Data Manager, select the audiovisual event that you would like to associate with the annotation file. Below the audio, you will see that there are no annotations associated with the event. Select Import, choose the annotation file from your drive, and then you will be prompted to configure the data.

Double check that the columns match the data you’ve created, and then select Import and Save.