Skip to main content

Rigi Documentation

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. For details, 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.

Example 10. Each target has its own text column

Source file

1.png

Settings

Table 9.

Parameter

Argument

Header row

2

First row containing 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

2.png


Example 11. Non-standard titles in the header

Source file

3.png

Settings

Table 10.

Parameter

Argument

Header row

1

First row containing 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

4.png


In this section: