Gå til hovedinnhold

TSV Format format (.tsv)

The TSV format reads tab-separated value files, extracts selected columns as translatable blocks, and writes the translations back into the same rows. It shares its implementation with the CSV format, configured with a tab delimiter, so the same column-selection, key, comment, and inline-code options apply.

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 adjust the delimiter, quote character, and row offsets.

IDtsv
SourceBuilt-in
Extensions.tsv
MIME Typestext/tab-separated-values
CapabilitiesRead + Write

Parameters

ParameterTypeDefaultDescription
codeFinderRulesarrayRegex patterns that match inline codes within translatable text
columnNamesRowinteger01-based row number containing column names. 0 means auto-detect.
commentColumnsarrayColumn indices (0-based) that contain comments or notes
hasHeaderbooleantrueIf true, the first row is treated as headers (non-translatable)
keyColumnsarrayColumn indices (0-based) that provide the block ID (source ID / record ID)
separatorstring,Field delimiter character (comma for CSV, tab for TSV)
textQualifierstring"Character used to quote field values containing delimiters or newlines
translatableColumnsarrayColumn indices (0-based) to extract as translatable content. If empty, all columns are translatable.
trimValuesbooleanfalseIf true, leading and trailing whitespace is removed from cell values
useCodeFinderbooleanfalseEnable regex-based inline code detection within cell values
valuesStartRowinteger01-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 file

Read a tab-separated file whose data begins on the first row.

hasHeader: false

Processing notes

  • Each selected cell becomes a translatable block; row structure and the tab delimiter 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.

  • TSV and CSV share one schema; the only intrinsic difference is the tab delimiter.

← Back to the Format Reference