Runs in your browser. Nothing you enter is uploaded or stored.
To convert JSON to CSV or CSV to JSON, choose the direction in the free JSON to CSV and CSV to JSON Converter above, paste your data and press Convert. JSON is flattened into columns, with nested objects shown as dotted names such as stats.clients and simple lists joined with a semicolon. CSV is read with proper handling of quoted fields, auto-detects whether the delimiter is a comma, semicolon, tab or pipe, and can turn numbers and true or false values into real JSON values. It handles up to 50,000 rows and runs in your browser.
Last updated: 11 November 2026. Written by Saad Raza.
Key takeaways
- JSON stores nested data and CSV stores flat tables. Converting between them means deciding how to flatten or rebuild the structure, and this tool does that in a predictable way.
- A JSON array of objects becomes a table with one row per object. The columns are the union of all keys, so records with missing fields leave empty cells.
- CSV fields that contain commas, quotes or line breaks must be wrapped in quotation marks. The converter does this on output and understands it on input.
- The delimiter can be detected automatically, which helps with European exports that use semicolons.
- Spreadsheets can change values, for example by dropping leading zeros or turning long codes into scientific notation, so check the result after opening a CSV.
- Your data stays in your browser and is not uploaded.
Why convert between JSON and CSV
Most marketing and SEO data comes in one of these two shapes. APIs, structured data and tools return JSON. Spreadsheets, bulk upload screens and reporting tools want CSV. Moving data between them is a daily job: exporting API results to a spreadsheet for analysis, preparing a product feed, turning a spreadsheet into JSON for a script or a schema block, or cleaning a list of records before an import.
Doing it by hand is slow and easy to get wrong, especially with nested fields, commas inside text and special characters. A converter makes the rules explicit and repeatable.
How to use the converter
- Choose JSON to CSV or CSV to JSON.
- Choose the delimiter. For CSV to JSON, the default auto-detects it from the first line. For JSON to CSV the default is a comma.
- For CSV to JSON, tick convert numbers, true, false and null into real values if you want typed data, and turn headers like address.city into nested objects if you want to rebuild a structure.
- Paste your data. You can paste up to 50,000 rows.
- Press Convert. Copy the result or download it as a .csv or .json file. The summary shows the number of rows and columns, and warns when a row has a different number of fields from the header.
How JSON is flattened
| JSON value | In the CSV |
|---|---|
| A string, number or true or false | The value itself |
| A nested object | One column per key, named with dots, for example stats.clients |
| A list of simple values | One cell with the values joined by a semicolon and a space |
| A list of objects | One cell holding the list as JSON text |
| null or a missing key | An empty cell |
| A value that is not an object, such as a plain list of numbers | A single column called value |
If the top level is a single object rather than a list, it is treated as one record. If the JSON is not valid, you get an error message, and the JSON formatter and validator will show you exactly where the problem is.
A worked example
The JSON example has two records. The first is Saad Raza in Karachi, with the skills SEO, AEO and GEO and a stats object holding clients 100 and years 10. The second is Ayesha Khan in Lahore, with one skill, PPC, and stats of 24 clients and 4 years. The converter produces 2 rows and 5 columns: name, city, skills, stats.clients and stats.years. The first row reads Saad Raza, Karachi, SEO; AEO; GEO, 100, 10, and the second reads Ayesha Khan, Lahore, PPC, 24, 4.
The CSV example goes the other way. It has a header of name, city, clients and active, and three data rows. One name is written as “Khan, Ayesha” in quotation marks because it contains a comma, and the converter keeps it as one value. The third row has an empty clients field. With type conversion on, clients become numbers, active becomes true or false, and the empty field stays as an empty string rather than being guessed. The result is 3 rows and 4 columns.
Practical uses for SEO and marketing
- API exports. Turn the JSON from an analytics, search or marketing API into a table you can sort and chart.
- Structured data at scale. Turn a spreadsheet of products, locations or FAQs into JSON, then build schema markup with the schema generator and check it with the JSON-LD validator.
- Bulk edits. Convert a list to CSV, edit it in a spreadsheet, and convert it back. Titles, descriptions and redirects are common examples. Check the redirects afterwards with the redirect checker.
- Clean lists. Remove repeated rows with the remove duplicate lines tool before converting.
- Debugging encoded data. If a JSON field is Base64 or URL-encoded, decode it first with the Base64 encoder and decoder or the URL encoder and decoder.
- Comparing versions. Convert two exports and compare them with the text compare checker to see what changed.
Common problems and how to avoid them
Different keys in different records. The CSV has a column for every key that appears anywhere, so a record without a key gets an empty cell. If the columns are in an odd order, that is because the converter lists them in the order they first appear.
Large numbers and codes. Spreadsheets may show a long number such as an ID in scientific notation, or drop leading zeros from a postcode or product code. Import the CSV as text for those columns, or keep the values as text in the JSON.
Dates. JSON has no date type, and CSV does not either. Dates stay as text, so keep them in one clear format such as 2026-11-11.
Delimiters and decimals. In some regions a semicolon is the CSV separator because the comma is the decimal mark. Pick the delimiter to match the program that will read the file.
Character encoding. Save and open files as UTF-8 so that accented letters and non-Latin text survive. The converter accepts a byte order mark at the start of a CSV.
Round trips. A list of objects stored in one cell as JSON text will not become a list again unless you convert that cell on its own. Nested objects do rebuild if you tick the nest option and the headers use dots.
If you are moving a lot of data around for a migration or an audit and want a second pair of eyes, my SEO audit covers data checks as well as technical issues.
Limits
The tool converts text. Files are not uploaded, so open the file in a text editor and paste the content. It reads up to 50,000 rows for JSON to CSV and 100,000 rows for CSV to JSON, and very large pastes may slow your browser. It does not validate the meaning of the data or repair invalid JSON, and an unclosed quotation mark in a CSV is reported as an error. Type conversion recognises plain integers and decimals, and the words true, false and null. Numbers with leading zeros, such as 007, and numbers that would change when converted, such as very long digits, stay as text so that no information is lost. Processing happens in your browser, and nothing is sent to a server.
Questions about the JSON to CSV and CSV to JSON Converter
How do I convert JSON to CSV?
Choose JSON to CSV, paste a JSON array of objects and press Convert. Each object becomes a row, and nested keys become columns with dotted names.
How are nested objects and lists handled?
Nested objects are flattened into columns such as stats.clients. Lists of simple values are joined with a semicolon, and lists of objects are kept as JSON text in one cell.
Can it read semicolon or tab separated files?
Yes. CSV to JSON detects a comma, semicolon, tab or pipe from the first line, or you can choose the delimiter yourself.
Why do my numbers look wrong in a spreadsheet?
Spreadsheet programs may reformat long numbers and drop leading zeros when they open a CSV. Import the column as text to keep the original value.
Is my data uploaded?
No. The conversion runs in your browser, so API responses and customer lists stay on your device.
If you want help with data and technical SEO, see my SEO services or ask for a free audit. You can also browse the other free technical SEO tools.
Request received
Thank you! Saad will contact you within the next 24 hours.
Keep an eye on your phone and inbox.
