TSV to JSON Converter

When you copy cells from Excel or Google Sheets, the clipboard holds tab-separated values. Paste them here and get JSON: an array of objects keyed by the header row, or an array of arrays if there is no header. Numbers and true/false can be turned into real JSON values instead of strings.

How to use TSV to JSON Converter

1. Copy the cells in your spreadsheet, including the header row, and paste them.
2. Say whether the first row holds column names, and whether to convert numbers and booleans.
3. Copy or download the JSON.

When it comes in handy

• Turning a spreadsheet into test data or seed data for an app.
• Preparing product or price lists for an API.

Frequently asked questions

What if a cell contains a line break?

Spreadsheets quote such cells when copying; the converter reads quoted cells correctly.