⚡ Why need this?

i18n messages is stored in Excel file, but it is not easy to edit in your code. So, this tool is created to convert Excel to JSON.

📜 Features

Excel data structure is converted to JSON. The key of the first column of the first row is required.

| key | zh_CN | zh_HK | en | and more languages... |:---|:---|:---|:---|:---| | hello | 你好 | 你好 | hello | ... | | world | 世界 | 世界 | world! | ... |

output JSON:

{
   "zh_CN": {
        "hello": "你好",
        "world": "世界",
    },
    "zh_HK": {
        "hello": "你好",
         "world": "世界",
    },
    "en": {
        "hello": "hello",
         "world": "world!",
    }
}

🌈 Installation

Using npm:

$ npm install -g excel-to-json-parser

Using yarn:

$ yarn global add excel-to-json-parser

🔥 Usage

run etj --help without arguments to see list of options:

Usage: etj --sourceFile <dir>

Options:
  -V, --version           output the version number
  -s, --sourceFile <dir>  source file path need to be converted
  -h, --help              display help for command

use CLI

etj --sourceFile /yourdir/example.xlsx
// or
etj -s /yourDir/example.xlsx

🔧 Examples

run example

yarn example

©️ License

MIT