excel2lang is a small utility program which takes a xlsx file as an input and extracts the languages strings to a JSON format. It has several cool features:
- Support comment lines
- Can create multiple files
- Use the first column as default if no value
npm install -g excel2lang
excel2lang input.xlsx
Your excel must be like this:
| # | Unique ID | English | French |
|---|---|---|---|
| C | id | en | fr |
| F | ./{lang}.json | ||
| # | Generic | ||
| open | Open | Ouvrir | |
| browse | Browse | Parcourir | |
| edit | Edit | Modifier | |
| select | Select | Selectionner | |
| F | ./topbar/{lang}.json | ||
| # | Topbar | ||
| topbar/file | File | Fichier | |
| topbar/help | Help | Aide |
The first column indicates what the line is for:
| Character | Description |
|---|---|
| nothing | Regular line of strings. |
| C | Code line, indicating the language code for each column. |
| F | The JSON file to create. Will include all lines until the end of the file or another F line. The {lang} substring will be replace by the current language code. |
| # | Comment line. |
In order to work, a C line MUST be the first line of the excel sheet (beside comment line). Also, a F line MUST be present before the first string line.
- More checks for errors