FORUMS: list search recent posts

Spreadsheet to subtitles

COW Forums : Avid Media Composer

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Mustafa S. Zeno
Spreadsheet to subtitles
on Sep 20, 2013 at 1:02:22 am

I have about 10 hours of footage in another language that need to be rough subtitled so the editor can know what the heck he's looking at. He'll be using Avid and I was wondering if there's a way I can make a spreadsheet formatted the right way with timecode and everything so it can be imported into Avid for subtitling?

Thanks in advance for the help.

Return to posts index

Michael Phillips
Re: Spreadsheet to subtitles
on Sep 20, 2013 at 2:55:56 am

You might be able to find someone to convert a CSV or TAB export from Excel to the DS Caption file. It's a simple text format that looks like:

01:00:16:17 01:00:18:08
¿Sabes qué día es hoy?

01:00:19:16 01:00:23:00
"Es tu día especial

01:00:24:17 01:00:27:05
"Tu papá no tiene que enterarse

And can be imported into the SubCap effect on a timeline. Timecode in file must match record side timecode, so use AutoSequence for each source clip, add subcap effect, import from within the effect. You then have to use sequences as source when editing which can be a bit of a pain. Depending on language, ScriptSync can be used where the clip is synced in original language, while the translation is with the dialog but protected by [brackets which ScriptSync ignores. The text document would look like:

[Do you know what day it is?]
¿Sabes qué día es hoy?


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2019 All Rights Reserved