Skip to content
bobob

CSV JSON Converter

Convert CSV rows to JSON arrays, JSON arrays back to CSV, and clean messy spreadsheet exports.

Runs in your browserNothing you type is sent to a server.

Input and result

What you type is kept in this browser only. Reopen to restore your last run.

Use cases

  • Convert or clean spreadsheet exports and API fixtures.
  • CSV JSON Converter for data workflows

Examples

Common input
id,name 1,Bob
Convert or clean spreadsheet exports and API fixtures.
Typical output
[{"id":"1","name":"Bob"}]
Use this as a quick sanity check before copying results.
Messy export
id , name , status 1 , Bob , active 1 , Bob , active
Trims cells and exposes duplicate rows before conversion.
API fixture
[{"id":"1","name":"Bob"},{"id":"2","name":"Alice"}]
Converts small JSON arrays into a CSV preview for docs or QA.

Common mistakes

  • CSV JSON Converter can still fail when the pasted input shape differs from id,name,role 1,Bob,admin 2,Alice,editor.
  • The output should be reviewed in the target data workflow before reuse.
  • Browser-local processing does not make sensitive production data safe to paste.

Before you copy

  1. 1Compare the output against the original input before copying.
  2. 2Remove secrets, customer data, and one-off environment values.
  3. 3Continue with json-formatter if the result needs another validation step.

Sources

  • Any field with a comma, quote or newline must be quoted

    RFC 4180 requires such a field to be wrapped in double quotes, with inner quotes doubled. Skip it and every column shifts from that row on - the usual cause when an address or notes column corrupts a file.

    Basis: RFC 4180

  • CSV records are separated by CRLF

    RFC 4180 specifies CRLF line endings. LF-only files usually parse, but mixed with newlines inside quoted fields a parser can mistake where a record ends and your row count changes.

    Basis: RFC 4180

  • JSON is UTF-8 and carries no BOM

    RFC 8259 says JSON exchanged between systems is encoded in UTF-8 and implementations must not add a byte order mark. Carry over the BOM Excel writes and your first key name gains an invisible character, so lookups miss.

    Basis: RFC 8259

FAQ

Does CSV JSON Converter upload my input?

No. This tool runs in your browser unless the privacy badge explicitly says a server route is required.

Can I use this for production secrets?

Avoid pasting sensitive production data into any website. Prefer local test data or redacted payloads.

What gets lost when CSV becomes JSON?

CSV is flat table data, so nested objects, arrays, types, and empty values need explicit review after conversion.

When should I clean before converting?

Clean when copied spreadsheet rows include extra spaces, blank rows, duplicate records, or uneven columns.