Excel to JSON Converter
Select a sheet from an Excel file and save it as JSON.
Excel files are read and converted to JSON entirely in your browser. Dates, currency, percentages, and other formatted cells are converted as shown in Excel.
About This Tool
The Excel to JSON tool converts Excel files (.xlsx) into JSON by letting you pick a sheet from the workbook. Data can be transformed into an Object Array, a 2D Array, or a Keyed Object based on the first column, with configurable indentation and empty-row handling. Ideal for preparing Excel data as JSON for web development, API testing, configuration files, and data processing.
How to Use
Select an Excel file
Upload the .xlsx file you want to convert to JSON. Once selected, you can see the file name, size, and total sheet count.
Choose a sheet and options
Pick the sheet to convert, then set the output format (Object Array, 2D Array, or Keyed Object), indentation style, and empty-row handling.
Review and save the result
Inspect the generated JSON structure and values in the preview panel with line numbers, then copy it to the clipboard or download it as a JSON file.
Key Features
Sheet selection
Select a specific sheet from a multi-sheet Excel file and convert it to JSON.
Three output formats
Choose between Object Array, 2D Array, or Keyed Object structure based on your data needs.
Flexible indentation
Pick 2 spaces, 4 spaces, tab, or none to balance readability and file size for the generated JSON.
Empty row handling
Exclude rows where every cell is empty, or keep them in their original positions in the output.
Preview, copy, and download
Review the JSON with line numbers, copy it to the clipboard, or download it as a .json file.
In-browser processing
Your Excel file stays in your browser — nothing is sent to a server.
Use Cases
Preparing data for web development
Convert product, user, and configuration data managed in Excel into JSON for use in web applications.
Generating API test data
Quickly turn Excel sheets into arrays of objects for request bodies and test fixtures.
Building ID-based data structures
Transform tables with codes or identifiers in the first column into keyed objects for fast lookups.
Preserving the original cell structure
Use array-of-arrays format to keep row and column order for data where cell position matters more than column names.
Writing config files and seed data
Convert options, localized strings, and reference values organized in Excel into JSON config files or initial data.
Frequently Asked Questions
How do the output formats differ?
Object Array uses the first row as property names and converts each following row into an object. 2D Array keeps every row, including the first, as arrays of values. Keyed Object uses the first column value of each data row as the top-level object key, with the remaining columns stored as properties under that key.
How is the first row handled?
In Object Array and Keyed Object formats, the first row becomes the JSON property names. In 2D Array, the first row is treated as a regular data row.
What are the indentation options?
You can choose 2 spaces, 4 spaces, tab, or none. The space and tab options indent the structure for readability; none removes extra whitespace and line breaks for a compact output.
What is the difference between excluding and keeping empty rows?
Excluding removes rows where every cell is empty from the JSON output. Keeping preserves empty rows in their original positions.
What happens if a header cell is empty?
Empty column names are replaced with auto-generated names based on the column position, such as column_4, column_5, and so on.
Which values become keys in keyed-object mode?
The first column value of each data row becomes the top-level JSON object key, and the remaining columns are stored as properties under that key.
What if the first column has duplicate values?
A JSON object cannot hold duplicate keys, so repeated values get a numeric suffix such as _2, _3 to keep them distinct. It is best to use unique values in the first column when using keyed-object mode.
Are numeric cells stored as JSON numbers?
Currently, cells that look like numbers are still stored as strings in the output. You may need to convert values to numbers after conversion if you plan to use them in calculations.
Are Excel formatting or formulas preserved?
No. JSON stores the displayed cell values, so formatting such as fonts, colors, borders, and merged cells is not preserved.
Can I convert a password-protected Excel file?
No. Password-protected Excel files cannot be processed. Please unlock the file first before using this tool.
Is my Excel file sent to a server?
No. All processing happens locally in your browser. Your Excel file and conversion results are never transmitted to a server.
Related Tools
