Turn JSON into a spreadsheet, or a spreadsheet into JSON
Paste JSON or drop in a file to see it as a table, then download it as CSV or Excel. It works the other way too: a CSV or Excel file comes out as JSON, one record per row. The file is opened by your browser and is never uploaded.
Drop a file here
CSV, tab-separated text, Excel (.xlsx or older .xls) or JSON. The kind of file is worked out from what is inside it, so a wrong file ending does not matter.
What it reads
- CSV split by commas, semicolons, tabs or pipes, found for you
- Excel .xlsx and older .xls, with a choice of sheet when there are several
- JSON: a list of records, a record holding a list, a list of lists, or one record per line
Your file is opened by your browser and is never uploaded. This is a plain converter. No AI is involved and nothing is guessed.
What happens to your data
Every download holds the whole file, not only the rows shown here. Values are written exactly as they appear, so zip codes such as 02134 and long numbers such as 16-digit references keep every digit, and dates stay as written. With the numbers box ticked, plain amounts become numbers Excel can add up, while values with leading zeros or more than 15 digits stay as text.
In CSV and tab-separated downloads, a cell that starts with =, +, - or @ and is not a plain number gets an apostrophe in front, so a spreadsheet shows it as text and does not run it as a formula.
Moving the same export between two systems every week?
I connect the two systems read-only and send one page each morning with the numbers you were pulling out by hand. A free 30-minute look shows what your systems could answer today.
What JSON is
JSON is a plain-text format that programs use to pass data to each other, written as names and values inside curly brackets, such as {"sku": "A-100", "qty": 12}. Many online systems hand out their data this way, which is fine for programs and hard to read for people. A spreadsheet is the opposite, so this page turns one into the other.
How JSON becomes columns
- A list of records becomes one row per record, with one column for every name that appears in any record.
- Records inside records get dotted column names. {"address": {"city": "Boston"}} becomes a column called address.city.
- A list of plain values, such as tags, is joined into one cell with "; " between the values. A list of records inside a record is numbered: lines.0.sku, lines.1.sku.
- A record that holds a list, as many systems return it, shows the list. If there are several lists, the longest is used.
- A list of lists is read as rows, and one record per line (sometimes called JSON Lines) works as well.
Numbers are kept exactly as written in the JSON, so a long order number does not get rounded.
CSV to JSON
Drop in a CSV or Excel file, choose JSON under "Download as" and press Download. You get a list of records named after the heading row, with every value as text. Tick "Turn number-looking text into real numbers" to write plain amounts as numbers; values with leading zeros, such as zip codes, stay as text.
A CSV file, if you have not met one, is a table saved as plain text with commas between the cells. Need to check two exports against each other? Use compare two lists.
Questions
Is my file uploaded?
No. Your browser opens the file and does the converting. Nothing is sent anywhere, and nothing is kept after you close the page.
How big a file can it handle?
In a test on a fast desktop computer in Chrome, a 100,000-row CSV file (8 MB) opened in under a second and became an Excel file in about a second and a half. A 500,000-row file (44 MB) took about 10 seconds to become Excel and about a second to become CSV or JSON. An older laptop will be slower. The table shows the first 200 rows, but every download holds the whole file. Excel itself holds at most 1,048,576 rows, so larger files can only come out as CSV, JSON or tab-separated text.
My JSON will not open. Why?
The page tells you which line the problem is on. The usual causes are a comma after the last item, names without double quotes, or text copied with part of it missing. JSON does not allow comments or single quotes.
Can I get JSON to Excel directly?
Yes. Paste or drop in the JSON and download it as Excel. Every cell is written as text so codes and long numbers stay exact, unless you tick the numbers box.
Why do some cells in my CSV start with an apostrophe?
A cell that starts with =, +, - or @ can be run as a formula when a spreadsheet opens the file, which is a known way to slip harmful commands into a CSV. The apostrophe makes the spreadsheet show it as plain text. Plain numbers such as -12.50 are left alone.
Is this AI?
No. It is a plain converter. It reads the file, shows it as a table and writes it out in another format, the same way every time.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools, with compare two lists and the aging report.