No Login Data Private Local Save

i18n JSON to CSV Converter - Online Flatten Translation Files

22
0
0
0

i18n JSON โ†” CSV Converter

Flatten nested translation files, merge multilingual JSONs, and convert between formats seamlessly

JSON โ†’ CSV
CSV โ†’ JSON
JSON Input

Drop JSON files here or click to browse

Single file: key-value CSV  |  Multiple files: merged multilingual CSV

Options

Frequently Asked Questions

What is i18n JSON flattening?

Flattening converts nested JSON structures like {"common":{"save":"Save"}} into flat key-value pairs like common.save,Save. This makes translation files easier to manage in spreadsheets and share with non-technical translators.

Why convert JSON translations to CSV?

CSV files can be opened in Excel, Google Sheets, and other spreadsheet tools. This allows translators, product managers, and non-developers to easily review, edit, and manage translations without touching raw JSON.

How does multilingual file merging work?

Upload multiple JSON files (e.g., en.json, zh.json, es.json) simultaneously. The tool extracts language codes from filenames, flattens each file, and merges them into a single CSV with columns: key, en, zh, es, etc. Missing keys are left blank.

What separator should I use for keys?

The dot (.) separator is most common and works with frameworks like i18next. Choose the separator that matches your i18n library's convention. Underscores and slashes are also popular. If unsure, dot is the safest default.

Can I convert CSV back to nested JSON?

Yes! Switch to the CSV โ†’ JSON tab. The tool uses the key separator to reconstruct the original nested structure. For multilingual CSVs, you can export each language column as a separate nested JSON file โ€” perfect for syncing back to your codebase.

Is UTF-8 BOM important for CSV?

Yes, especially for translations with non-Latin characters (Chinese, Arabic, Cyrillic, etc.). UTF-8 with BOM ensures Microsoft Excel correctly detects the encoding. Without BOM, Excel may display garbled text. Our default setting includes BOM for maximum compatibility.

Which i18n frameworks use nested JSON?

Popular frameworks like i18next, react-intl (with nested namespaces), vue-i18n, ngx-translate (Angular), and Laravel localization all support or use nested JSON structures. This tool works with any framework that uses flat or nested JSON translation files.

How are arrays and special values handled?

When flattening, arrays and complex objects at leaf nodes are serialized using JSON.stringify() so they're preserved in the CSV. When converting back with "Smart type detection" enabled, the tool attempts to restore booleans, numbers, and null values automatically.

๐Ÿ”ง Related Tools