📊 CSV to JSON Converter

📊 CSV Input

Characters: {{ csvInput.length }}

⚙️ CSV Options

Delimiter:

Text Qualifier:

Escape Character:

🔧 Processing Options

First row contains headers Skip empty rows Trim whitespace from fields

🎯 Output Format

JSON Structure:

Pretty print JSON (formatted)

⚡ Quick Actions

{{ result.isValid ?'✅' :'❌' }} Conversion Status

{{ result.isValid ?'CSV successfully converted to JSON' :'CSV contains errors' }}

🚨 Conversion Errors

⚠️ Warnings

📤 JSON Output

{{ result.json }}

Characters: {{ result.stats.jsonSize }}

📊 CSV Statistics

Rows:
{{ result.stats.rows }}

Columns:
{{ result.stats.columns }}

Empty Rows:
{{ result.stats.emptyRows }}

Headers:
{{ result.stats.headers.join(',') }}

💾 File Size Information

Original CSV: {{ result.stats.originalSize }} chars (~{{ Math.round(result.stats.originalSize / 1024 * 100) / 100 }} KB)

JSON Output: {{ result.stats.jsonSize }} chars (~{{ Math.round(result.stats.jsonSize / 1024 * 100) / 100 }} KB)

{{ result.stats.jsonSize > result.stats.originalSize ?'Increase:' :'Decrease:' }} {{ Math.abs(result.stats.originalSize - result.stats.jsonSize) }} chars

💾 Download Options

⚠️ {{ error }}

ℹ️ About CSV to JSON Converter

CSV to JSON conversion turns delimited spreadsheet exports into structured JSON arrays for APIs, fixtures, scripts, static-site data files, and NoSQL imports. CSV is a row-and-column text format commonly aligned with RFC 4180 and the text/csv media type, while JSON is the lightweight data interchange format standardized in RFC 8259.

Use this converter when you need to move exported rows from Excel, Google Sheets, database query results, log extracts, or product catalogs into JSON that can be pasted into code, sent to an API, checked into a repository, or downloaded as a .json file.

How rows are mapped:

Object Format: the first row can become object keys, so name,age creates records with name and age properties.
Array Format: each record can stay as an ordered array when the CSV has no stable header row.
Custom delimiters: switch between comma, semicolon, tab, and pipe-delimited data.
Quoted fields: quoted commas and escaped quote characters are preserved before JSON output is generated.
Type coercion: simple numbers, true, false, empty fields, and null are converted to JSON values.

Example:

name,age,city
Alice,30,New York
Carol,42,"Portland, OR"

With headers enabled and object output selected, the result is:

[
  {
    "name": "Alice",
    "age": 30,
    "city": "New York"
  },
  {
    "name": "Carol",
    "age": 42,
    "city": "Portland, OR"
  }
]

Practical limitations:

Rows with more or fewer fields than the header are converted, but the tool reports a field-count warning.
Duplicate header names collide in object output because JSON object keys must be unique in practice.
Automatic type coercion can change identifiers such as 00123 into numbers; use array output or review fields when leading zeroes matter.
Multiline quoted CSV fields are not supported by this parser; normalize those records before conversion.

For richer tabular metadata, datatypes, and column constraints beyond plain CSV, see the W3C Model for Tabular Data and Metadata on the Web.

API Usage Example:

POST /api/tools/webdev/csv-to-json
Content-Type: application/json

{
    "csv": "Name,Age,City\nJohn Doe,30,New York\nJane Smith,25,San Francisco",
    "delimiter": ",",
    "enclosure": "\"",
    "escape": "\\",
    "hasHeader": true,
    "outputFormat": "object",
    "prettyPrint": true,
    "skipEmptyRows": true,
    "trimFields": true
}