Turn a spreadsheet export into JSON, with quoted fields, custom delimiters and automatic type detection.
Quoted fields may contain the delimiter, line breaks and doubled quotes.
Drop in an export from Excel, Google Sheets or a database dump. Quoted fields containing commas or line breaks are handled correctly, so exports do not need cleaning first.
Choose the delimiter your file uses, say whether the first row is a header, and decide whether numbers and booleans should become real JSON types instead of strings.
The output updates as you type and is formatted with your chosen indentation. The row count next to the label tells you how many records were read.
No. Parsing happens in your browser in JavaScript. That matters because spreadsheet exports often contain customer records, and nothing here is sent anywhere or stored.
Yes. Fields wrapped in double quotes may contain the delimiter, line breaks and escaped quotes written as two double quotes. This is the part naive converters get wrong.
It should not. Type detection only converts plain numbers, so a value like 007 stays a string. If you still want everything as text, turn type detection off.
Turn off the header option and each row becomes an array of values instead of an object, keeping the original column order.
Comma, semicolon, tab and pipe. Semicolon is the usual choice in locales where the comma is the decimal separator, including Turkish Excel exports.
There is no hard limit, but everything is held in memory and reformatted on each keystroke, so very large exports will feel slow in a browser tab.
They become an empty string. With type detection on, a literal null in the cell becomes JSON null.
Yes, completely free with no sign-up, like every tool in the Pinkontin developer toolbox.
Flatten JSON into spreadsheet columns using dot paths, then copy it or download the file.
Open ToolFree online JSON formatter and validator. Format, minify and validate JSON with syntax highlighting and instant error detection.
Open ToolGenerate TypeScript interfaces from a JSON payload, with named interfaces for nested objects.
Open Tool