Developer Toolkit
Back to Tools

Excel to JSON Converter

Convert Excel or CSV to JSON with multi-sheet support, field picking, and type fidelity

Last updated
My tools
No tools yet

Loading...

How to convert Excel to JSON

  1. 1

    Upload or paste your table

    Choose an .xlsx file, or paste a selection copied from Excel or WPS directly into the text box — the clipboard carries it as tab-separated text.

  2. 2

    Pick the sheet and fields

    Switch between worksheets or export them all at once, untick columns you do not need, and choose how empty cells and dates should be written.

  3. 3

    Copy or download the JSON

    The JSON updates as you go. Toggle pretty printing, then copy it or download a .json file.

Features Overview

Convert Excel spreadsheets to JSON in your browser. Upload an .xlsx file or paste a table copied straight from Excel or WPS. The first row becomes the keys and every data row becomes an object; numbers, booleans, and dates keep their types, and long order IDs keep every digit. Files never leave your device.

Tool Description

Free online Excel to JSON converter. Upload an .xlsx file or paste a table copied from Excel or WPS. The first row becomes the keys, and you get an array of objects with multi-sheet support, column selection, empty-cell and date policies, and long IDs that keep every digit — all processed locally in your browser.

Capabilities Checklist

  • Upload .xlsx files, or paste a table copied directly from Excel or WPS.
  • The first row becomes the JSON keys; blank headers fall back to column_N and duplicates get a numeric suffix.
  • Reads every worksheet — export one sheet, or all of them at once as a sheet-name keyed object.
  • Tick only the columns you need so the output carries just the business fields.
  • Numbers and booleans keep their native types; dates can be ISO 8601, the Excel serial number, or the original text.
  • Integers of 16 digits or more stay strings, so order IDs and snowflake IDs do not end in zeros.
  • All parsing happens locally in the browser. Your spreadsheet is never uploaded.

Related Tools

JSON to Excel Converter

Convert complex JSON to editable XLSX with online preview, custom headers, and data mapping

JSON to CSV Converter

Batch convert, history tracking, support nested JSON structures

JSON Formatter Online

Format, validate, and explore JSON in your browser with a tree view, exact error lines, and JSONPath, with nothing uploaded

JSON YAML Converter

JSON and YAML format conversion, supports syntax highlighting and history tracking

Frequently Asked Questions

Which file formats does this tool accept?
It accepts .xlsx plus delimited text such as CSV and TSV. It does not accept .xls, the pre-2003 binary format, which is structurally unrelated to .xlsx — open it in Excel and save a copy as .xlsx first.
Is my spreadsheet uploaded to a server?
No. Unzipping, parsing, and JSON generation all happen locally in your browser, so the file never leaves your device. The tool keeps working with your network disconnected.
Can a row other than the first one be the header?
Yes. The header row is configurable: rows above it are ignored and rows below it become objects keyed by its field names. Blank headers fall back to column_N and repeated headers get a numeric suffix so keys never collide.
What happens to empty cells?
By default they become null. You can switch to an empty string, or omit the key entirely. Keeping null means the key still exists so downstream code does not hit undefined; omitting produces a more compact payload.
What format do date cells produce?
Excel stores dates as serial numbers internally. The default output is an ISO 8601 string, with date-only values written as a plain date. You can also keep the raw serial number or the original displayed text. Both built-in and custom date formats are recognised.
Do long order IDs lose precision?
No. Integers of 16 digits or more are kept as strings rather than numbers, so the trailing digits survive. Shorter numbers stay numeric and remain usable in calculations.
What do merged cells do to the output?
Merged cells push column headers out of alignment with their data, which makes the keys unstable. The tool flags a workbook that contains them; unmerge the cells in Excel before converting.
Which tool handles the opposite direction?
Use the JSON to Excel converter on this site. It flattens nested objects, offers three ways to export arrays, and can write nested arrays of objects to their own worksheets.