Convert JSON to Other Formats

Convert JSON to CSV for Excel, TypeScript interfaces for development, SQL INSERT statements, or YAML for config files. One-click export.

Convert JSON

Output Format

📁 Drag and drop a .json file or paste JSON

How to Use JSON Formatter

  1. 1 Paste your JSON in the editor
  2. 2 Select output format: CSV, TypeScript, SQL, or YAML
  3. 3 Preview the converted output
  4. 4 Copy or download the result

What You Get

Multi-format JSON converter. Export your data to spreadsheets (CSV), code (TypeScript interfaces), databases (SQL), or configuration files (YAML).

Input: [{"name":"John","age":30}]

Output: CSV: name,age\nJohn,30

Input: {"user":{"name":"John"}}

Output: TypeScript: interface Root { user: User; }

How do I convert JSON to CSV?

Paste your JSON array, select CSV format. Nested objects are flattened using dot notation (user.name becomes a column). Download the CSV for Excel.

How do I convert JSON to TypeScript interfaces?

Paste your JSON, select TypeScript. The tool generates interface definitions with proper types. Optional properties are marked with ? symbols.

How do I convert JSON to SQL INSERT statements?

Paste your JSON array, select SQL format. Output is standard INSERT statements compatible with MySQL, PostgreSQL, and SQLite.

How do I convert JSON to YAML?

Paste your JSON, select YAML format. The output preserves structure and is valid YAML for configuration files like docker-compose or Kubernetes.

Can I convert nested JSON to flat CSV?

Yes. Nested objects are flattened with dot notation. {"user":{"name":"John"}} becomes a column named "user.name". Arrays are comma-separated.

What JSON structure works for CSV export?

Arrays of objects work best: [{"name":"A"},{"name":"B"}]. Single objects become one-row CSVs. Complex nesting is flattened.

100% client-side processing - your JSON never leaves your browser.