What is CSV?
Comma-separated tables exported from Excel, Sheets and databases. Deceptively simple: quoted commas, embedded newlines and encoding marks make naive splitting wrong.
Convert CSV to a JSON array of objects — strict RFC 4180 parsing.
The tool could not be loaded. Check your connection and try again.
Paste CSV text or drop a .csv file — parsed locally in your browser.
The first row becomes object keys; headers must be non-empty and unique.
Copy the resulting JSON array or save it as a .json file.
Strict RFC 4180 parsing: quoted fields, escaped quotes, newlines inside quotes, byte-order marks, and non-empty unique headers. The data must be rectangular — every row the same column count.
All values are kept as strings. "007" stays "007" and leading zeros are never lost. Convert to numbers explicitly in your own code if needed.
Up to 20,000 rows and 128 columns per conversion. Larger files are rejected with a clear message rather than being truncated.
No. Parsing and conversion run entirely in your browser — the file never leaves your device and no account is needed.
Here is what each format is for, and when converting CSV tables into JSON arrays is the right move.
What is CSV?
Comma-separated tables exported from Excel, Sheets and databases. Deceptively simple: quoted commas, embedded newlines and encoding marks make naive splitting wrong.
What is JSON array?
An array of objects, one per row, with header names as keys and every cell preserved as a string — the shape most APIs, scripts and NoSQL stores consume.
When you need it
Use it to feed spreadsheet exports into APIs, scripts and databases. Watch the limits: 20,000 rows and 128 columns, rectangular data required, and numbers stay strings so codes with leading zeros survive intact.