Free tab to JSON array converter

Tab to JSON array

What the tab to JSON array converter does

Copy a row or a column of cells out of Excel, Google Sheets or Numbers, paste it here, and this tool splits it on the tab characters the spreadsheet inserted between each cell, trims every value, and returns a clean JSON array. Nothing about the value text is touched, only the tab boundaries between values.

It runs in your browser. Nothing you paste is uploaded, there is no signup, and there is no limit on how many rows you convert or how often you come back.

Where the format comes from

Why a spreadsheet copy is tab-separated, not comma-separated

When you select a range of cells in a spreadsheet and copy it, the application places a plain-text version on your clipboard alongside the rich formatting. That plain-text version separates each cell with a literal tab character, not a comma. This is what a TSV, tab-separated values, file actually is.

The reason this matters is a comma inside a cell's contents, a price, a note with a comma in it, a name written last-first, stays exactly as typed when the cell boundary is a tab. Comma splitting would shred that cell in two. Tab splitting will not, because the spreadsheet never puts a literal tab inside a cell's own text; the tab is reserved for the boundary between cells.

How it works

How to convert a spreadsheet copy to a JSON array in three steps

Nothing to configure, nothing to export as a file first.

Step 1

Select the cells in your spreadsheet, copy them, and paste directly into the input box here.

Step 2

Press Convert. The tab split and trimming happen instantly on your own device.

Step 3

Copy the resulting JSON array from the output box.

Why it matters

What breaks when tabs get lost along the way

Tab characters are invisible, which is exactly why they are useful as a delimiter and exactly why they are easy to lose without noticing. Paste a spreadsheet row into a text editor that is set to convert tabs into spaces on paste, or into a chat app that strips them, and the tab boundaries you needed are gone before this tool ever sees them.

When that happens, the whole pasted row or column comes back as one single item rather than several, because there is nothing left to split on. If your result looks like one long string instead of several array items, check the source you copied from for a setting that silently converts tabs to spaces.

The mechanics

Why tabs survive an Excel copy where commas would not

A cell in a spreadsheet is a free-text field. Nothing stops someone from typing a comma into it, a price, a list, a sentence, so a comma cannot safely be assumed to mean 'end of cell' when reading that data back out. A tab character, on the other hand, is not something anyone types into a spreadsheet cell in ordinary use. Excel and Sheets reserve it as the boundary marker in a plain-text copy precisely because it almost never appears inside real cell content.

That is the whole reason a TSV paste is safer to split than a comma-joined string built by hand: the delimiter was chosen by the software specifically because it will not collide with the data.

Straight answer

Does it preserve blank cells in the row?

Not exactly. Two tabs in a row, which represents an empty cell between two filled ones, produce an empty string after the split, and this tool drops empty items rather than keeping them as blank array entries. That means the resulting array's length may be shorter than the number of columns in your original row if any cell was empty.

For extracting the actual values out of a row, that is usually exactly what you want. If you need to preserve column position even through blank cells, this tool is not the right one for that job.

Who uses it

Who uses a tab to JSON array converter, and when

Developers use it to turn a single spreadsheet column into a JSON array of test data or seed values without exporting a file and writing a parser for it. Analysts use it to pull one row of figures out of a report and drop it straight into a JSON payload for a script or an API call.

No-code builders use it when an automation tool expects an array but the source data lives in a spreadsheet cell range. It also comes up whenever someone has copied a row out of Excel to paste into a chat or a ticket and now needs that same data as JSON for a developer to use.