Excel and CSV parser – one file with all languages (multi)
Parser ID: Excel_multi.
Use cases: There is one Excel file containing all source and target languages.
Key features:
Manage all strings in a single Excel/CSV file.
Compose string ID based on multiple columns and postfix.
Detect column for target language based on patterns.
Overwrite source texts, or write target to another column.
Select comments for each source string.
CSV and Excel support.
Parser settings: see the Excel parser settings section.
Examples:
All examples use one Excel file with a file ID sample.
More examples
The setting parameters for the mono- and multi-Excel/CSV parsers are the same.
For details about how to deal with comments, hashed IDs, etc., see the examples in the Excel and CSV parser – one file per target language (mono) section.
Source file
Settings
Parameter | Argument |
|---|---|
Row with header | 2 |
First row with data | 2 |
String ID columns | A |
String ID postfixes | |
Source columns | |
Target columns | |
Comment columns | E |
Fallback columns |
The source and target columns are empty. The parser will find the columns according to the language codes (e.g., de-DE) in the Excel file's header.
Resulting IDs
sample.key1 sample.key2 sample.key3
Target file
Source file
Settings
Parameter | Argument |
|---|---|
Row with header | 1 |
First row with data | 2 |
String ID columns | A |
String ID postfixes | |
Source columns | |
Target columns | de-DE ~GERMAN nl-NL Holland |
Comment columns | E |
Fallback columns |
The entries for the source and target columns are empty. The parser will find the columns based on the language codes (e.g., de-DE) in the Excel file's header.
Resulting IDs
sample.key1 sample.key2 sample.key3
Target file
