Skip to content
OneKitly
Sign up · Sign in

Excel to JSON

Turn a spreadsheet into a JSON array of objects, one per row, using the header row as keys.

10 / 10 free files today

Related tools

All Spreadsheets tools →
CSV to ExcelConvert a CSV file (or pasted CSV) into a real .xlsx spreadsheet.Excel to CSVConvert an .xlsx or .xls sheet to CSV, pick which sheet.Merge Excel filesCombine several workbooks into one, keeping every sheet and renaming on collision.Split an Excel fileBreak a workbook into one .xlsx file per sheet, downloaded separately.Excel to HTML tableConvert a sheet into an HTML table you can paste straight into a page.Excel to TSVExport a sheet as tab-separated values, the safe choice when your data contains commas.Excel to XMLExport a sheet as well-formed XML, with the header row naming each element.ICS to JSONExport calendar events as JSON, with each ICS timestamp converted to ISO-8601.

Open Excel to JSON and you get an answer straight away, with no account to create. Its place is under Spreadsheets; CSV to Excel and Excel to CSV answer the questions closest to this one.

How to use it

  1. Open the tool — no signup or install needed.
  2. Enter your input or adjust the available options.
  3. Get your result instantly, then copy or download it.

Frequently asked questions

What is Excel to JSON?

Turn a spreadsheet into a JSON array of objects, one per row, using the header row as keys.

When would I actually use this?

Getting a table out of a workbook and into something else — JSON for an API, CSV for an import, HTML for a page — opening a file whose software you do not have, and cleaning a sheet before you hand it on.

What is the most common mistake?

Expecting the formula to survive the trip. A converted file carries the last value the spreadsheet computed, not the calculation behind it — and a workbook written by a program can carry the formula with no cached value at all, which most readers discard along with the cell.

How is Excel to JSON different from CSV to Excel?

They sit next to each other but answer different questions. CSV to Excel: convert a CSV file (or pasted CSV) into a real .xlsx spreadsheet. Pick whichever matches what you're starting from — both are free.

Is there a tool for the next step?

Excel to CSV is the closest one after this: Convert an .xlsx or .xls sheet to CSV, pick which sheet.

What else is worth having open alongside it?

Merge Excel files and Split an Excel file — they come up in the same task often enough to be worth a second tab.

Where do the figures come from?

Nothing leaves the browser. An .xlsx and an .ods are both zipped XML, read here against their published specifications. Dates are the fragile part — a spreadsheet date is a number counted from an epoch the workbook itself declares, so the same 45000 is two different days depending on a flag most files never show you.

Further reading

All guides →
ComparisonA Column Called "Total (EUR)" Cannot Be an XML Element NameJSON takes your header text as a key exactly as written. XML cannot — its names may not hold spaces, parentheses or a leading digit — so they are normalised, and knowing how prevents a surprise downstream.ExplainerThe .ods File That Is Valid, and That Your Reader RefusesOpenDocument makes styles.xml optional. Several readers demand it and reject the whole document without it — "Cannot find file styles.xml in zip" on a file that is not broken.ExplainerConverting Formulas to Values Keeps the Cached Answer, Not the CalculationA spreadsheet file stores both the formula and the last answer Excel computed. Stripping the formula leaves the stored answer — and leaves a blank wherever the file never carried one.ExplainerWhy Your CSV Breaks Accents and Dates in ExcelThree completely different faults hide behind the same sentence. One is the encoding, one is the separator, one is Excel guessing at types while it opens the file — and the fix for each is different. Here is how to tell them apart in five seconds.How-toOne File per Tab, and What a Split Leaves BehindSplitting a workbook writes one .xlsx per sheet, named after the tab. It carries the values across and not the formulas — which is the right default when the point is to send one department its own tab.How-toMerging Workbooks: One Sheet Each, or One Table for AllTwelve monthly reports can become twelve tabs or one table of twelve months. Only the second can be sorted and summed in one go — and it is the one where the header rows need handling.