-
Spreadsheet to subtitles
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.
-
1 Reply
-
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 especial01:00:24:17 01:00:27:05
“Tu papá no tiene que enterarseAnd 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?Michael
Reply to this Discussion! Login or Sign Up