CSV to JSON

CSV (Comma-Separated Values) is the simplest tabular data format — just rows and columns separated by commas. It's the universal export format for spreadsheets, databases, and analytics tools. But modern APIs and web applications expect JSON, so conversion between the two is one of the most common data tasks.

The first row of a CSV is typically the header row, defining column names. Each subsequent row becomes a JSON object where the keys are the header names and the values are the cell contents. This tool auto-detects data types: numbers become JSON numbers (not strings), "true"/"false" become booleans, and empty cells become null.

CSV parsing has edge cases that trip up naive implementations: values containing commas must be quoted ("New York, NY"), values containing quotes must escape them by doubling (""quoted""), and newlines within quoted values are valid. This tool handles all RFC 4180 edge cases correctly.