Grouped Translation Files to Excel (TypeScript)

Node.js + TypeScript CLI tool to convert translation files like notifications.js / brand.json into .xlsx.

What it does

• Top columns are inferred from language keys inside each file (en, ru, it, ...).
• Rows are grouped per source file.
• Left key column is translation key (key).
• Missing keys in any language become empty cells.
• Nested objects are flattened using dot notation (auth.login.title).
• Root-level keys are supported too (appName, save, etc.).

Install

npm install
npm run build

Usage

translations-to-excel to-xlsx --input <translations-root-folder> --output <output.xlsx>
translations-to-excel from-xlsx --input <input.xlsx> --out-dir <output-folder> [--format json|js]

Example:

node dist/cli.js to-xlsx --input ./locales --output ./translations.xlsx
node dist/cli.js from-xlsx --input ./translations_grouped.xlsx --out-dir ./restored --format json

Or with npm script:

npm run to-xlsx
npm run from-xlsx

Output format:

• .xlsx only

Import format is controlled by --format:

• json -> writes <file>.json
• js -> writes <file>.js as module.exports = { ... }

Folder layout example:

locales/
  notifications.js
  brand.json

Each file must contain language objects at the top level:

module.exports = {
  en: {
    title: "Hello"
  },
  ru: {
    title: "Privet"
  }
};

Only this grouped structure is supported.

For .xlsx output:

• Each source file gets its own sheet.

Reverse command (xlsx -> files)

Use this to collect data from an .xlsx file and recreate translation files with key-value objects:

node dist/cli.js from-xlsx --input ./translations_grouped.xlsx --out-dir ./restored_locales --format json

or:

node dist/cli.js from-xlsx --input ./translations_grouped.xlsx --out-dir ./restored_locales --format js

Supported translation files

The CLI reads translation files directly from the input folder (non-recursive).

• .js, .cjs, .mjs, .json
• .json files are parsed as JSON
• .js, .cjs, .mjs files are loaded as module exports
• Export/content must be an object

CommonJS example:

module.exports = {
  common: {
    hello: "Hello"
  }
};