Premium Converters
Loading
Loading
Loading
Convert JSON arrays of objects to CSV (or back). Custom delimiter, type coercion, copy + download.
Utility
Generated on May 23, 2026
Convert JSON arrays of objects to CSV (or back). Custom delimiter, type coercion, copy + download.
The JSON ↔ CSV converter turns an array of JSON objects into a CSV table (and vice versa) — the most common data-transformation task in spreadsheet, ETL, and reporting workflows. Headers are inferred from the union of keys across all rows. Cells are properly escaped: values containing commas, quotes, or newlines are wrapped in quotes with internal quotes doubled.
Formula
JSON [{a:1,b:2},{a:3}] → CSV header: 'a,b' + rows. Cells with comma/quote/newline are wrapped in "…" with internal " doubled.You're converting between JSON and CSV because someone — a client, a product manager, a non-technical stakeholder — wants the data 'in Excel' and you've got it as a JSON API response. Or you're going the other way: a CSV export from a CRM that needs to be massaged before it gets POSTed into a new system. Both directions sound trivial until you hit the edge cases: a cell containing a comma, a cell containing a newline, a cell containing a literal double-quote, or a delimiter that's actually a semicolon because the CSV was opened in Excel under a European locale. Proper escaping (wrap-in-quotes, double-internal-quotes) handles all of it; broken escaping silently corrupts your data and you find out about it three weeks later when somebody's name is split across two columns. Paste your JSON array on one side and get a clean CSV with headers inferred from the union of all object keys; paste your CSV and get back a properly-typed JSON array where 'true', 'false', numbers, and 'null' get coerced into their real types instead of staying as strings. Delimiter is configurable — comma for US, semicolon for German/French Excel, tab for TSV, pipe for log-friendly formats. Nested objects get JSON-stringified into a cell rather than flattened, because flattening rules are domain-specific and you usually want to handle that yourself.
The JSON ↔ CSV converter turns an array of JSON objects into a CSV table (and vice versa) — the most common data-transformation task in spreadsheet, ETL, and reporting workflows. Headers are inferred from the union of keys across all rows. Cells are properly escaped: values containing commas, quotes, or newlines are wrapped in quotes with internal quotes doubled. Choose comma, semicolon, tab, or pipe as your delimiter to match your spreadsheet's locale (Excel in many European locales uses semicolon; tab-separated values are universal). When converting CSV → JSON, simple types (numbers, booleans, null) are coerced automatically.
Convert a JSON API response to CSV for opening in Excel or Google Sheets.
Convert a CSV export from your database to JSON for import into a JS app.
Bulk-edit data: API → JSON → CSV → edit in Sheets → CSV → JSON → API.
Convert MongoDB exports (JSON Lines) to CSV for non-technical stakeholders.
Sample data: list of cities or products with name, country, population — converts cleanly.
Jump to a ready-made conversion — useful for quick reference and sharing:
Base Converter
Convert integers between binary (base 2), octal (base 8), decimal (base 10), and hexadecimal (base 16) — built for programmers debugging memory addresses, bitmasks, and hex colors.
Unix Timestamp Converter
Translate Unix epoch timestamps (seconds or milliseconds since Jan 1 1970 UTC) to readable ISO, UTC, and local-timezone dates — auto-detects format and handles the Y2038 problem.
Color Converter
Translate colors between HEX, RGB, and HSL with a live swatch preview — built for CSS work, brand palette design, and converting Tailwind shades between formats.
Word Counter
Live word, character, sentence, and paragraph counter with reading and speaking time estimates — ideal for essays, blog SEO, tweets within 280 chars, and timed speeches.
Case Converter
Instantly convert text between UPPERCASE, lowercase, Title Case, Sentence case, camelCase, PascalCase, snake_case, and kebab-case — ideal for variable renaming, URL slugs, and headings.
Password Generator
Generate cryptographically secure random passwords (6 to 64 chars) using the browser's Web Crypto API, with strength meter and optional uppercase, digits, and symbol character sets.
Text Reverser / Palindrome Checker
Reverse any text character-by-character or word-by-word, plus check classic palindromes like "A man, a plan, a canal: Panama" while ignoring spaces, punctuation, and case.
QR Code Generator
Create QR codes from URLs, text, Wi-Fi, contact cards, email, phone, SMS, and locations. Free PNG and SVG download.
Browse all Utility calculators & converters
See every tool in this category, plus FAQs and category-specific guides.