How to Convert CSV to JSON with Nested Keys and Custom Delimiters

The Problem with Flat CSV to JSON

A typical CSV export has columns like name, contact.email, contact.phone, and address.city. That dot notation is the convention for representing nested fields in a flat row:

name,contact.email,contact.phone,address.city
Alice,alice@example.com,123-456-7890,Beijing
Bob,bob@example.com,,Shanghai

The desired JSON output should group related fields under their parent objects instead of keeping dot-separated keys. A CSV to JSON converter with nested key support handles this automatically.

1. Paste and Parse — The Basic Conversion

Getting started takes 10 seconds:

1. Open the CSV to JSON Converter.
2. Paste your CSV data into the left panel, or upload a .csv file.
3. The tool parses it instantly into an editable table on the right.
4. The JSON output appears below the table, updating in real time.

The result is an array of objects with flat keys. Each CSV row becomes one JSON object:

[
  {
    "name": "Alice",
    "contact.email": "alice@example.com",
    "contact.phone": "123-456-7890",
    "address.city": "Beijing"
  }
]

This works fine for simple cases, but the dot keys aren't ideal for APIs. That's where Unflatten Keys comes in.

2. Enable Unflatten Keys for Nested JSON

Toggle the Unflatten Keys option in the configuration bar. The tool automatically detects dot-separated column headers and nests them into proper JSON objects:

[
  {
    "name": "Alice",
    "contact": {
      "email": "alice@example.com",
      "phone": "123-456-7890"
    },
    "address": {
      "city": "Beijing"
    }
  }
]

This mirrors how APIs typically return data, making it perfect for feeding into databases, REST APIs, or other tools. The preview updates instantly so you can verify the structure before downloading.

3. Handling Different Delimiters

Not all CSV files use commas. The converter supports five delimiter modes:

Select the delimiter from the config bar. The table and JSON output update immediately to reflect the change.

4. Custom Header Row Behavior

By default, the first row is treated as headers and becomes JSON keys. But CSV files vary:

• With Header Row (default): First row = JSON keys, remaining rows = values. You get an array of named objects.
• Without Header Row: All rows become values. The tool auto-generates keys (col_0, col_1, ...) or you can customize them later by editing the table.

Toggle the Header Row checkbox in the config bar. The JSON output changes shape instantly — try it both ways to see which format fits your use case.

5. Pretty vs Compact JSON Output

The converter offers two output formats:

• Pretty: Formatted with indentation — easy to read and debug. Best for humans.
• Compact: Minified single-line JSON. Best for API payloads and storage.

Switch between them with the Output Format dropdown. The right panel preview updates instantly so you can pick the version that fits your pipeline.

Best Practices for CSV to JSON Conversion

• Clean your CSV first. Remove extra whitespace, fix inconsistent quoting, and check for empty rows. Use the JSON to CSV guide for round-trip quality tips.
• Use dot notation for nesting. Name your CSV columns like user.name and user.email, then enable Unflatten Keys. The tool nests them automatically.
• Verify with the live preview. The JSON output updates as you type — check it before downloading. If the structure looks wrong, tweak the config and see the change immediately.
• Match delimiters to your data. If your CSV has commas inside quoted fields (e.g., addresses), switch to Tab or Pipe delimiter to avoid parsing errors.
• For Excel sources, convert to XLSX instead. If you have an Excel file, use Excel to JSON directly — no intermediate CSV conversion needed.

Related Tools

Frequently Asked Questions