How to Convert CSV to JSON: Complete Guide

# How to Convert CSV to JSON: Complete Guide

Converting CSV to JSON is essential for modern web development, API integrations, and data processing. This guide covers everything you need to know.

## Why Convert CSV to JSON?

### CSV Limitations
- No nested data structures
- Type information lost (everything is text)
- No standard for arrays or objects
- Difficult to represent hierarchical data

### JSON Advantages
- Native JavaScript support
- Handles nested objects/arrays
- Preserves data types (numbers, booleans, null)
- Human-readable and machine-parseable
- Standard format for APIs

## Basic Conversion Example

**CSV Input:**
```csv
name,age,city
John,30,New York
Jane,25,London
```

**JSON Output:**
```json
[
{"name": "John", "age": 30, "city": "New York"},
{"name": "Jane", "age": 25, "city": "London"}
]
```

## Conversion Methods

### Online Converters
Benefits:
- No coding required
- Instant results
- Handle large files
- Preview output
- Download or copy results

### Programming Solutions

**JavaScript/Node.js:**
```javascript
const csv = `name,age,city
John,30,New York
Jane,25,London`;

const lines = csv.split('\n');
const headers = lines[0].split(',');
const result = lines.slice(1).map(line => {
const values = line.split(',');
return headers.reduce((obj, header, i) => {
obj[header] = values[i];
return obj;
}, {});
});

console.log(JSON.stringify(result, null, 2));
```

**Python:**
```python
import csv
import json

with open('data.csv') as f:
reader = csv.DictReader(f)
rows = list(reader)

with open('output.json', 'w') as f:
json.dump(rows, f, indent=2)
```

## Advanced Scenarios

### Type Conversion
Convert strings to appropriate types:
```javascript
function convertType(value) {
if (value === 'true') return true;
if (value === 'false') return false;
if (value === 'null') return null;
if (!isNaN(value) && value !== '') return Number(value);
return value;
}
```

### Quoted Fields
Handle fields containing commas:
```csv
"Smith, John",30,"New York, NY"
```

Use a proper CSV parser library.

### Nested Objects
Transform flat CSV to nested JSON:
```csv
user.name,user.age,user.city
John,30,New York
```

→

```json
{
"user": {
"name": "John",
"age": 30,
"city": "New York"
}
}
```

## Common Issues

### Commas in Data
Use quotes or escape characters.

### Line Breaks in Fields
Ensure proper quote handling.

### Character Encoding
UTF-8 is standard for JSON.

### Large Files
Stream processing for files > 100MB.