# Viewing annotations made in CSV **URL:** \ **Category:** Uncategorized\ **Tags:** usage\ **Created:** [November 18, 2022, 10:18pm UTC](https://support.prodi.gy/t/viewing-annotations-made-in-csv/6132 "2022-11-18T22:18:55Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![thoughtful](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/thoughtful/32/3424_2.png) [@thoughtful](https://support.prodi.gy/u/thoughtful)\ **Post date:** [November 18, 2022, 10:18pm UTC](https://support.prodi.gy/t/viewing-annotations-made-in-csv/6132/1 "2022-11-18T22:18:55Z")
I have a set of annotations for videos that were exported in CSV format. We want to try and check the annotations. Is there a way to view the videos and pre-made annotaions that were created from the server along with the videos - the same way that they were made? ---
**Author:** ![ryanwesslen](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/ryanwesslen/32/2969_2.png) [@ryanwesslen](https://support.prodi.gy/u/ryanwesslen)\ **Post date:** [November 18, 2022, 11:18pm UTC](https://support.prodi.gy/t/viewing-annotations-made-in-csv/6132/2 "2022-11-18T23:18:30Z")
hi @thoughtful! Thanks for your question and welcome to the Prodigy community 👋 > [@thoughtful](#): > > I have a set of annotations for videos that were exported in CSV format. What type of annotations are they? Transcripts? Image-like annotation like object tracking/bounding boxes? Categories? Something else? How were these annotations created? If in Prodigy, what UI or recipe? If not, what tool exported this csv and/or what columns are in your csv? If you can you give an example that'll make it a lot easier. Depending on what type of annotation, you may need to create a [custom recipe](https://prodi.gy/docs/audio-video#classify) that combines the video with another UI type that aligns to that annotation type (e.g., for categories you'd need the [`choice`](https://prodi.gy/docs/api-interfaces#choice)). At minimum, you'll need either a path to your videos (`".mpeg", ".mpg", ".mp4"`) or a base64 data URI for the video. The Prodigy docs have a section on [different loaders](https://prodi.gy/docs/api-loaders/#loaders-file) including for video. ---
**Author:** ![thoughtful](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/thoughtful/32/3424_2.png) [@thoughtful](https://support.prodi.gy/u/thoughtful)\ **Post date:** [November 19, 2022, 4:40pm UTC](https://support.prodi.gy/t/viewing-annotations-made-in-csv/6132/5 "2022-11-19T16:40:49Z")
The annotations were made on the audio of videos using prodigy and I'm assuming exported as a CSV with the header being: video,text,meta,path,\_input\_hash,\_task\_hash,\_is\_binary,\_view\_id,audio\_spans,answer,\_timestamp The audio\_spans has jsonl formatted text that notes the timestamps of clips from each of the recordings, along with the classification labels for each of the clips. The video files are in mp4 format and I was able to point the server towards the videos and successfully read them if I want to reannotated the videos using the audio.manual with the --load video switch, but I want to see the existing annotations. Unfortunately, the person that made the annotations is not available. ---
**Author:** ![ryanwesslen](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/ryanwesslen/32/2969_2.png) [@ryanwesslen](https://support.prodi.gy/u/ryanwesslen)\ **Post date:** [November 22, 2022, 8:08pm UTC](https://support.prodi.gy/t/viewing-annotations-made-in-csv/6132/6 "2022-11-22T20:08:06Z")
Let's assume this is your data: ```python # wow-video.jsonl {"video":"https://videos.ctfassets.net/bs8ntwkklfua/37JfmMxgY5URkfzGHVFzz6/7b3a2c28337b907156b9d188d915f808/Midnight_in_Paris_Wow_10_480p.mp4","text":"Midnight in Paris","_input_hash":-2034503873,"_task_hash":-591136661,"_view_id":"audio_manual","audio_spans":[{"start":0.2603688983,"end":0.5032927285,"label":"WOW","id":"07e199a6-a4b1-403e-9415-ae6a2043bddf","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147206,"_is_binary":false} {"video":"https://videos.ctfassets.net/bs8ntwkklfua/2DfiudsiNA5n0CR2ibzu38/a405bd61b9c11240aa4dd7e163cc0903/Cars_3_Wow_9_480p.mp4","text":"Cars 3","_input_hash":1465204248,"_task_hash":-460213143,"_view_id":"audio_manual","audio_spans":[{"start":0.0898107358,"end":0.8975401325,"label":"WOW","id":"bfbba0b5-2583-4bd7-9931-1e46e35f25df","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147212,"_is_binary":false} {"video":"https://videos.ctfassets.net/bs8ntwkklfua/7tA15W0lgJr7CpJNCf1m4Z/86a953df81d88f5fa79e35aa1e4e4dc1/The_Big_Bounce_Wow_2_480p.mp4","text":"The Big Bounce","_input_hash":334946211,"_task_hash":-1916326215,"_view_id":"audio_manual","audio_spans":[{"start":0.19570347,"end":0.5278422713,"label":"WOW","id":"eeb6f211-f55e-478c-8c62-8ad9bdd1ff33","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147215,"_is_binary":false} ``` First, load that data into Prodigy as dataset: ```python python -m prodigy db-in wow-video-annotations wow-video.jsonl ``` The key is having the `audio_spans` populated as mentioned [here](https://prodi.gy/docs/api-interfaces#audio). Now run this: ```python python -m prodigy audio.manual review_wow_data dataset:wow-video-annotations --label WOW --loader video ``` The key is using `dataset:` prefix to use your loaded dataset (with the `audio_spans`) as your source. Be sure the value in your `--label` corresponds to the labels you have in your `audio_spans`. Let me know if this works!