Last reviewed August 23, 2026

How to Convert CSV to JSON Without Losing IDs

Convert CSV rows into JSON objects or arrays while preserving text values, leading zeros, quoting, and header meaning.

Choose objects or arrays intentionally

An array of objects uses header names as keys and is convenient for APIs and code. An array of arrays preserves the tabular shape directly and can represent a file without unique headers.

Convert and review

Load CSV, choose the correct delimiter and header mode, then select objects or arrays and pretty or minified output. Review the exact JSON before downloading converted.json.

Why values remain strings

CSV has no reliable universal type system. OpenFileTools preserves 001, postal codes, long identifiers, date-looking text, and boolean-looking words as strings instead of guessing and changing their meaning.

Headers and generated column names

Object mode requires unique non-conflicting keys. With no header row, deterministic names such as column_1 and column_2 are generated. Empty header cells receive the same style of generated name.

Common conversion failures

Unterminated quotes, excessive input, and duplicate object header names are rejected with explanations. If automatic delimiter detection is ambiguous, select the delimiter explicitly before converting.

  • Pretty JSON is easier to inspect but larger.
  • Minified JSON contains the same parsed values.
  • JSON syntax does not prove a downstream schema is satisfied.
Try the browser tool

Work with your file locally.

Open CSV to JSON