# Subtitle Translation Sheet (CSV Excel) Round-trip subtitles through the spreadsheets translation teams actually use: export SRT/VTT cues to a CSV or Excel table (index, start, end, source, target, notes) and re-import the filled sheet as translated SRT — timings locked, in-cell line breaks preserved, and semicolon CSV with UTF-8 BOM for European Excel. > Canonical page: https://elysiatools.com/en/tools/subtitle-translation-sheet - **Category:** Media - **Keywords:** subtitle translation, csv subtitles, excel subtitles, srt to csv, csv to srt, srt to excel, xlsx subtitles, translation table, localization workflow, translator spreadsheet, subtitling agency, srt export, vtt to csv ## Overview Translation vendors and review teams work in spreadsheets, not raw SRT: the established export gives every cue one row with its index, start and end timecodes and the source text, while the translator fills a target column and index and timing stay intact — the exact layout used by Subtitle Edit’s export and agency review flows. This workbench implements that round trip: the exporter writes #/Start/End/Source/Target/Notes with SRT-style timecodes as text cells, preserves multi-line cues as in-cell line breaks (the way Excel and Google Sheets store them), adds a UTF-8 BOM so Excel recognises non-Latin scripts on open, and offers comma or semicolon separators — semicolons are the safe default for European locales where the comma is the decimal separator. The importer reads the sheet back by header name (index/start/end/source/target/notes plus the common aliases text/original/translation/number), sniffs the CSV delimiter, accepts SRT- or VTT-style timecodes or raw milliseconds, and rebuilds translated SRT from the Target column with the original timings; cues whose target cell is still empty can keep the source text or be dropped, and a sheet with no translations at all is rejected as a business error rather than silently rebuilding the source. XLSX workbooks are read and written with the SheetJS engine, CSV with a strict RFC 4180 parser, so commas, quotes and newlines inside subtitle text survive the journey unchanged. ## Inputs - **Subtitle or table file** (file) - **Direction** (select) - **Table format** (select) - **Untranslated cues** (select) ## When to use - Handing off timed video subtitles to freelance translators or review teams who work in Excel or Google Sheets. - Rebuilding production-ready SRT subtitle files from completed localization tables without manual retiming. - Formatting bilingual subtitle spreadsheets for European Excel users using UTF-8 BOM encoding and semicolon delimiters. ## How it works - Upload a subtitle file (SRT, VTT) to export it into a spreadsheet, or upload a filled translation sheet (CSV, XLSX) to import it back into subtitle format. - Select the processing direction and specify your desired table output format (comma CSV, semicolon CSV, or XLSX) or empty-target handling behavior (keep source text or drop cue). - The workbench extracts or reconstructs cue indices, timecodes, source text, and target translations while strictly preserving in-cell line breaks and punctuation. ## Use cases - Exporting locked-timing bilingual review tables for external localization vendors and linguists. - Reconstructing synchronized SRT files from completed client translations delivered in Microsoft Excel workbooks. - Auditing video translations side-by-side with original cues and translator notes before final burning or authoring. ## Frequently asked questions ### Which spreadsheet column headers are recognized on import? The importer maps standard headers including index, start, end, source, target, and notes, as well as common aliases such as number, original, and translation. ### How are multi-line subtitle cues handled across formats? Multi-line cues are retained as in-cell line breaks within spreadsheet cells and are parsed strictly using RFC 4180 rules so commas, quotes, and newlines remain intact. ### What happens if a translator leaves target cells blank? You can configure untranslated cues to either retain the original source text or be omitted entirely from the rebuilt subtitle file. ### Why does the tool offer a semicolon CSV option? Many European locales use commas as decimal separators; semicolon delimiters paired with a UTF-8 BOM prevent Excel from mangling columns or character sets upon opening. ### Can I upload a spreadsheet where timecodes use VTT formats or raw milliseconds? Yes, the importer accepts standard SRT timecodes, WebVTT timecodes, and raw millisecond integer values to reconstruct the cue timestamps. ## Related tools - [JSON-LD Generator from CSV](https://elysiatools.com/en/tools/json-ld-generator-from-csv): Turn CSV or Excel rows into Schema.org JSON-LD for articles, products, or events, with validation-ready output for SEO workflows - [CSV / Excel Diff Tool](https://elysiatools.com/en/tools/csv-excel-diff-tool): Compare two CSV or XLSX datasets and export a PDF report with row, column, and cell-level differences - [XLSX CSV Batch Converter](https://elysiatools.com/en/tools/xlsx-csv-batch-converter): Batch convert CSV/TSV to XLSX or convert XLSX back to CSV/TSV with delimiter and encoding handling - [Excel to CSV Converter](https://elysiatools.com/en/tools/excel-to-csv): Convert Excel file to CSV format, extracting data from the first worksheet - [Barcode Batch Generator](https://elysiatools.com/en/tools/barcode-batch-generator): Batch generate Code 128, EAN-13, UPC-A, ITF-14, QR Code, and Data Matrix outputs from CSV or multiline text - [Time Series Forecast & Seasonality Analyzer](https://elysiatools.com/en/tools/time-series-forecast-seasonality-analyzer): Forecast future periods from CSV or JSON time-series data and inspect trend, seasonal, and residual decomposition in one report - [XLSX Multi Sheet Splitter](https://elysiatools.com/en/tools/xlsx-multi-sheet-splitter): Split a multi-sheet workbook into independent files by sheet name, with ZIP output - [XLSX Sheet to CSV Pack](https://elysiatools.com/en/tools/xlsx-sheet-to-csv-pack): Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics ## Samples - [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing - [CSV Samples](https://elysiatools.com/en/samples/csv-samples): Sample CSV files with various data types, sizes, and complexity levels - [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests - [Windows String Processing - C# Samples](https://elysiatools.com/en/samples/windows-string-processing-csharp): Comprehensive C# string processing examples for Windows platform including string manipulation, splitting, joining, regex operations, and text analysis ## Related content - [Subtitle Translation Sheet Review and Delivery](https://elysiatools.com/en/hubs/subtitle-translation-sheet-review-and-delivery): Export a verified subtitle baseline to CSV or XLSX, coordinate translation review, reconcile imported timings and missing text, and verify selectable subtitle delivery in the target player.