TheFileTool
HomeData & subtitles

JSON → TSV

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.
Excel/Google sheet methodTSV uses tabs and line breaks to separate cells and lines, so if that character is present in a value, it must be handled in one of two ways.
Turn it on only when the Korean alphabet is broken in Excel. Other programs may read the BOM as part of the first heading.
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 your JSON data into a tab-delimited table that you can paste directly into your spreadsheet.

Quality and preservation

Number/True/False distinction

Array structure (as JSON characters)

Related tools

TSV → JSONJSON → CSV

All tools