You do not need to know the format
A .json file is a structured way for websites and apps to share information. This tool translates that structure into the familiar table layout used by spreadsheets.
JSON file to spreadsheet
Got a JSON file but just want a normal spreadsheet?
Drop the file below and we will arrange its information into rows and columns. Preview the result and download it for Excel, Google Sheets or another spreadsheet app.
Check everything before download
The preview shows sample rows and every detected column. Untick details you do not need before creating the final file.
- Names become column headings
- Items become rows
- Nested details remain selectable
Use it in your spreadsheet app
The downloaded CSV opens in Excel and can be imported into Google Sheets, Apple Numbers and most other spreadsheet programs.
Common questions
What is a JSON file?
It is a text file used by websites and software to store organised information. It can contain lists, labels and nested groups that are not immediately readable as a spreadsheet.
What is the downloaded CSV file?
CSV is a simple table file. Spreadsheet apps use it to display data as rows and columns, although it does not contain workbook styling, formulas or multiple sheets.
Which spreadsheet apps can open the result?
Microsoft Excel, Google Sheets, Apple Numbers, LibreOffice Calc and many other spreadsheet tools can open or import CSV files.