Basic Usage

This guide covers the fundamental steps to convert JSON data to CSV format using our converter tool.

Step 1: Input JSON Data

Supported Input Formats

Array of Objects (Most Common):

[
  { "name": "John Doe", "age": 30, "city": "New York" },
  { "name": "Jane Smith", "age": 25, "city": "Los Angeles" },
  { "name": "Bob Johnson", "age": 35, "city": "Chicago" }
]

Single Object:

{
  "name": "John Doe",
  "age": 30,
  "city": "New York",
  "email": "john@example.com"
}

Nested Objects (Automatically Flattened):

[
  {
    "user": {
      "name": "John",
      "contact": {
        "email": "john@example.com",
        "phone": "123-456-7890"
      }
    },
    "status": "active"
  }
]

Step 2: Configure Conversion Options

Delimiter Selection

Choose the character that separates values in your CSV:

• Comma (,): Standard CSV format
• Semicolon (;): European CSV format
• Tab: Tab-separated values (TSV)
• Pipe (|): Pipe-separated values

Encoding Options

Select the character encoding for your output:

• UTF-8: Universal encoding, supports all languages
• UTF-16: Unicode encoding with 16-bit characters
• GBK: Chinese character encoding

Formatting Options

Include Headers:

• ✅ Enabled: First row contains column names
• ❌ Disabled: Data only, no column headers

Escape Quotes:

• ✅ Enabled: Properly escapes quotes in data
• ❌ Disabled: Raw data without quote escaping

Step 3: Review Output

The converted CSV will appear in the output area with:

• Real-time Preview: See results as you type
• Statistics: Row count, column count, and file size
• Error Handling: Clear error messages for invalid JSON

Step 4: Export Results

Copy to Clipboard

Click the "Copy CSV" button to copy the result to your clipboard for pasting into other applications.

Download File

Click the "Download CSV" button to save the file to your computer with a timestamped filename.

Example Conversion

Input JSON:

[
  { "product": "Laptop", "price": 999.99, "category": "Electronics" },
  { "product": "Mouse", "price": 29.99, "category": "Accessories" },
  { "product": "Keyboard", "price": 79.99, "category": "Accessories" }
]

Output CSV (with headers):

product,price,category
Laptop,999.99,Electronics
Mouse,29.99,Accessories
Keyboard,79.99,Accessories

Common Issues and Solutions

Invalid JSON Format

Problem: Red border around input area Solution: Check for missing commas, brackets, or quotes

Empty Output

Problem: No CSV generated Solution: Ensure JSON is valid and contains data

Missing Headers

Problem: No column names in output Solution: Enable "Include Headers" option

Special Characters

Problem: Data appears corrupted Solution: Enable "Escape Quotes" and choose appropriate encoding