# CSV to JSON Converter

> A CSV to JSON converter turns each row of a spreadsheet export into a JSON object keyed by the header row. This one parses quoted fields correctly, so commas and line breaks inside a cell do not break the output, and it runs entirely in your browser.

Source: https://rankcert.com/tools/csv-to-json
Free, no signup. Updated: 2026-09-02

## How to use it

1. Paste your CSV, including the header row.
2. Pick the delimiter if it is not a comma.
3. Copy the JSON array - numbers are converted, everything else stays a string.

## Questions

### How do I convert a CSV to JSON without a script?

Paste it here. For repeated or very large conversions, use a script instead - Python's csv.DictReader and json.dump are four lines.

### Does it handle commas inside quoted fields?

Yes. A field wrapped in double quotes may contain commas, and a doubled quote inside it is treated as a literal quote character, following RFC 4180.

### Why are my numbers turning into strings, or vice versa?

Numeric-looking cells are converted to JSON numbers. That breaks zip codes and phone numbers with leading zeros, so quote those in the source CSV if the leading zero matters.

### What delimiter should I use for European spreadsheets?

Semicolon. Locales that use a comma as a decimal separator export CSV with semicolons, which is why a French or German export looks like one column in an English tool.

### Is my data uploaded?

No. Parsing runs in JavaScript on this page, which matters when the file is a customer export.

### What happens to an empty cell?

It becomes an empty string, not null. Post-process if your schema needs nulls.

### How do I handle nested data?

CSV is flat and cannot express nesting. Convert first, then reshape the flat objects in code - dotted column names like user.name need a second pass.

### Can I go the other way?

Yes - the JSON to CSV converter takes an array of objects and produces the header row and rows back.

## Related tools

- [Diff Checker](https://rankcert.com/tools/diff-checker): Paste two versions of a text and see every added and removed line highlighted, computed in your browser with no upload.
- [JSON to CSV](https://rankcert.com/tools/json-to-csv): Convert a JSON array into a CSV you can open in Excel or Google Sheets, with headers taken from every key that appears.
- [Password Generator](https://rankcert.com/tools/password-generator): Generate strong random passwords in your browser using the Web Crypto API, with an entropy figure so you can see how strong they actually are.
- [JWT Decoder](https://rankcert.com/tools/jwt-decoder): Paste a JSON Web Token to decode its header and payload and read every claim, including expiry. Runs entirely in your browser.
- [JSON Formatter](https://rankcert.com/tools/json-formatter): Format, validate and minify JSON in your browser. Get the exact line and column of a syntax error instead of a vague parse failure.
- [UUID Generator](https://rankcert.com/tools/uuid-generator): Generate cryptographically random UUID v4s, or time-ordered UUID v7s that index far better as database primary keys.