Excel to JSON Converter Online

When to Use This Tool

Suppose you have a 100-row Excel spreadsheet containing names, departments, and employee IDs. Copy the cells and convert them into JSON that applications can easily read. This tool is ideal when your data is already organized in Excel and you need to use it on a website, in a script, through an API, or in a configuration file.

Common use cases include creators converting editorial calendars into data for a content management system, office teams handing product lists, contacts, or inventory records to developers, and students turning experiment results into arrays for web projects or data exercises. This tool processes cell text copied from Excel; it does not upload or parse an entire .xlsx file.

JSON is a text-based data format. Objects use field names to describe each value, while arrays store values by position. You can convert each row into an object or an array, depending on the format required by the destination system.

How to Use It

1. Select the contiguous range of cells you want to convert in Excel. If you choose “Rows to Objects,” include the header row.
2. Copy the cells, click the large input box at the top of the page, and paste the content. Columns copied from Excel are usually separated by tabs, while rows are separated by line breaks.
3. Select “Rows to Objects” or “Rows to Arrays.” If you are unsure, start with “Rows to Objects” because named fields make the output easier to understand.
4. Click “Convert,” then review the JSON in the output box. Check the field names, row count, quotation marks, and empty values.
5. To see the expected input format, click “Load Demo.” To process another dataset, click “Clear” and paste the new cells.

For example, choose “Rows to Objects” when sending a contact list to a system that reads named fields. Choose “Rows to Arrays” when you only need to preserve the spreadsheet's two-dimensional structure. This page does not provide a file upload option, so copy and paste cells from Excel instead of dragging a file into the input box.

Worked Example

Assume your Excel sheet contains three columns and three rows:

Name	Department	Employee ID
Li Mei	Editorial	0012
Wang Qiang	Operations	0013

First, select and copy every cell from “Name” through “0013” in Excel. Next, paste the content into the input box at the top of the page. Select “Rows to Objects,” then click “Convert.” The output should resemble this structure:

[
  {"Name":"Li Mei","Department":"Editorial","Employee ID":"0012"},
  {"Name":"Wang Qiang","Department":"Operations","Employee ID":"0013"}
]

The first row defines the field names, and each subsequent row becomes an object. The values in Li Mei's row map to “Name,” “Department,” and “Employee ID.” Both records are then placed in one array. The result contains two objects, matching the two data rows below the header.

Pay close attention to identifiers such as 0012. If Excel or the converter treats the value as the number 12, the leading zeros may be removed. Postal codes, ID numbers, SKUs, and other codes that are not used in calculations should be formatted as text in Excel before you copy them.

More Examples and How to Read the Output

Example 1: Convert rows to arrays. Paste the same data but select “Rows to Arrays.” Each row becomes an array whose values follow the original column order:

[["Name","Department","Employee ID"],["Li Mei","Editorial","0012"],["Wang Qiang","Operations","0013"]]

This format preserves the spreadsheet's two-dimensional structure, but the meaning of “Li Mei” depends on the first row and its column position. Use arrays when the receiving system requires a two-dimensional array. If you need to retrieve a value directly by a field such as “Department,” objects are usually clearer.

Example 2: Empty cells. If Wang Qiang's department is blank, the input row may contain “Wang Qiang,” an empty column, and “0013.” After conversion, check whether that position becomes an empty string, null, an omitted value, or a shifted column. Use the actual output on this page as your reference rather than relying only on how the spreadsheet looks.

Common Mistakes and Important Notes

• Pasting or dragging an Excel file onto the page: This tool reads copied cell content and does not include an .xlsx file upload control.
• Omitting the header row in object mode: The first row normally supplies the field names. Without headers, the fields may be interpreted incorrectly, so include the header row in your selection.
• Using merged cells: Copied merged ranges may not preserve the row-and-column layout you see in Excel. Unmerge the cells first and ensure every row has the same number of columns.
• Ignoring line breaks inside cells: Line breaks, tabs, or double quotation marks in notes may affect row detection and escaping. After conversion, spot-check records containing special characters.
• Assuming displayed values are raw values: Dates, long numbers, scientific notation, and formula results are affected by Excel formatting. The converter can only process the text pasted into the input box. It cannot recover uncopied formatting, formulas, or workbook relationships.

This tool works best with small, consistently structured two-dimensional tables. It is not designed to preserve formulas, images, comments, colors, multiple worksheets, or merged-cell relationships. Conversion accuracy depends on the clipboard text received by the browser, the current display format in Excel, and the consistency of the source table. Very large datasets may also be limited by browser memory and page performance. Before processing sensitive information such as government ID numbers, customer lists, or financial records, verify the security of your device, network, and the site's data-handling practices. Use an approved local solution when necessary. Test the output in the destination system or validate it with a JSON validator; seeing the result on this page does not guarantee a successful API import.

Frequently Asked Questions

Does the first row have to contain headers?
For “Rows to Objects,” the first row should contain unique, meaningful field names such as “Name” and “Department.” For “Rows to Arrays,” the first row can be retained as a regular array. Whether headers are needed depends on the receiving system.

Why is a column missing after conversion?
A trailing empty cell may not have been fully copied to the clipboard, or the source range may contain merged cells. Try temporarily filling empty columns with a clear placeholder, copy the range again, and review the output box.

Why did a date become a number or change format?
Excel may store dates as serial numbers, while copied content is also affected by the cell's display format. First format dates consistently—for example, as 2026-07-17—then paste and convert the data. Check whether the output values are enclosed in quotation marks.

Should I use object mode or array mode?
Choose “Rows to Objects” when an API expects named fields or your code needs to access values by name. Choose “Rows to Arrays” when you only need to preserve the original row-and-column order or the receiving system explicitly requires a two-dimensional array.

Can I convert multiple worksheets or formulas?
The page converts only the cell text currently pasted into it; it does not read the full workbook structure. Copy each worksheet separately. Formulas generally produce the displayed values supplied by Excel, not the underlying formula logic.

Can I send the output directly to an application?
Test a small sample in the destination application first. Pay particular attention to the data types of numbers, booleans, null values, dates, and special characters. Start by pasting three to five representative rows into the tool above. Once the structure is correct, process the complete dataset.