Excel to JSON

Convert worksheets into clean JSON for APIs and apps.

Turn a spreadsheet into an array of objects keyed by your header row, ready to paste into a seed file, a fixture or an API request. Choose between arrays of objects, arrays of arrays, or a nested object keyed by a column of your choice.

Price
Free
Your files
Never uploaded
Runs
In your browser

or drag it here

.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded

Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.

Files stay on your device

What it does well

  • Real JSON types — numbers, booleans and ISO dates instead of strings
  • camelCase, snake_case or verbatim key naming
  • Minified or 2-space pretty output with syntax highlighting in the preview

How to use Excel to JSON

  1. 1

    Upload the workbook and pick the sheet to export.

  2. 2

    Select the header row so keys are named correctly.

  3. 3

    Choose the output shape: objects, arrays, or keyed by a column.

  4. 4

    Copy the JSON or download it as a .json file.

Watch a walkthrough

How to use Excel to JSON

2 min 18 s · captions included

Watch on YouTube

Common problems and fixes

Keys are named __EMPTY, __EMPTY_1 and so on.

The chosen header row has blank cells. Pick the correct header row number, or supply your own key names in the column editor.

Numbers come out as strings.

The source cells are text-formatted. Enable “Coerce numeric strings”, or clean the column first with the Number Formatter.

Frequently asked questions

More convert tools

Move data between XLSX, CSV, JSON, XML, HTML and PDF without losing formatting, encoding or number precision. Every conversion runs locally in your browser.

Browse Convert