JSON to CSV Converter

What does the JSON to CSV Converter do?

The JSON to CSV Converter parses structured JavaScript Object Notation (JSON) payloads—such as API response arrays or data object dumps—and transforms them into flat, tabular Comma-Separated Values (CSV) spreadsheets. It automatically flattens nested object hierarchies into dot-notation column headers and applies RFC 4180 escaping to quotes and delimiters.

Core Concepts

Understanding JSON to CSV flattening and formatting rules:

• Hierarchical Key Flattening: Nested properties (e.g. {"user": {"location": {"city": "Seattle"}}}) are recursively mapped into dot-notation table column headers (user.location.city).
• Array Flattening: Primitive array items are joined with delimiters, while arrays of objects generate indexed column paths (items[0].name).
• RFC 4180 Escaping: Escapes cell strings containing double quotes (""), commas, and multiline breaks to maintain spreadsheet layout integrity in Microsoft Excel and Google Sheets.

How to use the tool?

1. Paste JSON Data: Paste your JSON array of objects or single JSON data structure into the left editor, click Upload, or click Sample.
2. Choose Delimiter: Select your desired delimiter (Comma, Semicolon for European Excel, Tab for TSV, or Pipe).
3. Copy or Download: Conversions execute instantly in real time. Click Copy CSV or Download to save your .csv spreadsheet.

Related Developer Utilities

If you work with tabular data, spreadsheets, and data transformation, explore these related tools:

• CSV to JSON Converter: Convert tabular CSV files back into structured JSON arrays.
• JSON Formatter & Beautifier: Format and re-indent messy JSON payloads.
• JSON Syntax Validator: Validate JSON syntax and inspect character offsets.
• YAML to CSV Converter: Convert YAML sequence arrays into tabular CSV files.

REST API Integration

blueutils.com provides a free REST API endpoint (POST https://blueutils.com/api/json/to-csv) to programmatically convert JSON arrays or nested objects into RFC 4180 compliant CSV tabular data.

API Request Parameters

API Request Payload Examples

cURL

curl -X POST https://blueutils.com/api/json/to-csv \
  -H "Content-Type: application/json" \
  -d '{
    "rawText": "[{\"id\":1,\"name\":\"Alice\",\"role\":\"Admin\"},{\"id\":2,\"name\":\"Bob\",\"role\":\"Developer\"}]",
    "delimiter": ","
  }'

Python

import requests

url = "https://blueutils.com/api/json/to-csv"
payload = {
    "rawText": '[{"id":1,"name":"Alice","role":"Admin"},{"id":2,"name":"Bob","role":"Developer"}]',
    "delimiter": ","
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.json())

Java

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

public class Main {
    public static void main(String[] args) throws Exception {
        String jsonPayload = """
            {
                "rawText": "[{\\"id\\":1,\\"name\\":\\"Alice\\"},{\\"id\\":2,\\"name\\":\\"Bob\\"}]"
            }
            """;

        HttpClient client = HttpClient.newHttpClient();
        HttpRequest request = HttpRequest.newBuilder()
            .uri(URI.create("https://blueutils.com/api/json/to-csv"))
            .header("Content-Type", "application/json")
            .POST(HttpRequest.BodyPublishers.ofString(jsonPayload))
            .build();

        HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());
        System.out.println(response.body());
    }
}

API Response Parameters

API Response Payload Examples

Success Response (HTTP 200 OK)

{
  "isValid": true,
  "csv": "id,name,role\n1,Alice,Admin\n2,Bob,Developer",
  "rowCount": 2,
  "columnCount": 3
}

Validation Failure Response (HTTP 400 Bad Request)

{
  "isValid": false,
  "error": "Invalid JSON syntax: Unexpected token '}' in JSON (Line 4, Column 1)"
}

Rate Limit Exceeded Response (HTTP 429 Too Many Requests)

{
  "error": "API rate limit exceeded. Please wait or contact support@blueutils.com."
}

Why use an API to convert JSON to CSV?

Integrating the JSON to CSV API into automated ingestion pipelines, ETL tasks, and reporting systems provides key advantages:

• Rapid Script Validation: Enables automated backend pipelines to transform REST API payloads into flat CSV reports for direct business ingestion.
• Optimized Token Efficiency for AI Agents: LLMs struggle with escaping complex CSV quotes and headers. The API flattens JSON trees deterministically without token consumption.
• Deterministic Accuracy Without Hallucinations: Ensures 100% compliant RFC 4180 escaping without dropping rows or misaligning columns.

Native Usage

How to convert JSON to CSV locally in terminal environments or scripts:

Windows (CMD / PowerShell)

# Convert JSON to CSV in PowerShell
Get-Content data.json | ConvertFrom-Json | Export-Csv -Path output.csv -NoTypeInformation

Linux / Unix (Bash)

# Using jq CLI to convert JSON array to CSV
jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv' data.json > output.csv

Python

Using Python standard library csv and json:

import json
import csv

with open('data.json') as f:
    data = json.load(f)

items = data if isinstance(data, list) else [data]
headers = list(items[0].keys())

with open('output.csv', 'w', newline='') as f:
    writer = csv.DictWriter(f, fieldnames=headers)
    writer.writeheader()
    writer.writerows(items)

print("Converted CSV saved.")

Java

Using Jackson (CsvMapper) in Java:

import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.dataformat.csv.CsvMapper;
import com.fasterxml.jackson.dataformat.csv.CsvSchema;
import java.io.File;

public class JsonToCsvExample {
    public static void main(String[] args) throws Exception {
        JsonNode jsonTree = new ObjectMapper().readTree(new File("data.json"));
        CsvSchema.Builder csvSchemaBuilder = CsvSchema.builder();
        JsonNode firstObject = jsonTree.elements().next();
        firstObject.fieldNames().forEachRemaining(csvSchemaBuilder::addColumn);
        CsvSchema csvSchema = csvSchemaBuilder.build().withHeader();

        CsvMapper csvMapper = new CsvMapper();
        csvMapper.writerFor(JsonNode.class).with(csvSchema).writeValue(new File("output.csv"), jsonTree);
        System.out.println("CSV export completed.");
    }
}