Hi guys,
I need to make a subtitle translation for a video. I have had all the lines, timing in an .xls file in the format:
- column A: number from 1 to n, n is the number of subtitle lines
- column B: start time
- column C: end time
- column D: the actual line
I am trying to convert this file into .srt format. My plan is to simply save the .xls file as a .txt file
which would give me the following format in one line
"number start time end time actual line"
so then in the .txt file I would manually insert line break, insert --> between start time and end time
Also the guy who created the .xls file used this format 00:10:38.729 instead of the regular 00:10:38,729 for time so I also need to manually change all the . to ,
Then I would save this txt file as an srt file.
Would appreciate if anyone has an idea to make this process less time consuming, because I have about 300 lines to edit.
I'm new here so please forgive me if my post did not follow certain rules.
Thank you all!
Try StreamFab Downloader and download from Netflix, Amazon, Youtube! Or Try DVDFab and copy Blu-rays! or rip iTunes movies!
+ Reply to Thread
Results 1 to 5 of 5
Thread
-
-
-
Thank you, I have read that post as well, and it's basically what I described in my post I was looking for a way to not have to do everything by hands
-
Your plan is flawed.
If you have the source as an .xls file then you 'edit' that. I.e. use a program that reads/edits the .xls (not confined to Excel) which can find/replace text or copy a single row over a series of rows as in the '-->'
From there you can create a text file and add the required line breaks since that is not so easy imo to do in a Excel etc.
But 300 lines !!. From what you propose that still would not take longer in a text editor. It could take longer to set the text up. -
Thank you! I would go ahead with your suggestion adding the --> in excel then convert it to .txt file and .srt file
Similar Threads
-
Add subtile (srt) file to existing mkv file
By Hansen in forum SubtitleReplies: 6Last Post: 4th Dec 2016, 03:58 -
How to extract CEA-608 CC within an mp4/m4v file into an SRT file on a Mac?
By Emm_W in forum SubtitleReplies: 2Last Post: 13th Sep 2016, 12:03 -
Converting sup files onto srt
By carlmart in forum SubtitleReplies: 12Last Post: 6th Jun 2016, 16:49 -
How to convert SubExtractor's output .bin file to .srt file?
By EmmB in forum SubtitleReplies: 2Last Post: 14th Jun 2014, 21:36 -
Converting UTF8 subs to srt/smi/sub?
By Agrippa in forum SubtitleReplies: 7Last Post: 5th Jun 2013, 18:57