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,

keys	fr	en
hello.world	Bonjour	Hello
hello.bye	Au revoir	Bye
thank.you.guys	Merci	Thanks

⚠️ 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"
    }
  }
}

Usage

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

Cli

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

Js

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

extract(options);

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