Answers.Body: <p>I Couldn't find a way to import into Aegisub, but If the subtitles are in a standard spreadsheet such as Excel, I saved as other format and chose Tab delimited text. Copy all the data in this text file and paste into Subtitle Edit. Then adjust limits on times (Will not overlap the next start time). Then save in whatever format you'd like to use in Aegisub.</p>
  
  <p>I suggest you to use Subtitle Edit because of it's VERY simple sync feature with the video as well as these other abilities. At least it works and you can use Aegisub for your more familiar uses.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-01-09T09:22:07.497Z
Answers.Text: Does subtitle edit exist on Mac OS X? I couldn't find it..
Answers.UserDisplayName: tomh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-01-09T07:18:40.300Z
Answers.LastActivityDate: 2015-01-09T07:18:40.300Z
Answers.UserDisplayName: john samuels135
Body: <p>I have a set of timed transcripts in a spreadsheet in the following form:</p>
  
  <pre><code>Timecode mm:ss:ff  |   Line of dialogue
  01:02:25           |   This is some dialogue
  </code></pre>
  
  <p>I would like to import them into <a href="http://aegisub.org" rel="nofollow">Aegisub</a>, running on Mac OSX.
  Is there an easy way to do this?
  Note that I do not have start &amp; stop times for subtitles, only start times.
  Ideally I would make each line of subtitles remain on screen until the next one was due to take over, then manually adjust them in Aegisub afterwards.</p>
  
  <p>I know that Aegisub can <a href="http://docs.aegisub.org/manual/Editing_Subtitles" rel="nofollow">import plain text scripts</a>, but this doesn't appear to include importing timecodes for some strange reason?  Am I missing something?</p>
  
Tags: <subtitles>
Title: Import subtitles from spreadsheet into Aegisub?
UserDisplayName: tomh
ThreadText: # Import subtitles from spreadsheet into Aegisub?
  
  (Asked by: username_0 on 2015-01-08)
  
  I have a set of timed transcripts in a spreadsheet in the following form:
  
  ```
  Timecode mm:ss:ff  |   Line of dialogue
  01:02:25           |   This is some dialogue
  
  ```
  
  I would like to import them into [Aegisub](http://aegisub.org), running on Mac OSX.
  Is there an easy way to do this?
  Note that I do not have start & stop times for subtitles, only start times.
  Ideally I would make each line of subtitles remain on screen until the next one was due to take over, then manually adjust them in Aegisub afterwards.
  
  I know that Aegisub can [import plain text scripts](http://docs.aegisub.org/manual/Editing_Subtitles), but this doesn't appear to include importing timecodes for some strange reason? Am I missing something?
  
  **Tags:** subtitles
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-01-09. Score: 1
  
  I Couldn't find a way to import into Aegisub, but If the subtitles are in a standard spreadsheet such as Excel, I saved as other format and chose Tab delimited text. Copy all the data in this text file and paste into Subtitle Edit. Then adjust limits on times (Will not overlap the next start time). Then save in whatever format you'd like to use in Aegisub.
  
  I suggest you to use Subtitle Edit because of it's VERY simple sync feature with the video as well as these other abilities. At least it works and you can use Aegisub for your more familiar uses.
  
  > **Comments:**
  > **username_0**: Does subtitle edit exist on Mac OS X? I couldn't find it..  
  
  ---
  
  