SubtitleMedic

Convert SRT to Excel

Turn SubRip subtitles into an Excel workbook (.xlsx), one row per line, ready to translate, review or count.

Processed in your browserNo sign-up.srt

How to convert SRT to Excel

  1. Open your .srt file

    Drop a SubRip file into the box above, or click to browse. No file at hand? Use the .srt sample under the box.

  2. Check the rows

    The preview shows the subtitles as the sheet's cells, one row per subtitle. “What changes” sums up the difference.

  3. Download the .xlsx file

    The file keeps its name with the new extension: movie.srt becomes movie.xlsx. Open it in Excel, Google Sheets, Numbers or LibreOffice Calc.

What the workbook looks like

#StartEndText
100:00:03,12000:00:05,480Is this seat taken?
200:00:06,01000:00:08,900- Only by my coat.
- Sit, please.
300:00:09,34000:00:12,200Where are you headed?

# is the order of the subtitle. It is a real number, so you can sort the sheet by it after filtering or moving rows.

Start and End are text cells holding the SubRip time to the millisecond. Typing over them works the same way: write 00:00:05,000 and it stays exactly that.

Text wraps inside the cell and is aligned to the top, so long lines and two-line subtitles are easy to read.

The heading row is frozen, so it stays on screen while you scroll through hundreds of lines. The headings are always in English, which keeps them the same for every tool that reads the file.

Why Excel instead of CSV

A CSV file is plain text. Excel guesses what each cell holds when it opens one, and its guesses can hurt subtitles: a time may become 01:02.3 and lose its milliseconds, a dialogue line that starts with a dash becomes a formula error, and accents break unless the file has the right marker.

An .xlsx file says what each cell is. Times and lines are stored as text, so Excel shows them as they are and saves them as they are. For working in Excel itself, the workbook is the safer choice. For scripts, databases or Google Sheets imports, Convert SRT to CSV is simpler.

What people do with subtitles in Excel

Translate. The most common use. A column per language keeps the original and the translation side by side, and the times are out of the way.

Review and approve. Add a column for comments or a status. Filters show only the lines still to check.

Spot long lines. A formula such as =LEN(D2) next to the text gives the length of each line. Sort by it to find subtitles that are too long to read, or check the whole file with the Subtitle Checker.

Quote a job. Word counts per file are one =SUM away.

Tips

Sync first. If the subtitles are early or late, fix them with Shift Subtitle Timing before you export. Every row then carries the right time.

Don't insert rows in the middle while translating. If you need an extra subtitle, add it at the bottom with its own times. Convert Excel to SRT sorts the rows by start time anyway.

Garbled letters? The .srt is not UTF-8. Choose the right encoding next to the file name, or repair it with Fix Subtitle Encoding first.

Back to subtitles. When the sheet is done, Convert Excel to SRT turns it into a .srt, with a choice of which text column to use. What is an SRT file? explains the format the sheet goes back to.

Frequently asked questions

What is in the Excel file?

One sheet called Subtitles with four columns, #, Start, End and Text, and one row per subtitle. The heading row is bold and stays in place while you scroll, the text column is wide and wraps, and a two-line subtitle stays in one cell with its line break.

Will Excel change my times?

No. Every time is saved as a text cell in the form 00:01:02,345, so Excel doesn't turn it into a clock time, round it to a tenth of a second or show it as a date. The milliseconds are still there when you convert the sheet back.

Why does a line starting with a dash stay as it is?

In a CSV file, a cell that starts with -, = or + is run as a formula, so it needs a space in front. An .xlsx file says which cells are text, and every subtitle is written as text, so Excel never runs it. "- Where to?" stays exactly as it is.

How do I translate the subtitles in Excel?

Add a column next to Text, call it Translation, and write each line there. Leave #, Start and End as they are. Then open the workbook in Convert Excel to SRT, which picks the Translation column and keeps the original for any row you left empty.

Does it work with Google Sheets and LibreOffice?

Yes. Google Sheets opens .xlsx files from Drive or File → Import, and LibreOffice Calc and Apple Numbers open them directly. All of them keep the cells as text.

Are italics and positions kept?

Yes. Each cell holds the subtitle exactly as SubRip writes it, so tags such as <i> and codes such as {\an8} stay in the text and come back when you convert to SRT. Translators can see where italics start and end.

Are my files uploaded?

No. The workbook is built by JavaScript in this browser tab. Nothing is sent to a server, and the page keeps working if you go offline after it has loaded.