How to use the JSON ↔ CSV Converter
Convert a JSON array of objects — from an API, Postman, logs, or a database export — into clean CSV ready for Excel, Google Sheets, BI tools, or a SQL bulk load. Flip the direction to turn CSV back into JSON for tests, fixtures, and integration scripts. The converter flattens nested objects, lets you pick or reorder columns, and quotes values safely; everything runs in your browser.
What it does
- JSON → CSV: takes an array of objects and produces a CSV with a header row and consistent columns.
- CSV → JSON: produces an array of objects with typed values where possible (numbers, booleans, nulls).
- Flatten nested objects using dot-paths (e.g.,
user.name, address.city).
- Custom delimiter (comma, semicolon, tab, pipe) and quote handling for Excel compatibility.
- Preserves UTF-8 characters and emoji; optional BOM for Excel-on-Windows.
- Preview, copy, download, or send to CSV Viewer, SQL IN Builder, or JSON Formatter.
When to use it
- Convert a JSON API response into a spreadsheet for stakeholders.
- Export logs (newline-delimited JSON) to CSV for reporting.
- Create test fixtures in JSON from a CSV exported by analysts.
- Reformat a Postman / DevTools response for an audit trail.
- Prepare bulk-insert data for a database from a JSON dump.
- Hand off tabular results to a non-technical reviewer.
How to use it
- Paste your JSON or CSV into the input editor (or load from clipboard / file).
- The converter detects the direction automatically — JSON arrays become CSV; CSV with a header row becomes a JSON array of objects.
- Enable Flatten to expand nested objects into dot-path columns (
user.name, address.country).
- Pick the delimiter and toggle the header row, quoting, and BOM as needed.
- Inspect the preview, then copy or download the result. Open the CSV in Excel or Sheets, or pipe the JSON to your tests.
Tips & pitfalls
- For JSON → CSV, all objects should share consistent keys — missing keys produce empty cells, not errors.
- Excel on Windows expects a UTF-8 BOM to render non-ASCII characters correctly — enable it if names show as mojibake.
- Nested arrays cannot become a single CSV cell cleanly — flatten, stringify, or split into multiple rows.
- Quotes inside fields must be doubled in CSV (RFC 4180); the converter handles this automatically.
- Use the JSON-to-CSV direction with the JSON Formatter first if the source JSON has parse errors.
FAQ
- How do I convert JSON to CSV online? Paste a JSON array of objects, choose a delimiter, and download or copy the CSV.
- How do I convert CSV to JSON? Paste a CSV with a header row — the converter produces a JSON array of objects with typed values.
- Does it support nested JSON? Yes — enable Flatten to convert nested keys into dot-paths like
user.address.city.
- Why does Excel show garbled characters? Excel needs a UTF-8 BOM to detect encoding — enable the BOM option, or open the file via Data → From Text.
- Is the file uploaded? No. Conversion is local in your browser. Nothing is sent to a server or logged.
- Can I select which columns to include? Yes — reorder or hide columns in the preview before exporting.
Runs locally in your browser. No uploads. No analytics on pasted data.
Related guides
