How CSV and JSON Represent Data
CSV stores tabular data as rows and delimited fields, while JSON can represent objects, arrays, numbers, booleans, null values, and nested structures. Conversion is straightforward when each JSON object represents one row and each property represents one column, but delimiters, quoting, missing fields, and nested values require explicit rules.
CSV is tabular
Each record is a row, fields are separated by a delimiter, and the first row often supplies column names.
JSON is structured
Objects contain named properties and may include nested objects or arrays that have no direct one-cell CSV equivalent.
Why Correct CSV Parsing Matters
Splitting every line at each comma breaks valid files when a field contains a comma, quote, or line break. This converter reads CSV character by character, respects quoted fields, converts doubled quotes back to literal quotes, and handles LF and CRLF line endings.
- Quoted commas and selected delimiters remain inside their field
- Two consecutive quotes inside a quoted field become one quote
- Line breaks inside quoted fields are preserved as part of the value
- UTF-8 byte-order marks are removed before parsing
- Uneven rows are reported and missing values become empty strings
- Duplicate headers receive suffixes instead of overwriting data
Converting Nested JSON to Flat CSV
With flattening enabled, a nested property such as an object containing profile and city becomes the CSV column profile.city. This preserves the property path without creating multiple files or tables. Arrays remain JSON strings inside correctly quoted cells.
When records contain different properties, the converter creates a union of all column names in their first-seen order. A record without one of those properties receives an empty field. Review the preview and warning before importing the result into a spreadsheet or database.
CSV Type Inference and Data Safety
CSV has no universal data-type metadata, so every field can reasonably be treated as text. Optional inference converts unambiguous numbers, booleans, and null values to JSON types. Strings with leading zeros remain text to protect values such as postal codes, employee IDs, account references, and product codes.
Always review data before importing it
Spreadsheet applications and databases may independently interpret dates, large numbers, formulas, and identifiers. Check column types and import settings, especially for financial values, dates, scientific notation, and codes that must retain leading zeros.
Private Browser-Based Conversion
The tool reads files and performs conversion in your browser. It does not send CSV or JSON contents to a server. Avoid sharing exported files carelessly, and review sensitive data before copying it into another application.