How to Convert Excel to JSON

Stakeholders still send sample data as Excel. APIs and frontend fixtures want JSON — usually an array of objects, one per row, with column headers as keys. You do not need a one-off Node script for that conversion.

Two ways to do this (manual vs tool)

Manual path: export CSV from Excel, then write or paste a small script that maps rows to objects. It works, but fails when the sheet has merged headers, wrong sheet order, or encoding surprises — and it costs time every time the spreadsheet changes.

Tool path: open /tool/excel-to-json, upload the .xlsx or .xls, and download JSON. FileToolsHub converts the first worksheet into a JSON array of row objects. No install and no account for everyday conversions.

What the output looks like (array of row objects)

Header cells become object keys. Each following row becomes one object. Example shape: [{"name":"Ada","role":"Engineer"}, …]. That is the fixture shape most mock APIs and seed loaders expect. Pretty-print afterward with /tool/json-formatter if humans need to read it, or validate syntax with /tool/json-validator before shipping.

Common issues (merged cells, headers)

Put a single clean header row at the top of the sheet you care about. Avoid merged title cells above the table — they confuse key names. Move the target sheet to the first position in the workbook if the file has multiple tabs. Empty trailing columns can create blank keys; delete unused columns first.

Going the other direction? Rebuild a sheet from JSON with /tool/json-to-excel. More spreadsheet converters live on /spreadsheet.

Try the converter

Upload on /tool/excel-to-json, download the .json, then format or validate as needed. For API fixture workflows, see also /blog/excel-to-json-for-api-fixtures.