Skip to content

XLSX to JSON Converter

Convert a Microsoft Excel (.xlsx) file into JSON. Upload a spreadsheet, pick a sheet, and get an array of objects or a raw row-by-row array.

Category: data
Use Case: API Payloads, Data Import, Config Generation
Privacy: 100% browser-based

Click to upload an .xlsx file

Your file is processed entirely in your browser

Recommended Settings

Pro Tips

  • Array of Objects uses the first row as keys - best when your sheet has clean column headers
  • Array of Arrays preserves the raw grid, including the header row, which is useful for sheets without meaningful headers
  • Empty cells are converted to null so the JSON structure stays consistent across rows
  • If your workbook has multiple sheets, switch between them with the Sheet selector - each one converts independently
  • The whole file is read and converted locally in your browser - nothing is uploaded anywhere

Most Popular

Most users convert the first sheet as an Array of Objects for use in scripts or APIs

When to Use This Tool

API Payloads

Convert spreadsheet data into JSON to seed a mock API response or send as a request body to an endpoint that expects JSON.

Data Import

Turn an Excel export into JSON for import into a NoSQL database, JavaScript application, or Node.js script.

Config Generation

Maintain configuration data in a spreadsheet for non-technical editors, then export it as JSON for your application to consume.

Testing & Fixtures

Generate JSON test fixtures from a spreadsheet of sample data instead of hand-writing JSON objects.

How It Works

1

Read the uploaded .xlsx file as binary data directly in your browser

2

Parse the file into a workbook using the SheetJS library, extracting all sheet names

3

Convert the selected sheet into either an array of objects (keyed by header row) or an array of raw rows

4

Format the result as indented, readable JSON

5

Display the resulting JSON, ready to copy or download

100% Private

Files never leave your device. All processing happens locally in your browser.

Lightning Fast

Powered by SheetJS (xlsx) for optimal performance on modern browsers.

Secure

No data collection, no tracking, no sign-up required.

Frequently Asked Questions

What's the difference between the two JSON shapes?

Array of Objects treats the first row as field names and produces one object per row, like {"Name":"John"}. Array of Arrays keeps every row, including the header, as a plain array of values.

Can I convert a workbook with multiple sheets?

Yes. After uploading, use the Sheet selector to choose which sheet to convert. Each sheet is converted independently.

What happens to empty cells?

Empty cells are converted to null in the JSON output, rather than being omitted, so every row keeps the same shape.

Is my spreadsheet uploaded to a server?

No. The entire file is read and converted locally in your browser using the SheetJS library. Your data never leaves your device.

What happens to formulas in my spreadsheet?

Formulas are converted using their last calculated value, not the formula text itself, since JSON has no concept of spreadsheet formulas.