JSON to TSV converter

Convert JSON arrays or JSON Lines to tab-separated values that paste straight into a spreadsheet, with nested fields flattened into their own columns.

Loading the tool…

How to use it

  1. Paste JSON or drop a .json / .jsonl file.
  2. Choose how nested objects and arrays are flattened.
  3. Copy (and paste into a spreadsheet) or download the .tsv.

Private by design

The conversion runs as JavaScript in this tab. Your data is not uploaded, logged or stored. There is no account and no file-size paywall.

Why TSV for JSON data

TSV needs no quoting as long as values contain no tabs or line breaks, and this converter replaces any it finds with spaces. Copy the output and paste it into Excel or Google Sheets, and the columns split automatically.

Questions

Is my file uploaded anywhere?

No. The file is read by JavaScript in this tab and never leaves your device. You can load the page, switch off Wi-Fi and it keeps working.

Can I get CSV instead?

Yes, the JSON to CSV converter has the same options plus delimiter and quoting choices.

Related tools