Excel to JSON Converter

Upload an Excel workbook and get a JSON array of objects back — one object per row, header row as keys, numbers preserved as real numbers. XLSX and XLS both work, multi-sheet workbooks included. Free, no signup needed.

Drop a file here or browse

Accepts XLSX,XLS files

Free — 3 requests/day, no signup. for 300 credits/month free.

How it works

Upload your workbook

Drop an .xlsx or .xls file above — every sheet with data is included.

Rows become objects

The header row of each sheet becomes the keys; each data row becomes one JSON object. Numbers stay numeric.

Copy your JSON

Copy the array into your code or config — or automate workbooks-to-JSON with one POST request.

Key features

What makes this excel to json stand out.

Real types, not strings

Numbers and booleans come through as JSON numbers and booleans — no quoting every cell and parsing again later.

Multi-sheet workbooks

All sheets convert in one pass; with multiple sheets each object is tagged with its sheet name in a _sheet field.

XLSX and legacy XLS

Modern and old Excel formats both convert through the same tool and endpoint.

Formula results, not formulas

Cells with formulas export their computed values — the JSON contains what you see in Excel, not =SUM(A1:A9).

Empty cells handled

Blank cells become null instead of vanishing, so every object keeps a consistent shape.

Batch API conversion

Convert a folder of workbooks with a short script — one POST per file with output_format=json. See the Python example.

Use cases

Common scenarios where this tool saves you time.

Business data into apps

The spreadsheet your ops team maintains becomes the JSON your application actually consumes.

Config and content from Excel

Let non-developers own pricing tables, product lists, and translations in Excel; convert to JSON at build time.

Database imports

Feed MongoDB, Firestore, or a REST API with row objects converted straight from the workbook.

Data analysis handoff

Move analyst-prepared Excel data into scripts and notebooks without csv-export detours.

Automate with the API

Use the same tool programmatically. Works with any language — just HTTP.

cURL

# Convert an Excel workbook to a JSON array
curl -X POST "https://api.parsejet.com/v1/parse/auto/file?output_format=json" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -F "[email protected]"

Python

import httpx, json

resp = httpx.post(
    "https://api.parsejet.com/v1/parse/auto/file",
    params={"output_format": "json"},
    headers={"Authorization": "Bearer YOUR_API_KEY"},
    files={"file": open("report.xlsx", "rb")},
)
rows = json.loads(resp.json()["text"])  # list of dicts
print(rows[0])

JavaScript

const formData = new FormData();
formData.append("file", xlsxFile); // .xlsx or .xls

const res = await fetch(
  "https://api.parsejet.com/v1/parse/auto/file?output_format=json",
  {
    method: "POST",
    headers: { Authorization: "Bearer YOUR_API_KEY" },
    body: formData,
  }
);
const rows = JSON.parse((await res.json()).text); // array of objects

Want to automate this?

ParseJet API gives you the same parsing power via a single HTTP endpoint. No ffmpeg, no poppler, no tesseract — just one API call.

curl -X POST https://api.parsejet.com/v1/parse/auto/url \
  -H "Content-Type: application/json" \
  -d '{"url":"https://example.com"}'

Read API Docs

Frequently asked questions

How do I convert an Excel file to JSON?

Upload the .xlsx or .xls file above — ParseJet returns a JSON array with one object per row, using the header row as keys. For automation, POST to /v1/parse/auto/file with output_format=json.

Do numbers stay numbers?

Yes — numeric cells export as JSON numbers and booleans as true/false, so you don’t have to re-parse quoted strings downstream.

How are multiple sheets handled?

Every sheet with data is converted. When a workbook has more than one sheet, each row object includes a _sheet field naming the sheet it came from.

What happens to formulas?

You get the computed values, not the formula text — the JSON matches what the spreadsheet displays.

Can I convert JSON back to Excel here?

No — this tool converts in one direction, Excel into JSON. ParseJet parses documents into structured text and data; it does not generate spreadsheet files.

Is it free?

Yes. You get 3 free conversions per day with no signup, and a free API account includes 300 credits per month. Paid plans start at $19/month.

Start extracting text for free

No signup required. Parse your first file in seconds.

View Pricing