CSV to JSON — The Quick Guide

CSV is what humans export from Excel; JSON is what APIs want. Most bugs in that conversion come from three places.

The three CSV gotchas

1. Commas inside quoted fields. "Smith, Jane" is one field, not two. A regex split on commas will corrupt it — use a real parser like our CSV to JSON.
2. Trailing newlines. Excel exports often add a blank last row, which shows up as an empty object in the output. Trim it.
3. Header case. Email, email and EMAIL become three different JSON keys. Normalise before you push.

Type coercion

CSV is all strings. age: "42" and age: 42 are not the same to an API. Decide upfront whether you want the converter to coerce numeric fields, or whether the downstream schema will handle it.

Going the other way

When you need JSON in a spreadsheet, use our JSON to CSV tool. It flattens nested objects with dotted keys so you don't lose structure.