Convert an Excel sheet to JSON: an array of objects keyed by the header row, or an array of arrays. Typed numbers and dates, pretty or minified, one sheet or all of them.
Works in your browser. What you paste or upload is processed on your device.
Pick your Excel or ODS file. Its sheets are listed with row counts.
Select a sheet (or All sheets) and choose array of objects or array of arrays.
Choose typed values or text as shown, null for empty cells, and pretty or minified output.
Press Convert to JSON, then copy it or download the .json file.
Developers, no-code tools and APIs want data as JSON, while the people who maintain it keep it in Excel. This converter turns a sheet into JSON in your browser. By default it uses the first row as keys and gives one object per row ([{"name": "Asha", "city": "Pune"}, …]); switch to array of arrays to get every row as a plain list, header included.
Values are typed: numbers stay numbers, TRUE and FALSE become booleans and dates are written as 2026-11-03 (with the time when there is one), so the output is ready for code. Choose Text as shown to get exactly what Excel displays instead. Empty cells can be written as null, so every object has every key, or left out. Pick one sheet, or All sheets to get one JSON object with a key per sheet. Output is pretty-printed with two-space indents or minified.
Limits: the first row must hold the column names for the array-of-objects shape; duplicate names get a suffix (_1) and empty names become __EMPTY. Merged cells give their value to the first cell only. Formulas are exported as the value Excel last saved. Nested JSON is not built from dotted column names.
Hand-converting a spreadsheet to JSON is slow and error-prone, and generic converters often stringify every number or shift dates by a time zone. Getting typed values, readable dates and a preview of the header row in one step means the JSON can go straight into a seed file, an API request or a CMS import, without the spreadsheet leaving your machine.
Something else? Ask the team
With Array of objects, the first row of the sheet supplies the keys and every row below it becomes one object. The preview shows that header row so you can check it before converting. If your data starts lower down, delete the rows above the header in Excel first.
Excel stores dates as serial numbers, which are meaningless outside Excel. The converter writes them as 2026-11-03, or 2026-11-03T14:30:00 when the cell has a time, using the date Excel shows rather than shifting it to UTC.
Yes. Choose All sheets and you get one JSON object whose keys are the sheet names and whose values are each sheet's rows.
No. The workbook is read and the JSON is generated in your browser. Our server only counts the run; it never sees the file or the JSON.
With "Keep empty cells as null" on, every object has every key and empty cells are null. Turn it off to leave empty cells out of each object, which gives smaller JSON.
Yes. Pick the workbook from Files or Downloads; you can copy the JSON to the clipboard or save the .json file.
You get one free run of this tool per day, with no account. After that, each run costs 5 credits from a free AI Rank Lab account (1 credit = 1 US cent). One run is one press of the convert button.
Each one opens on its own page and works straight away, with no sign-up.
Convert a JSON array to an XLSX sheet
Convert DOCX to clean HTML
Convert vCard contacts to CSV
Convert a CSV contact list to vCard
Explore more free tools:Schema GeneratorMeta Tag GeneratorLLMs.txt GeneratorBrowse all free tools
Excel to JSON Converter is one piece of the puzzle. See how ChatGPT, Gemini, Perplexity, and Google AI Overviews actually view your brand, and get a prioritised list of fixes, with a free AEO & GEO audit from AI Rank Lab.
Run a free AEO & GEO audit or View pricing.
Site audit
Paste your site. The free audit scores it for SEO, answer engines and generative engines, with the fixes.
