What is CSV to JSON conversion?

CSV (Comma-Separated Values) is a flat tabular format, while JSON (JavaScript Object Notation) is a hierarchical structured format. Converting CSV to JSON transforms each row into a JSON object, using the header row as keys. This makes the data ready for use in web applications, APIs, and NoSQL databases that expect structured JSON input.

// JavaScript — CSV to JSON
function csvToJson(csv) {
  const [headerLine, ...rows] = csv.trim().split('\n');
  const headers = headerLine.split(',');
  return rows.map(row => {
    const values = row.split(',');
    return Object.fromEntries(headers.map((h, i) => [h, values[i]]));
  });
}

# Python — CSV to JSON
import csv, json, io
reader = csv.DictReader(io.StringIO(csv_string))
result = json.dumps(list(reader), indent=2)

Common use cases for CSV to JSON conversion

Developers convert CSV to JSON when importing spreadsheet data into web applications, loading data into MongoDB or other document databases, creating API mock data, or building data visualizations with JavaScript libraries like D3.js or Chart.js. It is also useful for transforming data exports from tools like Excel or Google Sheets.