/google-spreadsheet-i18n

Export Google Spreadsheets to I18n JSON files, though Node API or CLI

Primary LanguageJavaScript

google-spreadsheet-i18n

npm

Export Google Spreadsheets to I18n JSON files, though Node API or CLI.

Installation

CLI:

npm i google-spreadsheet-i18n -g

Help

gstoi18n --help

Usage: gstoi18n <spreadsheet-id> [saveas] [options]

Options:
    -V, --version   output the version number
    -b, --beautify  Beautify final JSON
    -es, --esmodule Export with es module
    -p, --property  File name case (pascal, default, camel, nospace)
    -h, --help      output usage information

Example

Google spreadsheets example,

Example

screen

The address bar red wireframe area is the google spreadsheets id, then

$ gstoi18n 1fhgYGnV7OhMKqYJBDJhf93LU9xNpoVxVjp50cwIVBIM

zhHant:
  hello:   你好
  chinese: 漢語
zhHans:
  hello:   你好
  chinese: 汉语
en:
  hello:   Hello
  chinese: Chinese

save content on your folder,

$ gstoi18n 1fhgYGnV7OhMKqYJBDJhf93LU9xNpoVxVjp50cwIVBIM ./output

It's will create three json file,

# zhHant.json
{
    "hello": "你好",
    "chinese": "漢語"
}
# zhHans.json
{
    "hello": "你好",
    "chinese": "汉语"
}
# en.json
{
    "hello": "Hello",
    "chinese": "Chinese"
}