About CSV to JSON conversion
CSV is how spreadsheets, CRMs, and analytics tools export data; JSON is how APIs, JavaScript apps, and configuration files consume it. Converting between them is a daily chore for developers, analysts, and no-code builders seeding a database or mocking an API response.
The converter treats the first row as column names and turns every following row into an object keyed by those names, then prints the whole array with two-space indentation so it is easy to read and diff. It handles quoted fields properly: commas and line breaks inside double quotes stay part of the value, and doubled quotes ("") become a single quote character. Windows line endings are fine, and blank lines are skipped.
There are deliberate limits. The delimiter is a comma only, so semicolon- or tab-separated exports need converting first. Every value comes out as a string — "42" rather than 42, "true" rather than true — so cast types in your code if you need numbers or booleans. Missing cells become empty strings, and you need at least a header row plus one data row. To copy CSV from a spreadsheet, export it as CSV and open the file in a text editor.
How to do it
- Use the button above; the Text tool opens with CSV → JSON highlighted.
- Paste your CSV, making sure the first line holds the column names.
- Click CSV → JSON.
- Review the indented JSON array that replaces your CSV in the box.
- Copy it, or download it and rename the .txt file to .json.
