Keep CSV Values Intact When Converting to JSON
Convert CSV headers and rows into JSON objects while preserving leading zeros and large identifiers as strings.
Check the header row
The first row provides object property names. Give each column a unique, non-empty name before conversion. A repeated header could otherwise overwrite a value, so the converter rejects it and asks you to fix the input.
Let quotes protect field boundaries
A comma inside a quoted field is part of the value. Two quotes inside a quoted field represent one literal quote. A line break inside quotes also belongs to the cell. The parser handles these cases instead of splitting the text blindly at commas.
Keep automatic type guessing out
A product code such as 0012 is not necessarily the number twelve. All values remain strings, which also protects large identifiers. If your application needs typed values, convert specific columns using explicit rules after inspecting the JSON.
Resolve uneven rows
Each data row must contain the same number of fields as the header. A missing trailing delimiter, an unmatched quote or the wrong separator can cause a mismatch. The error identifies the data row so you can inspect the original export.
Put it into practice
JSON to CSV Converter
Turn a JSON array of objects into CSV, with quoted fields and optional spreadsheet formula protection.
Developer toolsCSV to JSON Converter
Convert CSV headers and rows into JSON objects while preserving leading zeros and large identifiers as strings.
Developer toolsJSON Pointer Lookup
Select a value from a JSON document using a standard slash-separated JSON Pointer.
Developer toolsCSV to HTML Table
Generate escaped HTML table source from CSV, including column headers and a simple semantic structure.
Developer tools