Tools
Runs locally

TSV to JSON

Tab-separated rows become objects.

Ctrl+Enter runs. Ctrl+Shift+Backspace clears.

Export and import are available after you sign in. Sign in

The first row is the header.

About this tool

Copy a range from a spreadsheet, paste it here and get JSON for a script, a fixture or an API. Spreadsheets put tabs between cells, so no export step is needed.

How to use it

  1. 01

    Copy cells from a spreadsheet, header row first.

  2. 02

    Paste them here.

  3. 03

    Copy the JSON array.

FAQ

Frequently asked questions

Why TSV and not CSV?

Copying cells from Excel or Google Sheets puts tabs between values, which is TSV.

Are numbers converted?

Values are kept as strings so nothing is changed by accident, such as leading zeros.