CSV to JSON

What this tool does

Papa Parse reads the CSV with RFC 4180-style quoting. The first row becomes object keys. Values stay strings so leading zeros in postal codes and IDs are not turned into numbers.

How to use it

1. Paste CSV or drop a .csv file.
2. Confirm the JSON array looks right, especially quoted cities and multiline notes.
3. Copy or download converted.json.

Privacy

This tool processes files and text locally in your browser. Your content is not uploaded or stored by this site.

ConvertPass does not include your input in analytics, URLs, or error reports. Encoding: UTF-8. A BOM is stripped. Legacy Windows-1252 files may need conversion in your editor first.. Limit: 2 MB (2.00 MB).

Limitations

• Numbers are not auto-typed. "007" stays "007".
• A header row is required for object keys. Arrays-of-arrays input should stay in the JSON to CSV direction.

Example

"name","note"
"Ada","Invented, among other things, a programme"
"Alan","Break
line"

[
  {
    "name": "Ada",
    "note": "Invented, among other things, a programme"
  },
  {
    "name": "Alan",
    "note": "Break\nline"
  }
]

Troubleshooting

Keys look like _col1 or are empty

The first row may not be a header, or the delimiter is a semicolon. Convert delimiters in a text editor, then paste again.

A parser error names a row

An unmatched quote is the usual cause. Open the CSV in a plain-text editor and look at that row.

FAQ

Why keep every value as a string?

Auto-typing turns 10/12 into a date in some tools and 00123 into 123. For a converter, strings are the honest default. Parse numbers in your application when you know the column type.

Does it support TSV?

If the file is tab-separated, Papa can often detect it. If detection fails, replace tabs with commas only after checking that fields do not already contain commas.

Will my spreadsheet formulas come through?

CSV is values, not formulas. What you see is whatever the spreadsheet exported, not the original formula text unless you chose that export option.

How are blank lines handled?

Greedy skip removes empty lines. A row of empty quoted fields is still a row.