Turn JSON into a spreadsheet-ready CSV, or CSV back into clean JSON, in your browser.
This free JSON to CSV / CSV to JSON converter moves data between the two most common formats for APIs and spreadsheets. It helps developers, bloggers, marketers and analysts who need to open API data in Excel or load spreadsheet rows into a script.
Features
Two directions, one tool
Switch between JSON to CSV and CSV to JSON, then use Swap to send the output back as input and check the round trip.
Nested data handling
Flatten nested objects into dot-style columns and choose whether arrays are joined, kept as JSON text or split into numbered columns.
Delimiter and format control
Use comma, semicolon, tab or pipe, turn the header row on or off, and set how the JSON is indented.
Copy, download or open a file
Open a local file, copy the result or download it, with an optional UTF-8 BOM so Excel reads accented text correctly.
How to Use
- Choose JSON to CSV or CSV to JSON at the top of the tool.
- Paste your data into the input box, or press Open file to load a .json, .csv, .tsv or .txt file.
- Adjust the options: delimiter, header row, flattening and array handling for JSON, or type conversion and indent for CSV.
- Press Convert and read the row and column count under the boxes. If something is wrong, the message tells you what to fix.
- Copy the result or download it as a file. Use Swap if you want to send the output back in as input.
Use Cases
API data in a spreadsheet
Turn a JSON response from a REST API into rows you can sort, filter and chart in Excel or Google Sheets.
Spreadsheet data in an app
Convert a CSV export from a form, store or CRM into JSON for a script, a mock API or a database import.
Keyword and analytics exports
Move keyword lists, crawl results or analytics exports between a spreadsheet and your own scripts without retyping.
Test data and config review
Build JSON test data from a spreadsheet, or flatten a settings file into a table so a team can review it.
Basic Knowledge
JSON and CSV store data in different shapes. JSON is a tree: an object can hold other objects and lists, so one record can have many levels. CSV is a flat table where each line is one row and each column holds a single value.
Converting JSON to CSV means flattening that tree. A nested value such as address.city becomes its own column with the same name. Lists need a rule, because one cell cannot naturally hold many values, so you can join the items, keep them as JSON text or spread them over numbered columns.
CSV looks simple but has rules. A field that contains the delimiter, a double quote or a line break must be wrapped in double quotes, and a quote inside the field is written twice. A good JSON to CSV / CSV to JSON converter follows these rules in both directions, so a name like "Rao, Asha" stays in one column.
CSV also has no data types. Everything is text, so converting CSV to JSON means deciding whether 42 is a number and whether true is a boolean. That is why this tool lets you switch type conversion on or off.
Tips and Common Mistakes
- Check that your JSON is valid first. Trailing commas, single quotes and comments stop the parse, and the error message shows where to look.
- If your records sit under one of several keys, enter the path, such as data.items, in the array path box. Otherwise the whole object becomes one row.
- Switch type conversion off for IDs and phone numbers that must stay exactly as written, because a value like 1.50 becomes 1.5.
- Opening the CSV in Excel? Use the UTF-8 BOM option and formula protection, so cells starting with = or @ are not run as formulas.
Safety and Privacy
- The conversion runs in your browser with JavaScript, so the data you paste or open is processed on your own device and is not uploaded by this tool.
- Nothing is stored. Your input and output stay on the page and disappear when you reload or close it.
- The page is served over HTTPS, so the connection between your browser and ranktools.in is encrypted.
- The tool does not send your data to any third party. Even so, avoid pasting passwords or API keys on a shared computer.
Frequently Asked Questions
How do I convert JSON to CSV?
Paste your JSON, keep JSON to CSV selected and press Convert. A list of objects becomes the rows and the keys become the column headers. If the list sits inside an object, enter its path, such as data.items, in the array path box.
How are nested objects and arrays handled?
With flattening on, nested objects become dot-style columns such as address.city. Arrays can be joined with semicolons, kept as JSON text or split into numbered columns, so you can pick what suits your spreadsheet.
What if my CSV has no header row?
Turn off the header option and each row becomes a plain list of values instead of an object. Turn it back on if your first row does hold column names.
Can I convert a large file?
You can open files up to 10 MB. Everything runs in your browser's memory, so speed depends on your device. Split very large files first.
Is this JSON to CSV / CSV to JSON converter free?
Yes. There is no signup and no usage limit built into the page, and you can convert as often as you like.