CleanCSV

Convert Excel to JSON

Turn any sheet of an Excel workbook into a JSON array of objects, with header names as keys and sensible types, without uploading the file.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

Excel to JSON converter

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop an .xlsx, .xls or .ods workbook into the tool above.

  2. 2

    Pick the sheet to convert, or Combine all to merge every sheet into one array with a Source field.

  3. 3

    Optionally rename columns to the keys you want; snake_case is one click in the Columns section.

  4. 4

    JSON is already selected as the download format. Click Download JSON.

Dates and numbers come through correctly

Dates stored as Excel dates become YYYY-MM-DD strings instead of serial numbers like 45296, and numbers are written in full precision rather than as Excel displays them. Formatted values such as zip codes keep their leading zeros.

Types without surprises

A column becomes JSON numbers only when every value in it is a plain number, and booleans only when every value is true or false; empty cells in those columns become null. Everything else stays a string, so codes like 007 are never mangled.

Title rows and messy sheets

Header rows below a title or blank lines are detected automatically, and you can pick the header row yourself from the Header row menu. Empty sheets are skipped.

Frequently asked questions

Can I convert every sheet at once?

Choose Combine all to put every sheet into one array, or select each sheet in turn to download separate files.

Are formulas converted?

JSON contains each formula's calculated value, not the formula itself.

Is the workbook uploaded?

No. The conversion runs in your browser and the file never leaves your device.