CSV Header Mapper to JSON Schema
Use CSV header positions to define JSON Schema Draft 2020-12 properties. Set scalar types and empty-cell behavior, then check the data rows before exporting schema and JSON.
Validate CSV Rows Against Mapped JSON Types
CSV Header Mapper to JSON Schema: how to use it
- Open or paste CSV with a header record. Select its delimiter and choose Read columns.
- Review property names and choose string, integer, number or Boolean. Set required and null handling for each column.
- Choose Build and validate. Fix the indicated records or mapping choices, then download the schema and any fully validated mapped rows.
Limits and notes
Reads up to 1,000,000 UTF-16 code units, 128 columns, 10,000 data records and 250,000 parsed cells. The schema describes one row. Integer cells need a safe JSON integer with no leading zeros. Number cells must round-trip without losing digits. Each optional blank cell is omitted unless Null for empty is selected. Defines four scalar types, with optional null.
How your privacy works →CSV Header Mapper to JSON Schema: common questions
How do I preserve 0012 or a large order number?
Keep the column as string. Numeric types would change the leading zeros or reject digits that cannot be represented exactly.
Does the JSON Schema validate raw CSV text?
The schema describes the JSON object produced from each mapped data record. Validate the exported JSON objects individually.
What happens if two headers share a name?
The mapping uses column position. Give the two resulting JSON properties distinct names before you build the schema.