TheFileTool
HomeData & subtitles

JSON → CSV

Drop JSON files here

Advanced settingsOutput settings
Column like address.cityEither way, the array values fit into one space as JSON letters like ["a","b"]. If the expanded column name is duplicated, an error is displayed instead of overwriting the value.
Some Excel environments may incorrectly read Korean characters in UTF-8 CSV without BOM. Turn it off when inserting it into a program that does not support BOM.
Values starting with =, +, -, and @ can be executed as formulas in Excel and Google Sheets, so put a single quotation mark (') in front of them. Leave numbers like -5 as is.
If it is not UTF-8, it is read as EUC-KR.It also automatically reads UTF-16 BOMs and saves the results as UTF-8. Select it manually only if the encoding of the file without BOM does not match.
Conversion details

Turn an array of objects into a table that opens right in Excel, with nested values spread out into “parent.child” columns.

Quality and preservation

Number/True/False distinction

Array structure (as JSON characters)

Related tools

CSV → JSONJSON → TSV

All tools