JSON to CSV
JSON to CSV
Turn a list of flat JSON objects into a quoted CSV dataset.
A list of object records can become a spreadsheet dataset when their fields are made explicit.
Paste the records and inspect the combined columns before exporting. Review missing values on the same basis.
How to use JSON to CSV
- Paste or enter array of objects.
- Choose input separator and CSV export values.
- Select Process input. Read the returned values alongside the assumptions below before copying, exporting or acting on the result.
Why choose this tool?
The union of field names prevents a column from disappearing because it was absent in the first record.
Before you use the result
Fields use the union of object keys. Missing and null fields become blank cells. Nested objects and arrays become compact JSON in a cell.
Questions about JSON to CSV
What happens to nested objects?
They become compact JSON inside a CSV cell. Missing and null values become blank cells.
What should I check before using JSON to CSV?
Check Array of objects, Input separator and CSV export values. Use the exact units shown beside the controls and replace any example values with your own inputs.
Related Tools
Explore the other tools in this collection.
Base64 Encoder & Decoder
Encode UTF8 text, decode strict Base64 and inspect binary results as hex.
Open toolCSV Cleaner & Deduplicator
Trim cells, remove duplicate records and reserialize quoted CSV.
Open toolCSV Column Selector
Select named columns in your chosen order without losing cell values.
Open toolCSV Dataset Merger
Append two CSV datasets with exactly matching header order.
Open toolCSV Numeric Column Statistics
Summarise an explicitly selected numeric column and report blank values.
Open toolCSV to JSON
Convert a header based CSV into JSON while preserving every cell as text.
Open toolCSV to SQL INSERT Builder
Generate quoted INSERT statements for review without executing SQL.
Open toolData Size Unit Converter
Compare decimal byte units with binary byte units.
Open toolDuplicate Line Remover
Keep the first occurrence of each line with optional case and whitespace rules.
Open toolExact Number Base Converter
Convert signed integer strings across bases 2 to 36 without float rounding.
Open toolHEX RGB HSL Color Converter
Convert a six or three digit HEX color, RGB channels or HSL values.
Open toolHMAC Signature Generator
Create a keyed SHA256 or SHA512 HMAC from an exact message.
Open toolHTML Entity Encoder & Decoder
Escape HTML characters or decode HTML5 entities into plain displayed text.
Open toolHTML to Plain Text
Extract text from pasted HTML with block spacing and script content removed.
Open toolIPv4 CIDR Subnet Calculator
Show network, mask, address range and conventional host capacity.
Open toolJSON Formatter & Validator
Validate, format or compact JSON without rounding its number tokens.
Open toolJSON Pointer Explorer
Read a nested value using an RFC 6901 pointer and inspect its children.
Open toolJSON Structure Diff
Compare JSON nodes by type, value and path, ignoring object key order.
Open toolJWT Decoder, Unverified
Read JWT header and payload without verifying the signature or trusting claims.
Open toolLine by Line Text Diff
Compare two texts with an exact line sequence and show additions and removals.
Open toolQuery String Builder
Create an encoded query from an ordered CSV of key and value pairs.
Open toolRegular Expression Tester
Inspect bounded PCRE matches and capture groups on a UTF8 text sample.
Open toolText Case Converter
Apply Unicode case conversion where the installed PHP mbstring supports it.
Open toolText Hash Generator
Calculate checksum digests for the exact UTF8 bytes you enter.
Open toolText Line Sorter
Sort lines naturally, lexically or by numeric values.
Open toolTimezone Date Converter
Convert an explicitly entered wall clock time and flag DST ambiguity.
Open toolUnicode Text Counter
Count UTF8 characters, words, lines and whitespace in English or Urdu text.
Open toolUnix Timestamp Converter
Convert exact whole seconds or milliseconds and inspect UTC and Pakistan time.
Open toolURL Component Encoder & Decoder
Encode a URL component or decode percent escapes without fetching a URL.
Open toolURL Component Inspector
Inspect a URL and its ordered query pairs, preserving duplicate keys.
Open toolUUID Version 4 Generator
Generate independent UUIDs with PHP cryptographic randomness.
Open tool