We use cookies.This website uses essential cookies to operate core features. With your consent, we also use analytics cookies to understand traffic and improve the service. For more details, see our .
We use cookies.This website uses essential cookies to operate core features. With your consent, we also use analytics cookies to understand traffic and improve the service. For more details, see our .
Was this tool helpful to use?
Your feedback helps us make it better
Convert copied Excel cells into row-based JSON objects or arrays
Supports tab-delimited data pasted from Excel and CSV. If the first row contains column headers, select “Rows as Objects.”
Paste your table data and select Convert to JSON to view the output here.
Overview
Understand what the tool solves, how it works, and the boundaries of its data.
Paste tab-delimited cells copied from a spreadsheet, or comma-delimited text, into the input area. This converter works from the pasted text; it does not open an .xlsx workbook. That means formulas, formatting, pictures, comments, multiple sheets, and workbook structure are not carried into the output. The input is parsed as rows and columns, then serialized as JSON text.
Rows as Objects uses the first input row as field names and each later row as a record. For example, headers “Item” and “Count” followed by “Notebook” and “3” become an object with named properties. Rows as Arrays keeps each row as an ordered list of values, including the first row. JSON objects store name/value pairs, while JSON arrays keep values in order; choose the shape expected by the program or service that will receive the result.
The converter infers a few basic value types: case-insensitive true and false become Boolean values, null becomes JSON null, and number-looking text becomes a number unless it appears to be a leading-zero integer such as 0012. Other non-empty cell contents remain strings; empty cells become empty strings. This convenience can change how a receiving system reads a cell, so inspect important fields after conversion.
Guide
Follow the workflow and verify inputs and outputs with practical examples.
In your spreadsheet, select the cells to convert. Include the header row if you plan to use Rows as Objects. Copy the range so rows and columns are represented in the clipboard text.
Paste the text into the table area. The page detects tabs or commas as the delimiter. It does not upload or parse the original spreadsheet file because the input is text.
Choose Rows as Objects for header-based records; it requires at least a header row and one data row. Choose Rows as Arrays when you want every row preserved by column position.
Convert the table, then review the output and its row and column summary. Copy the JSON or download the generated file once the structure and values look right.
For example, an object row can look like {"Item":"Notebook","Count":3}. In array mode the same cells are represented in order, such as ["Item","Count"] and ["Notebook",3]. A blank header is filled with a generated column label, while duplicate header names receive numeric suffixes. For a stable data format, it is usually clearer to make spreadsheet headers unique before copying.
Use cases
See how the tool fits into real work and everyday tasks.
Copy a few representative spreadsheet rows into object mode to prepare named records for a script or test request. Confirm that the target expects the same field names and value types.
Use array mode when the next step expects ordered rows rather than named records. The first row stays in the output, so remove it only if your receiving format calls for that.
For IDs such as 0012, keep the source value as text in the spreadsheet before copying. If the spreadsheet has already converted it to the number 12, the converter cannot restore the lost zeros. Likewise, review dates, long numbers, and currency values against the exact text copied from the sheet.
Q&A
Find concise answers to common questions and confusing cases.
No. Paste copied cell text instead. The converter receives rows and columns as text, not workbook sheets, formulas, styles, or embedded content.
The first row supplies field names and at least one following row supplies a record. With only one row, choose array mode if you want to convert it as data.
The converter recognizes text that looks like a number, true, false, or null and serializes it as that JSON type. Review the output if one of those words is meant to stay ordinary text.
Empty cells become empty strings. Rows are padded to the widest parsed row when output is built, so check the row and column summary and inspect any irregular lines.
Notes
Review scope, result limitations, and important precautions before use.
Conversion success only means the pasted text could be structured; it does not confirm that the source table is complete or that a receiving application expects the same schema. Review a representative row, repeated or blank headers, quoted commas, leading zeros, dates, and long identifiers before importing.
A downloaded JSON file contains the converted text, not the original workbook or its formulas and formatting. For personal or sensitive information, follow your organization’s data-handling rules before pasting it into any website.
Related
Discover related tools, collections, and available API capabilities.