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!
Our website is made possible by displaying online advertisements to our visitors. Consider supporting us by disable your adblocker or try DVDFab DRM and remove iTunes movie & music protection! :)
+ Reply to Thread
Results 1 to 5 of 5
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