AboutProjectsToolsNotesUses

JSON to CSV

Convert JSON arrays to CSV for spreadsheets and data export.

Paste an array of objects and get a CSV with one header row and one data row per object. Nested fields are flattened with dot-notation column names so an Excel or Google Sheets import gets a clean table without manual unpacking.

Common use cases: handing API output to a non-technical teammate, importing data into a spreadsheet for ad-hoc analysis, archiving a dataset in a portable text format, and prepping files for tools that expect CSV input.

JSON Input

Reference

Conversion Info
• Converts array of objects to CSV
• Creates headers from object keys
• Auto-quotes fields with commas
• Escapes quotes in values
• Handles null/undefined values
• Compatible with Excel & Sheets

Frequently asked questions

What JSON shape does it expect?
An array of objects, where each object is one row and the keys are columns. For example [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Nested objects are flattened with dot-notation column names; nested arrays are JSON-stringified into a single cell.
How are columns ordered?
By order of first appearance across the input. The first object determines the leading columns; new keys encountered in later objects get appended on the right with blank cells filled in for earlier rows.
How are special characters handled?
Cells containing commas, double quotes or newlines are wrapped in double quotes, with any internal quotes escaped as "" — the standard RFC 4180 dialect that Excel, Google Sheets and most CSV parsers expect.
My CSV opens with everything in one column in Excel — why?
Excel's default separator is locale-dependent: comma in en-US, semicolon in many European locales. Either change the delimiter when opening (Data → From Text/CSV) or save the file with the separator your locale expects.

Other Converters

View all tools →

Image to Base64

Convert images to Base64 encoded strings

IMG

Roman Numeral Converter

Convert between numbers and Roman numerals

Ⅻ

Temperature Converter

Convert between Celsius, Fahrenheit, and Kelvin

°

Base Converter

Convert numbers between different bases (binary, octal, hex, etc.)

∑

Color Converter

Convert colors between HEX, RGB, HSL, and more formats

◆

JSON to TypeScript

Convert JSON to TypeScript type definitions

{}

JSON to Rust

Convert JSON to Rust struct definitions

{}

CSS Unit Converter

Convert between CSS units (px, em, rem, %, pt)

CSS

Text Case Converter

Convert text between different cases (camelCase, snake_case, etc.)

Aa

Unix Time Converter

Convert between Unix timestamps and readable dates

time

Timezone Converter

Convert times between timezones worldwide for meetings and global coordination

◆

CSV to JSON

Convert CSV data to JSON format for APIs and applications

⇄