CSV JSON Converter
Choose CSV → JSON or JSON → CSV, paste your data, and convert. CSV mode treats the first row as headers and builds an array of objects; JSON mode expects that same shape and writes CSV back out.
Updated 2026-08-04 · developer
Choose direction, paste data, then Convert.
About this tool
Spreadsheets and APIs often speak different formats. CSV is compact for Excel and Sheets; JSON arrays of objects fit web apps and scripts. This converter uses Papa Parse for CSV and standard JSON parsing for the reverse path, with dynamic typing so numeric cells can stay numbers.
How to use
- Pick a direction: Select CSV → JSON or JSON → CSV.
- Paste input: Replace the sample with your table or JSON array.
- Convert: Click Convert and read the status message.
- Copy output: Use Copy output or select the output box when conversion succeeds.
Common use cases
- Turn an export from Sheets into JSON for a mock API.
- Flatten an array of records into CSV for stakeholders.
- Clean a small dataset before importing it into another tool.
- Show how columns map to object keys when teaching data basics.
Tips
- JSON → CSV needs a JSON array of objects with consistent keys; nested objects will not flatten automatically.
- Empty CSV lines are skipped. Read the status line if parsing fails.
FAQ
Must CSV have a header row?
Yes for CSV → JSON. Headers become object keys.
What JSON shape is required?
An array of objects. A single object or nested tree will error.
Are numbers kept as numbers?
CSV → JSON uses dynamic typing, so numeric cells become JSON numbers when detected.
Does conversion leave my machine?
Parsing runs in the browser with your pasted text.