How to Edit Subtitles in Excel or CSV, Then Convert Them Back

Editing subtitles line by line in a text editor is fine for a quick fix, but it falls apart fast for bulk translation, timing review, or handing captions off to someone who isn't comfortable with raw SRT syntax.

Why a spreadsheet is often the better editing tool

Subtitle files are really just structured data — an index, a start time, an end time, and text — which happens to be exactly what a spreadsheet is good at displaying and editing. Sorting, filtering, spell-checking, and bulk find-and-replace are all easier in a grid than scrolling through a plain-text .srt file counting sequence numbers.

Exporting SRT to CSV or Excel

The SRT ⇄ CSV Converter and SRT ⇄ Excel Converter break an SRT file into rows — one row per caption, with separate columns for start time, end time, and text — so a translator or editor can work in a familiar spreadsheet instead of a raw text file. Once the edits are done, the same tools convert the spreadsheet straight back into a valid SRT file with correctly formatted timestamps.

Starting from a spreadsheet instead

Sometimes the workflow runs the other way — captions get drafted in a spreadsheet first, especially when timing comes from a separate process like a transcription service's export. The CSV ⇄ SRT Converter and Excel ⇄ SRT Converter take rows of timed captions and generate a properly formatted SRT file, handling the timestamp formatting so you don't have to hand-write SubRip's comma-based time syntax.

Getting a plain transcript from ASS

Advanced SubStation Alpha files carry styling information alongside the text, which gets in the way when all you need is the words and timing — for a transcript, a summary, or a translation pass. The ASS ⇄ Text Converter strips the styling and formats the result as a readable, timestamped transcript, and can rebuild an ASS file from an edited transcript afterward.

Where this workflow is common

1. A localization team translating captions for multiple languages in a spreadsheet, then generating a separate SRT file per language.
2. A video editor doing a timing pass in Excel — adjusting start and end times in bulk — instead of clicking through a subtitle editor one line at a time.
3. A course platform importing captions that were originally delivered as a spreadsheet from a transcription vendor.
4. Someone cleaning up an ASS file's dialogue for a translation, without needing to touch its styling tags.

Keeping timestamps intact through the round trip

The main risk with a spreadsheet-based workflow is a translator or editor accidentally reformatting a timestamp cell — Excel is quick to "helpfully" reinterpret a value that looks like a time or a formula. Keeping the start and end time columns as plain text during editing, and only letting the converter handle the timestamp formatting on the way back to SRT, avoids the most common cause of subtitles drifting out of sync after a spreadsheet round trip.

Processed entirely on your device

Subtitle content — especially for unreleased content — never gets uploaded. Every conversion in this workflow runs in your browser using the file you provide.

Try them

Export existing subtitles with SRT ⇄ CSV or SRT ⇄ Excel, build new ones with CSV ⇄ SRT or Excel ⇄ SRT, or get a clean transcript from ASS with the ASS ⇄ Text Converter.