Skip to content
audo

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

Converted on your device. Nothing is uploaded.

Subtitles as rows in a spreadsheet

One row per subtitle, ready to review.

Your SRT file

boxford-oral-history.srt756 bytes

100:00:00,640 --> 00:00:01,240Oh, yes.200:00:01,240 --> 00:00:02,879Different from Boxwood.300:00:03,440 --> 00:00:04,579Sure, I- I bet.400:00:04,680 --> 00:00:05,799There's not much here.500:00:06,480 --> 00:00:08,000No, no, there's really not.600:00:08,440 --> 00:00:11,939Um, was there ever, uh, do you rememberthere being more businesses here,700:00:12,080 --> 00:00:12,800or has it always been...800:00:12,800 --> 00:00:13,280Not since we've900:00:13,280 --> 00:00:13,880been here.1000:00:13,880 --> 00:00:14,880No?1100:00:15,000 --> 00:00:15,840No.1200:00:15,840 --> 00:00:16,840No businesses.1300:00:16,880 --> 00:00:22,600A hockey rink tried to get into Boxwood,but it was very actively opposed.

The CSV file it makes

boxford-oral-history.csv704 bytes

  • One row per subtitle
  • Start, End, and Text columns
RowABC
1StartEndText
200:00:00.64000:00:01.240Oh, yes.
300:00:01.24000:00:02.879Different from Boxwood.
400:00:03.44000:00:04.579Sure, I- I bet.
500:00:04.68000:00:05.799There's not much here.
600:00:06.48000:00:08.000No, no, there's really not.
700:00:08.44000:00:11.939Um, was there ever, uh, do you remember there being more businesses here,
800:00:12.08000:00:12.800or has it always been...
900:00:12.80000:00:13.280Not since we've
1000:00:13.28000:00:13.880been here.
1100:00:13.88000:00:14.880No?
1200:00:15.00000:00:15.840No.
1300:00:15.84000:00:16.840No businesses.
1400:00:16.88000:00:22.600A 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. 1

    Drop .srt or .vtt subtitle files onto the stage, or select Paste subtitles.

  2. 2

    Toggle Speaker names if needed and inspect the CSV rows in the preview.

  3. 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.

Exported CSV columns
ColumnExampleWhen included
Start00:01:23.456Always
End00:01:26.890Always
SpeakerMariaVTT <v Name> with Speaker names on
TextWelcome 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

All tools