100% free · Runs 100% in your browser · No signup needed
Paste your JSON
CSV output
About JSON to CSV Converter
What is the JSON to CSV Converter?
JSON and CSV are the two most common ways data travels on the internet, but they speak very different languages. JSON (JavaScript Object Notation) stores data in nested, hierarchical structures — perfect for APIs and applications, but unreadable in a spreadsheet. CSV (Comma-Separated Values) lays the same data out in flat rows and columns — perfect for Excel, Google Sheets, and databases, but unable to represent nesting. The JSON to CSV Converter by FistHost bridges the two: paste any JSON, and it produces clean, properly escaped CSV in one click.
The conversion is smarter than a simple copy-paste. Nested objects are flattened into dot-notation keys — so {"contact": {"email": "a@b.com"}} becomes a column named contact.email — and arrays are joined with a semicolon separator, so a tags list like ["vip", "new"] becomes the single cell vip; new. Every value is scanned for the delimiter, quotes, and line breaks, and wrapped in quotes with internal quotes doubled, exactly as the CSV standard requires. The result opens correctly in Excel, Google Sheets, LibreOffice, and any database import tool without mangled columns.
You stay in control of the output format. Choose from four delimiters (comma, semicolon, tab, pipe) — essential because many European versions of Excel expect semicolons, not commas. Toggle the header row on or off depending on whether your import tool wants column names. Switch flattening off if you would rather keep nested objects as compact JSON strings inside a single cell. A row and column count is reported after every conversion, so you can sanity-check that nothing was lost, and the downloaded file includes a UTF-8 BOM so Excel displays international characters correctly.
How to Use the JSON to CSV Converter
Paste your JSON into the input box — an array of objects, a single object, or nested data. Or click Load Sample to try it instantly.
Choose the delimiter — comma is the default; pick semicolon if your spreadsheet locale (e.g. much of Europe) uses it, tab for TSV-style output, or pipe for database imports.
Set the header option — keep Include header row checked to get column names in the first row, or uncheck it for headerless data feeds.
Set the flattening option — with Flatten nested objects on (default), nested keys become dot-notation columns; off, they stay as JSON strings in one cell.
Click Convert to CSV — the output appears immediately, with a count of rows and columns converted.
Review the output — check that nested fields and arrays were handled the way you expected before exporting.
Copy or download — use Copy CSV to paste straight into a spreadsheet, or Download CSV to save a converted.csv file.
Fix errors if flagged — invalid JSON produces a clear message pointing at the parse error (missing comma, stray quote, unbalanced bracket) so you can correct it and retry.
Key Features
Smart nested-object flattening — nested keys become dot-notation columns (e.g. address.city), preserving hierarchy information that naive converters throw away.
Array handling — array values are joined with "; " into a single readable cell instead of breaking the row structure.
Four delimiters — comma, semicolon, tab, and pipe, covering Excel locales, TSV workflows, and database loaders.
Header row toggle — include column names for spreadsheet work or produce headerless CSV for automated pipelines.
Proper CSV escaping — values containing the delimiter, quotes, or newlines are quoted and internal quotes doubled per the CSV standard, so imports never misalign.
One-click sample data — a realistic nested JSON dataset loads instantly so you can explore every feature without finding test data.
Row and column reporting — every conversion reports how many rows and columns were produced, a quick integrity check for large datasets.
Copy and download — copy to clipboard for instant pasting, or download a file with a UTF-8 BOM so Excel renders international characters correctly.
Clear JSON error messages — parse failures show the exact error from the JSON parser instead of a blank screen, pointing you at the problem.
Pro Tips
Arrays of objects convert best. The classic [{...}, {...}] shape maps perfectly to rows and columns. A single object becomes one data row; deeply ragged structures may need flattening off.
Match the delimiter to your spreadsheet. If Excel opens your CSV with everything crammed into one column, you probably need the semicolon option — many locales use ; as the list separator.
Keep headers for manual work, drop them for pipelines. Human analysts want column names; automated ETL scripts usually expect data only. The toggle covers both.
Validate tricky JSON first. If the converter reports a parse error, paste the JSON into a formatter to spot the missing comma or bracket — it is almost always one character.
Watch out for huge files. Browsers handle tens of thousands of rows comfortably, but multi-megabyte JSON may be slow — split very large exports into chunks.
Check special characters after import. The download includes a UTF-8 BOM for Excel compatibility; if characters still look wrong, re-save the file explicitly as UTF-8 in your editor.
Working with data every day? Put your portfolio, your API docs, or your data blog on the web with FistHost — web hosting plans from just $0.99/month with a free domain included. Fast, affordable, and ready in minutes. Launch your site with FistHost today.
Who Uses the JSON to CSV Converter?
Data analysts — professionals turning API responses and log exports into spreadsheets for pivot tables, charts, and reporting.
Developers — programmers who need to hand a client or a non-technical colleague a CSV version of JSON data from an endpoint or database dump.
Marketers — growth teams exporting ad-platform or analytics JSON into CSV for Excel dashboards and stakeholder reports.
Researchers and students — academics converting JSON datasets from open-data portals into a format their statistics tools can read.
E-commerce managers — store owners transforming product-feed or order JSON into CSV for bulk upload tools and inventory systems.
Finance and operations staff — anyone reconciling JSON exports from payment gateways or SaaS tools inside spreadsheet workflows.
Frequently Asked Questions
How are nested objects handled?
With flattening enabled (the default), each nested key becomes a dot-notation column: {"user": {"name": "Ali"}} produces a user.name column. Turn flattening off and the whole nested object is kept as a compact JSON string in a single cell.
What happens to arrays inside my JSON?
Array values are joined into one cell with "; " as the separator — for example ["red", "blue"] becomes red; blue. This keeps every row the same width so the CSV structure never breaks.
My CSV opens in Excel with everything in one column. Why?
Your Excel locale probably uses semicolons as the separator. Re-run the conversion with the semicolon delimiter selected and it will split into columns correctly.
Is my data private? Is it uploaded anywhere?
Completely private. The conversion runs entirely in your browser with JavaScript — your JSON is never sent to any server, stored, or logged. You can even disconnect from the internet after the page loads and it still works.
What if objects have different fields?
The converter collects every unique key across all objects to build the column set. Objects missing a field simply get an empty cell in that column — no data is dropped and no rows shift.
Can I convert CSV back to JSON?
This tool is one-directional (JSON → CSV). Dot-notation columns and joined arrays cannot be perfectly reversed into the original nesting, so keep your source JSON if you need to go back.
How large a file can I convert?
There is no hard limit, but browsers slow down with very large inputs. Tens of thousands of rows work fine; for multi-megabyte files, consider splitting the JSON into smaller chunks first.
Related Tools
Explore more free data tools: JSON Formatter to validate and beautify JSON before converting, Regex Tester for extracting patterns from your data, and Diff Checker for comparing CSV outputs side by side.
Got data worth sharing with the world? Publish it on your own site with FistHost web hosting — plans start at only $0.99/month and include a free domain. Simple setup, reliable performance, and support that helps. Get online with FistHost today.
User Reviews
No reviews yet. Be the first to review this tool!
Write a Review
Reviews are protected by captcha and moderated before they appear.
