Skip to main content
Free File Converter

XLSX to JSON converter

Turn a worksheet into an array of JSON objects, with control over blank cells.

Processed in your browser. This file is converted on your device and is never uploaded.

Converter

.xlsx up to 25 MB. You can also drag a file here.

Options

Choose a workbook to list its worksheets.

When off, columns are named column1, column2, and so on.
Excel stores dates as numbers, so the output format has to be chosen. No timezone is applied, because a spreadsheet date is a calendar day rather than an instant.
Turn off for a smaller single-line file.

No file selected.

About this tool

Turning a spreadsheet into JSON is usually the first step in feeding a workbook into an API, a script, or a database. This tool opens an .xlsx workbook in your browser and writes a chosen worksheet as an array of JSON objects, one per row.

Because blank cells and dates are exactly where spreadsheet exports usually go wrong, both are yours to decide rather than being guessed at.

Supported formats and limits

Input
.xlsx
Output
.json (application/json)
Output name
The workbook name with the worksheet name appended, for example budget.xlsx becomes budget-Q1.json. Exporting every worksheet produces budget-sheets.zip.
File size limit
25 MB
Processing
In your browser. The file is not uploaded.

How to use it

  1. Choose an .xlsx workbook. Its worksheets are listed as soon as it is read.
  2. Pick a worksheet, or choose to export all of them.
  3. Say whether the first row holds column names, and choose how blank cells and dates should be written.
  4. Select Convert, then download the .json file or the .zip archive.

Limitations

  • Every value is written as a string, except blank cells when you ask for null. Numbers are not converted to JSON numbers, because doing so silently damages values such as postcodes, long account numbers, and version strings.
  • Formulas are not recalculated; the value saved with the workbook is used.
  • Formatting, merged cells, charts, images, and comments are not represented.
  • Duplicate column names collapse, and the last column with a given name wins.
  • Only .xlsx is supported. Older .xls and macro-enabled .xlsm files are rejected.
  • Password-protected workbooks cannot be opened.

Frequently asked questions

Is my workbook uploaded?
No. The workbook is opened and converted entirely in your browser. It never leaves your device and no request carrying its contents is made.
Which empty-cell setting should I use?
Use null when the consumer distinguishes a missing value from an empty one, leave the property out when it expects optional fields, and use an empty string when it expects every key to be present as text.
Why are my numbers quoted?
Cell values are written as text so nothing is lost in translation. A number that has to be a JSON number is a small transformation after conversion, whereas a corrupted account number cannot be recovered.
Can I convert every worksheet at once?
Yes. Choose all worksheets and the download is a ZIP archive with one JSON file per sheet, named after the sheet.

Related tools