Tools
Word / Character CounterCase ConverterLorem Ipsum GeneratorJSON FormatterRegex TesterCron Expression ParserString Escape / UnescapeSQL Formatter
Merge PDFSplit PDFPDF to ImageImage to PDFCompress PDFUnlock PDF
Image EditorImage ConverterImage ResizerImage CropperOCR Text ExtractorImage Compressor
Hash GeneratorQR Code GeneratorPassword GeneratorColor Palette GeneratorRandom Number GeneratorUUID Generator
Base64 Encoder/DecoderURL Encoder/DecoderHTML Encoder/DecoderUnicode Encoder/DecoderASCII Encoder/Decoder
JSON ViewerCSV ViewerMarkdown ViewerJWT ViewerDiff Viewer
JSON → YAMLJSON → XMLJSON → TypeScriptJSON → CSVYAML → JSONCSV → JSONXML → JSONMarkdown → HTMLTOML → JSONUnix Timestamp ConverterJSON → TOMLUnit ConverterData Size ConverterHEX ↔ RGB Converter
Finance
Severance Pay Calculator
Daily
Tip CalculatorAge CalculatorElectricity Cost CalculatorDate CalculatorD-Day Calculator100-Day Anniversary CalculatorRelationship Days CalculatorTime CalculatorPercentage CalculatorRatio CalculatorAverage CalculatorDiscount Calculator
Health
Sleep CalculatorBMI CalculatorBMR CalculatorDaily Calorie CalculatorBody Fat CalculatorWater Intake Calculator
Study
GPA CalculatorExam Average Calculator
Utility
Area CalculatorVolume CalculatorSpeed CalculatorAspect Ratio Calculator

JSON → CSV

Convert a JSON array to CSV format. Input must be an array of objects.

JSON
Ln:1 Col:1
CSV

About JSON to CSV Conversion

Converting JSON arrays to CSV is a common data engineering task — exporting API data to spreadsheets, preparing datasets for data analysis tools (Excel, Google Sheets, pandas), generating reports, or loading data into relational databases that accept CSV imports. Most BI tools and ETL pipelines support CSV as a universal input format.

JSON Array to CSV Reference

For a valid JSON-to-CSV conversion, the input must be an array of objects ([{...}, {...}]) where each object represents a row. The keys of the objects become the CSV headers. Objects with missing keys produce empty cells for those columns. Nested objects or arrays are serialized as JSON strings within the cell.

RFC 4180 defines the widely accepted CSV standard. Key rules: fields containing commas, double quotes, or newlines must be enclosed in double quotes; double quotes within quoted fields are escaped as "" (two double quotes). When opening CSV files in Excel, watch out for auto-formatting of numeric strings — Excel may strip leading zeros from ZIP codes or phone numbers formatted as numbers.

FAQ

How is nested JSON converted to CSV?
CSV is a 2D table format, so nested objects are flattened using dot notation (address.city) or serialized as JSON strings. Deep nesting may cause information loss — simplify the structure beforehand.
How are values containing commas handled in CSV?
Per RFC 4180, values containing commas, newlines, or double quotes are wrapped in double quotes. Double quotes themselves are escaped by doubling ("").
Can JSON with arrays be converted to CSV?
If the top level is an array of objects with identical keys, conversion works well. Nested arrays within values are serialized as JSON strings or split into multiple rows.

Related Tools

CSV → JSON

Convert CSV data to a JSON array online. Transform spreadsheet data for REST APIs and NoSQL databases instantly.

CSV Viewer

Visualize CSV data as a table.

JSON Viewer

Format and visualize JSON data in a tree structure.

JSON → YAML

Convert JSON data to YAML format online. Perfect for Kubernetes manifests, Docker Compose, and GitHub Actions config files.

JSON Formatter

Beautify or minify JSON data. Paste, format, and copy.