JSON ↔ CSV Converter

Transform data between JSON (JavaScript Object Notation) and CSV (Comma Separated Values) instantly.
Secure client-side conversion. No data is sent to server.

Delimiter:

Headers

JSON

CSV

How to Use This Converter

This tool simplifies data migration between web applications (JSON) and spreadsheet software like Excel or Google Sheets (CSV).

JSON to CSV

Paste your JSON data into the left panel. It should be an array of objects (e.g., [{"a":1}, {"a":2}]).
Select your preferred delimiter (Comma, Semicolon, etc.).
Click "JSON to CSV".
Copy the result from the right panel to paste into Excel.

CSV to JSON

Paste your CSV data into the right panel. Ensure the first row contains headers.
Match the delimiter setting to your CSV format.
Click "CSV to JSON".
Use the generated JSON in your API or application.

Code Examples: Converting JSON to CSV

Need to perform this conversion programmatically? Here is how to do it in popular languages.

JavaScript (Node.js/Browser)ES6

const data = [
  { id: 1, name: "Alice" },
  { id: 2, name: "Bob" }
];

// Extract headers
const headers = Object.keys(data[0]);

// Map rows
const csv = [
  headers.join(','), // Header row
  ...data.map(row => headers.map(fieldName =>
    JSON.stringify(row[fieldName], (key, value) => value === null ? '' : value)
  ).join(','))
].join('\r\n');

console.log(csv);

Pythonpandas

import pandas as pd

# JSON string or file
json_data = '[{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}]'

# Read JSON
df = pd.read_json(json_data)

# Convert to CSV
csv_data = df.to_csv(index=False)

print(csv_data)

PHPNative

$json = '[{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}]';
$array = json_decode($json, true);

$fp = fopen('php://memory', 'w');

// Write headers
fputcsv($fp, array_keys($array[0]));

// Write rows
foreach ($array as $row) {
    fputcsv($fp, $row);
}

rewind($fp);
echo stream_get_contents($fp);
fclose($fp);

Go (Golang)encoding/csv

package main

import (
    "encoding/csv"
    "encoding/json"
    "os"
    "strconv"
)

type User struct {
    ID   int    `json:"id"`
    Name string `json:"name"`
}

func main() {
    jsonData := `[{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}]`
    var users []User
    json.Unmarshal([]byte(jsonData), &users)

    w := csv.NewWriter(os.Stdout)
    w.Write([]string{"id", "name"}) // Headers

    for _, user := range users {
        w.Write([]string{strconv.Itoa(user.ID), user.Name})
    }
    w.Flush()
}

Common Use Cases

Data Analysis: Convert JSON API responses into CSV format to open them in Microsoft Excel, Google Sheets, or Tableau for visualization and analysis.
Database Migration: Many SQL databases (MySQL, PostgreSQL) allow bulk importing data via CSV files. This tool helps prepare NoSQL data (MongoDB export) for SQL import.
Report Generation: Developers often need to generate CSV reports for business users from internal JSON data structures.

Frequently Asked Questions

Is my data safe?

Yes, absolutely. The conversion happens entirely in your browser using JavaScript. No data is ever sent to our servers.

How do you handle nested JSON objects?

In this simple converter, nested objects are stringified (converted to text) to fit into a single CSV cell. For complex flattening, specialized ETL tools are recommended.

Can I convert large files?

Yes, since it works in your browser, the limit depends on your computer's RAM. Files up to 10-50MB usually process instantly.