Format Converter
Convert between CSV, JSON, YAML and XML, and inspect the data before you ship it: preview rows, inferred column types, missing values, and distinct counts.
How to convert CSV to JSON (and back)
- Paste your data, drop a file onto the input, or click Open file. The input format is detected automatically; override it if needed.
- Check the Table view and the Profile panel: inferred column types, missing values, and distinct counts help you catch bad rows before converting.
- Pick an output format (JSON, JSON Lines, CSV, TSV, YAML or XML), then copy it or click Export to download.
How types are inferred
Each column is scanned and given the narrowest type that fits every non-empty value: int64, decimal, boolean, date, timestamp, or string. A ? marks a column with missing values. With Convert numbers and booleans on, values are written to JSON and YAML as real numbers and booleans rather than strings. Values such as ZIP codes with leading zeros stay strings.
Nested data
Converting nested JSON, YAML, or XML to CSV flattens objects into dotted column names (for example address.city) and stores arrays as JSON text in the cell. Converting between JSON, YAML, and XML keeps the full structure.
Frequently asked questions
Is my file uploaded anywhere?
No. Files are read and converted in your browser. Nothing is sent to a server, so it's safe to use with internal or customer data.
How large a file can I convert?
Files of tens of megabytes work in most browsers. The table preview shows the first 200 rows, while the conversion and profile use every row.
Which CSV dialects are supported?
Comma, semicolon, tab and pipe delimiters, detected automatically. Quoted fields with embedded delimiters, quotes (doubled as "") and line breaks follow RFC 4180.
How is XML mapped to JSON?
Elements become keys, repeated elements become arrays, attributes are stored with an @ prefix, and mixed text content is stored under #text.