How to use this tool
- Enter csv with column headers.
- Select Update result to view the result.
- Check the method and assumptions below before using the result.
The method, explained
Read quoted fields, escaped double quotes and line endings. Use unique column headers as object keys and preserve every cell as a string.
name,score followed by Alex,95 becomes an object with name "Alex" and score "95" inside a JSON array.
What to keep in mind
Comma delimiter only; headers must be nonempty and unique. Every data row must match the header width. Up to 100,000 input characters. Numbers remain strings to preserve leading zeroes.
Reference: RFC 4180: comma-separated values
Common questions
Can a cell contain a comma or line break?
Yes, if the cell is surrounded by double quotes. A double quote inside such a cell must be doubled.
Will 00123 become 123?
No. All cell values stay strings, preserving identifiers and leading zeroes.
Methodology maintained by ClarityKit. How these tools are built and checked.