JSON to Excel Converter

Turn a JSON file into a spreadsheet you can actually sort

JSON is great for machines and painful for people. Open an API response or a database export in a text editor and you're staring at a wall of brackets. This converter reads that JSON and writes it into an XLSX workbook, where the same data sits in rows and columns you can sort, filter, and drop a formula on. You can upload a .json file or paste the text straight into the box, and the result downloads a second or two later.

Everything runs in your browser. The page loads the SheetJS library once, parses your JSON with the browser's own reader, builds the workbook in memory, and hands you a file to download. Your data never touches a server, which is the main reason this tool is fast and the main reason it stays private.

How it decides what goes on each sheet

The converter looks at the top level of your JSON and picks a layout from there. An array of objects is the clean case: each object becomes a row, each key becomes a column, and the header row is built from every key it finds. If one object has a field the others skip, that column still appears, just empty where the value is missing.

When the top level is an object holding several sections, and at least one section is an array or another object, you get a multi-sheet workbook. Each top-level key becomes its own tab. A file with keys like sales, inventory, and customers, each holding an array, comes back as three sheets named for those keys. That's the feature most people come here for, and it's why a workbook beats a flat CSV when your data holds more than one table.

There's a third case worth knowing. A single flat object, say one with a name key and a role key and nothing nested inside, has no sections to split. Instead of one row with two columns, it comes back as a two-column Key/Value list, one row per field. If you wanted name and role as column headers, wrap the object in an array by putting square brackets around it, so it becomes a list of one object. That single change flips it into the row-and-column layout.

Where it struggles, honestly

The big limitation is nesting. This converter does not flatten deeply nested objects into dot-notation columns. If a row has an address field that is itself an object with city and zip inside, you won't get separate address.city and address.zip columns; the nested piece stays bundled together instead of spreading across the sheet. So when you need every leaf value in its own cell, flatten the JSON before you bring it here.

A few smaller things to keep in mind:

• The file has to be valid JSON. Upload mode rejects a broken file with the parser's own error message, and paste mode flags a red warning the moment the text stops parsing, so a stray trailing comma catches you before you convert.
• A top-level value that isn't an object or an array, like a bare number or a single quoted string, has nothing to put in a table, so the converter stops with an "Unsupported JSON structure" message.
• Column order follows the order the keys appear in your JSON, not alphabetical order. If you need columns in a particular sequence, arrange the keys that way in the source.

Sheet names and the file you get back

Excel is fussy about worksheet names, so the converter cleans them up for you. Each tab name is trimmed to 31 characters, which is Excel's hard limit, and any character Excel forbids in a sheet name, the colon, backslash, forward slash, question mark, asterisk, and square brackets, gets swapped for an underscore. A section named something like Q1/Sales lands on a tab called Q1_Sales. Single-sheet conversions always use one tab named Data.

The download is named after its source. Convert products.json and you get back products-thefreeconverter.com.xlsx. Paste JSON instead of uploading, and there's no original name to borrow, so it saves as converted-data-thefreeconverter.com.xlsx. Rename it to whatever your project needs once it's on your disk.

A real example

Say you pulled a report off a REST API and it came back as one object with three arrays inside: 240 orders, 58 products, and 112 customers. Paste that JSON into the box, hit convert, and you get a single .xlsx with three tabs, one per array, each with its own header row. From there you can build a pivot on the orders tab, look product names up across sheets, or chart the month's sales. The conversion itself is basically instant. The spreadsheet work afterward is what eats real time.

Upload a file or paste the text

Two input modes sit at the top of the tool. Upload takes a .json file by drag-and-drop or the file picker. Paste takes JSON text directly, whether you type it, paste it, or pull it in with the Paste from Clipboard button, and it validates as you go with a green check or a red error. Paste is the quicker route when your JSON is already open in an API console or a code editor and you don't want to save a file just to convert it. Either way the output is identical.

Works with any spreadsheet app

The file is a standard XLSX, the Office Open XML format Excel has used since 2007, so it opens in Microsoft Excel, Google Sheets, LibreOffice Calc, and Apple Numbers with no extra conversion step. Formulas, sorting, filters, and pivot tables all work once the data is in.

When the spreadsheet is finished and needs to go out as a fixed, printable report, the Excel to PDF converter locks it into a shareable file.

When a different tool fits better

Need to go the other direction? You can turn an Excel file back into JSON to rebuild JSON from an existing XLSX file.

Only need a flat table, not a multi-tab workbook? You can convert the JSON to CSV instead and get a single comma-separated file that opens in just about anything.

One last note on privacy: because the conversion happens in your browser, your JSON is never uploaded, stored, or logged. The only thing that leaves the page is an anonymous note that the tool was used, with no file contents attached. Close the tab and nothing lingers.