CSV format (.csv)
The CSV format reads comma-separated value files, extracts selected columns as translatable blocks, and writes the translations back into the same rows. It handles quoted fields containing delimiters or newlines and optional header rows. The same implementation backs the tab-separated TSV format with a tab delimiter.
By default the first row is treated as a header and every data column is translatable. You can restrict extraction to specific columns, designate key columns that supply each block's ID, mark comment columns whose values become notes, and tune the delimiter, quote character, and row offsets.
Parameters
| Parameter | Type | Default | Description |
|---|---|---|---|
codeFinderRules | array | Regex patterns that match inline codes within translatable text | |
columnNamesRow | integer | 0 | 1-based row number containing column names. 0 means auto-detect. |
commentColumns | array | Column indices (0-based) that contain comments or notes | |
hasHeader | boolean | true | If true, the first row is treated as headers (non-translatable) |
keyColumns | array | Column indices (0-based) that provide the block ID (source ID / record ID) | |
separator | string | , | Field delimiter character (comma for CSV, tab for TSV) |
textQualifier | string | " | Character used to quote field values containing delimiters or newlines |
translatableColumns | array | Column indices (0-based) to extract as translatable content. If empty, all columns are translatable. | |
trimValues | boolean | false | If true, leading and trailing whitespace is removed from cell values |
useCodeFinder | boolean | false | Enable regex-based inline code detection within cell values |
valuesStartRow | integer | 0 | 1-based row number where data values begin. 0 means auto-detect. |
Configure these parameters interactively and copy the YAML on the Format Reference.
Examples
Translate one column, keyed by another
Extract column 2, using column 0 as the record ID.
translatableColumns: - 2 keyColumns: - 0
Headerless semicolon-delimited file
Read a file with no header row and a semicolon delimiter.
separator: ";" hasHeader: false
Processing notes
Each selected cell becomes a translatable block; row structure, delimiters, and quoting form the non-translatable skeleton.
Key columns supply IDs and comment columns supply notes; they are not themselves extracted as translatable content.
Limitations
Column selection is index-based; columns are not addressed by header name.
← Back to the Format Reference