• Avid Media Composer

  Spreadsheet to subtitles

  Posted by Mustafa s. Zeno on September 20, 2013 at 1:02 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.

  Michael Phillips replied 12 years, 10 months ago 2 Members · 1 Reply
• 1 Reply

• 

  Michael Phillips

  September 20, 2013 at 2:55 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?

  Michael

Reply to this Discussion! Login or Sign Up