Excel to JSON
Work with XML, YAML, spreadsheet data, and developer utilities locally in your browser.
Work with XML, YAML, spreadsheet data, and developer utilities locally in your browser.
Paste rows copied from a spreadsheet — the clipboard delivers them as comma- or tab-separated text. The converter splits the input on line breaks, then splits each line on its first comma or tab, and produces a JSON array where every row is an object with two fields, column1 and column2. There is no header-row detection: the first line is treated as data like any other, and only the first two values on each line are captured.
Best for turning a two-column lookup table — code to label, key to value, term to definition — into JSON quickly, or scaffolding a small JSON fixture from a spreadsheet selection. For wider sheets, multi-column output, or a real .xlsx file, use JSON to Table (which flattens nested data and exports .xlsx) or the CSV to JSON converter after saving the sheet as CSV.
Input:
US,United States
GB,United Kingdom
JP,JapanOutput:
[
{ "column1": "US", "column2": "United States" },
{ "column1": "GB", "column2": "United Kingdom" },
{ "column1": "JP", "column2": "Japan" }
]No. This mode keeps only the first two values on each line as column1 and column2. For full-width conversion, save the sheet as CSV and use the CSV to JSON converter.
No. Every line, including the first, is treated as data. The keys are always column1 and column2.
No. Copy the cells and paste them as text; the tool reads tab- or comma-separated content, not the binary workbook.
No. Conversion runs entirely in your browser and the data never leaves the page.