SRT to CSV converter: subtitles to Excel and Sheets
ColumnsStart (00:01:23.456)EndSpeaker (when present)Text (UTF-8 BOM)
Turn .srt and .vtt subtitle cues into a UTF-8 CSV spreadsheet.
10M+ files processed since 2021
Subtitles as rows in a spreadsheet
One row per subtitle, ready to review.
Your SRT file
boxford-oral-history.srt756 bytes
The CSV file it makes
boxford-oral-history.csv704 bytes
- One row per subtitle
- Start, End, and Text columns
| Row | A | B | C |
|---|---|---|---|
| 1 | Start | End | Text |
| 2 | 00:00:00.640 | 00:00:01.240 | Oh, yes. |
| 3 | 00:00:01.240 | 00:00:02.879 | Different from Boxwood. |
| 4 | 00:00:03.440 | 00:00:04.579 | Sure, I- I bet. |
| 5 | 00:00:04.680 | 00:00:05.799 | There's not much here. |
| 6 | 00:00:06.480 | 00:00:08.000 | No, no, there's really not. |
| 7 | 00:00:08.440 | 00:00:11.939 | Um, was there ever, uh, do you remember there being more businesses here, |
| 8 | 00:00:12.080 | 00:00:12.800 | or has it always been... |
| 9 | 00:00:12.800 | 00:00:13.280 | Not since we've |
| 10 | 00:00:13.280 | 00:00:13.880 | been here. |
| 11 | 00:00:13.880 | 00:00:14.880 | No? |
| 12 | 00:00:15.000 | 00:00:15.840 | No. |
| 13 | 00:00:15.840 | 00:00:16.840 | No businesses. |
| 14 | 00:00:16.880 | 00:00:22.600 | A hockey rink tried to get into Boxwood, but it was very actively opposed. |
Subtitles made by Transcribe · Joan Tarleton, Boxford Town Library oral history, 2013 (Internet Archive, CC0)
How to convert SRT to CSV
- 1
Drop .srt or .vtt subtitle files onto the stage, or select Paste subtitles.
- 2
Toggle Speaker names if needed and inspect the CSV rows in the preview.
- 3
Click Download .csv (or Download all · ZIP) and open in Excel, Google Sheets, or Numbers.
Spreadsheet workflows for subtitle tracks
Localization & QA
Build translation review and LQA tracking sheets
Give localization teams one row per cue in Excel, Google Sheets, or Airtable, with millisecond Start and End times locked beside the source dialogue.
Logging & content audits
Run broadcast logging, legal review, and content audits
Sort documentary, broadcast, or deposition captions by timecode or Speaker column, tag compliance notes in adjacent cells, and archive searchable logs.
Database & analytics import
Load timed dialogue into Python, SQL, or BI dashboards
Export clean RFC 4180 rows with normalized HH:MM:SS.mmm timestamps and formula-safe quoting for speaking-time analysis or search indexing.
Subtitle spreadsheets without garbled text
Audo runs SRT to spreadsheet and VTT to CSV conversion locally in your browser with zero uploads, turning each cue into an RFC 4180 row with Start, End, Speaker (when WebVTT <v Name> voices exist and Speaker names is on), and Text columns. Timestamps normalize to HH:MM:SS.mmm across SubRip and WebVTT inputs, HTML markup is stripped, and rolling YouTube duplicates collapse.
Opening a bare UTF-8 CSV in Microsoft Excel often scrambles non-Latin scripts and accents into mojibake like é. Every download prepends a UTF-8 byte order mark (BOM) with CRLF line breaks so subtitles to Excel, Google Sheets, Apple Numbers, and Airtable open cleanly in Spanish, French, Arabic, Cyrillic, or Japanese—while quoting commas and prefixing leading =, +, -, or @ characters against formula errors. For AI caption localization, open Translate subtitles.
| Column | Example | When included |
|---|---|---|
| Start | 00:01:23.456 | Always |
| End | 00:01:26.890 | Always |
| Speaker | Maria | VTT <v Name> with Speaker names on |
| Text | Welcome back. | Always (tags stripped) |
Questions
Is Audo's SRT to CSV converter free?
Yes, Audo exports SRT and VTT files to CSV spreadsheets free of charge, with no sign-up and no cap on rows or batch count. Convert feature-length scripts or drop a series folder for one ZIP.
Are subtitle files uploaded when making a CSV?
No, Audo builds the CSV table locally in your browser memory, so legal transcripts, broadcast logs, and unreleased localization sheets never leave your computer.
Which columns appear in the CSV?
Audo writes Start, End, and Text columns with 00:01:23.456 times for SRT files, and adds a Speaker column before Text whenever a VTT file contains <v Name> spans and Speaker names is on.
Why does the UTF-8 BOM matter in Microsoft Excel?
Without a byte order mark, double-clicking a UTF-8 CSV in Excel often misreads accents and non-Latin alphabets as é. The UTF-8 BOM Audo includes tells Excel on Windows and Mac to render every script properly.
Can I translate cues automatically or create a CSV from audio?
Use Audo's Translate subtitles to localize SRT or VTT cues into up to five languages with timing preserved, or run SRT file generator first when starting from audio or video.
More tools
- Text to SRTSync a script to audio.
- Auto captionsPut your words on the picture.
- Remove filler wordsCut the ums and uhs.
- Bleep censorBleep or mute swear words.
- Audio translatorSpeech into translated text.
- Translate subtitlesSubtitles in more languages.
- AI dubbingDub video in the speakers' voices.
- YouTube chapter generatorChapters and notes from a recording.
- Text to speechTurn a script into a voiceover.
- SRT to speechVoice your subtitles on time.