JSON ⇄ CSV Converter

Convert JSON arrays to CSV format and vice versa online. Custom delimiters, headers, and encoding options. All processing done locally for privacy.

Input (JSON Array)
Loading core...
Output (CSV)
Loading core...

CSV Options

Examples & Usage

Simple Example

Basic JSON array with flat objects

JSON Input:
[
  {
    "name": "John Doe",
    "age": 30,
    "email": "john@example.com",
    "city": "New York"
  },
  {
    "name": "Jane Smith", 
    "age": 25,
    "email": "jane@example.com",
    "city": "Los Angeles"
  },
  {
    "name": "Bob Johnson",
    "age": 35,
    "email": "bob@example.com",
    "city": "Chicago"
  }
]
CSV Output:
name,age,email,city
John Doe,30,john@example.com,New York
Jane Smith,25,jane@example.com,Los Angeles
Bob Johnson,35,bob@example.com,Chicago

Nested Objects Example

Complex JSON with nested objects and arrays

JSON Input:
[
  {
    "id": 1,
    "name": "Alice Johnson",
    "contact": {
      "email": "alice@example.com",
      "phone": "+1-555-0123",
      "address": {
        "street": "123 Main St",
        "city": "New York",
        "zipCode": "10001"
      }
    },
    "skills": ["JavaScript", "React", "Node.js"],
    "experience": 5
  },
  {
    "id": 2,
    "name": "Bob Smith",
    "contact": {
      "email": "bob@example.com", 
      "phone": "+1-555-0456",
      "address": {
        "street": "456 Oak Ave",
        "city": "San Francisco",
        "zipCode": "94102"
      }
    },
    "skills": ["Python", "Django", "PostgreSQL"],
    "experience": 3
  }
]
CSV Output:
id,name,contact.email,contact.phone,contact.address.street,contact.address.city,contact.address.zipCode,skills,experience
1,Alice Johnson,alice@example.com,+1-555-0123,123 Main St,New York,10001,"JavaScript,React,Node.js",5
2,Bob Smith,bob@example.com,+1-555-0456,456 Oak Ave,San Francisco,94102,"Python,Django,PostgreSQL",3

Array Examples

JSON with arrays and mixed data types

JSON Input:
[
  {
    "product": "Laptop",
    "price": 999.99,
    "categories": ["Electronics", "Computers"],
    "specs": {
      "cpu": "Intel i7",
      "ram": "16GB",
      "storage": "512GB SSD"
    },
    "tags": ["gaming", "professional", "portable"],
    "inStock": true,
    "ratings": [4.5, 4.8, 4.2, 4.9, 4.6]
  },
  {
    "product": "Smartphone",
    "price": 699.99,
    "categories": ["Electronics", "Mobile"],
    "specs": {
      "cpu": "Snapdragon 888",
      "ram": "8GB", 
      "storage": "256GB"
    },
    "tags": ["5G", "camera", "battery"],
    "inStock": false,
    "ratings": [4.3, 4.1, 4.7, 4.4, 4.8]
  }
]
CSV Output:
product,price,categories,specs.cpu,specs.ram,specs.storage,tags,inStock,ratings
Laptop,999.99,"Electronics,Computers",Intel i7,16GB,512GB SSD,"gaming,professional,portable",true,"4.5,4.8,4.2,4.9,4.6"
Smartphone,699.99,"Electronics,Mobile",Snapdragon 888,8GB,256GB,"5G,camera,battery",false,"4.3,4.1,4.7,4.4,4.8"

Frequently Asked Questions

What is JSON?

JSON (JavaScript Object Notation) is a lightweight, text-based data format for structured data exchange widely used in web and API communication.

What is CSV?

CSV (Comma-Separated Values) is a plain text format for tabular data, often used in spreadsheets or databases.

What's the difference between JSON and CSV?

JSON handles complex, hierarchical data, while CSV is ideal for flat tables viewable in Excel or Google Sheets.

Why convert JSON to CSV?

It makes structured data easy to view, edit, and analyze in spreadsheets.

How to convert JSON to CSV for free?

Use JsonWork's free online converter. Upload or paste JSON, click "Convert to CSV," and download instantly.

Can I convert CSV back to JSON?

Yes, JsonWork supports both JSON→CSV and CSV→JSON conversions.

Can I paste JSON directly?

Yes, paste your JSON text to auto-parse and convert.

Does it support file upload?

Yes, you can upload `.json` files directly.

Can it convert large JSON files?

Yes, it handles large and complex JSON efficiently.

Can it handle nested JSON?

Yes, nested structures are flattened automatically for easy use.

Is there a file size limit?

Usually no issue, but very large files depend on browser memory.

How to use with URL?

Enter a JSON file URL and click "Load from URL."

Is it safe?

Absolutely — everything runs locally in your browser with no uploads.

Is login required?

No login needed; all operations are local.

Can I edit the CSV after conversion?

Yes, open it in Excel or Google Sheets for editing.

Can I import CSV into Excel?

Yes, all generated CSVs are Excel-compatible.

Do I need to install software?

No installation needed; JsonWork runs online.

What if conversion fails?

Check JSON validity with a validator before retrying.

What formats are supported?

Currently supports JSON↔CSV; more formats coming soon.

✅ Local Processing - Data Never Leaves Your Browser

ヘルプが必要ですか?