Xlsx-keys-to-json NPM

XLSX KEYS TO JSON

This project is a helper to convert excel keys files to json. You can use it for an i18n purpose.

From this file,

:warning: keys should be used to define keys column!

You can generate single result.json or multiple fr.json, en.json files. The en.json looks like that

{
  "hello": {
    "world": "Hello",
    "bye": "Bye"
  },
  "thank": {
    "you": {
      "guys": "Thanks"
    }
  }
}

Install module locally npm i xlsx-keys-to-json or globally

xkj --src example/example.xlsx --dest example/yes/yes --name i18n_{}.json --tab 4 --multi true

const { extract } = require('xlsx-keys-to-json');

extract(options);

name	alias	description	default
src	s	excel file to parse
dest	d	destination folder	process path
name	n	destination filename for multiple files extraction	result.json for single extract {}.json where `{}` will be replaced by top column
tab	t	tab spacing in json	2
multi	m	single or multiple files	true

4 years ago

4 years ago