Tool for building translations from Google Sheet
The idea behind the tool is to read translations from a Google Sheet and output them as string resources for iOS or Android.
Tool can be installed using the command
dotnet tool install -g csvtrans
The tool supports the following input sources:
- A local CSV file
- An online CSV source
- A Google Sheet
The column headers in the input identifies the target languages (e.g. en, en-US, da-DK etc.) with the following special columns:
| Column Name | Purpose |
|---|---|
| Key | Mandatory identifier for the string |
| Comment | Optional comment for the trasnslation |
| Default | Optional default value |
An example sheet can be found here: SampleTranslations
Supported outputs are:
- Apple string resources (iOS)
- Android string resources
- Json dictionary
- Resx resources
USAGE: csvtrans [--help] [--sheet <document id> <sheet name>]
[--csv <url or path>] [--format <apple|android|resx>]
[--outputdir <directory path>] [--name <string>]
[--convert-placeholders <regex pattern>]
OPTIONS:
--sheet, -s <document id> <sheet name>
specify a Google Sheet as input.
--csv, -c <url or path>
specify a online or local cvs file as input.
--format, -f <apple|android|resx>
specify the output format.
--outputdir, -o <directory path>
specify the output directory.
--name, -n <string> specify an optional name for the output.
--convert-placeholders, -p <regex pattern>
convert placeholders to match the output format.
--help display this list of options.