Skip to content

Excel to JSON

Spreadsheet rows in, an array of JSON objects out.

Excel (XLSX) input

Drag & drop a spreadsheet

or click to browse. You can also paste.

Excel workbook (.xlsx), up to 50 MB.

JSON output

Output-

Processed on your device. Nothing is uploaded.

More converters

All tools

How to convert Excel to JSON

Three steps, all in your browser.

  1. 1

    Paste or open your data

    Drop a file or paste rows straight into the input box.

  2. 2

    Check the options

    Delimiter, header row, indentation: the output updates live.

  3. 3

    Download

    Save the converted file, or copy the output.

Excel to JSON: what to know

Excel is where much business data lives, and JSON is what code reads. This converter opens an .xlsx workbook in your browser and turns the sheet you pick into a JSON array, with no upload and no add-in.

The first row of the sheet is used as the header, and each row below it becomes an object with those names as keys. Empty or repeated header names are renamed so every key is unique. Numbers and booleans keep their types, while text stays text. Formula cells give the last result Excel saved, rich text becomes plain text, hyperlinks keep their display text and error cells keep codes such as #N/A. Dates become ISO 8601 strings, for example 2024-01-05 for a date and 2024-01-05T13:30:00 when there's a time, because JSON has no date type. Empty cells become empty strings and fully blank rows are skipped.

Turn the header option off to get each row as an array instead, which suits sheets without a header row. Old Excel 97-2003 .xls files and password-protected workbooks can't be read in the browser; re-save them as unprotected .xlsx files first.

Popular uses

  • Turning a product or price list into data for a website
  • Building app content, translations or config from a sheet
  • Preparing spreadsheet data for an API import
  • Creating test fixtures from a sample workbook

Tips for the best result

  • Pick the sheet from the list when your workbook has more than one.
  • Keep header names short and unique; they become your JSON keys.
  • Turn off typed values if you need every cell as a string.
  • Use 0 indentation for a compact file, or 2 or 4 to read it easily.

Read how JustYourConvert works and our privacy details. Keep your original files and check a converted file before you replace anything.

Frequently asked questions

The first row is read as the header, and every row below it becomes an object with those names as keys. Turn the header option off to get each row as an array instead. Empty rows are skipped and empty cells become empty strings.

As ISO 8601 text, which every programming language can parse: 2024-01-05 for a date and 2024-01-05T13:30:00 when the cell also has a time. Excel stores dates without a time zone, so none is added.

Not yet. Old Excel 97-2003 .xls files use a binary format that can't be read in the browser. Open the file in Excel, Google Sheets or LibreOffice, save it as .xlsx and convert that.

No. Every live tool on JustYourConvert opens and converts your files inside your browser, on your own device. Nothing is sent to our servers, and the result is saved straight from your browser.

Yes. Every tool is free, with no sign-up, no watermark and no daily limit. Clearly labeled ads keep it that way.

Only your device's memory. Because the work happens in your browser, very large files can be slow on phones and older computers. Each tool says its practical limit under the drop area.