Skip to content

aaronlamz/excel-to-json

Repository files navigation

logo

build

⚡ 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