JSON to SQL Insert
Turn an array of JSON records into INSERT statements, with an optional CREATE TABLE.
Beautify, minify and validate JSON with precise error locations.
The JSON Formatter beautifies, minifies and validates JSON in your browser. Paste a minified or malformed payload and get it back readable, or get the exact line and column where parsing failed — which is usually a trailing comma or an unquoted key.
Paste minified or malformed JSON and get it back readable. The formatter re-indents with two or four spaces or tabs, can sort object keys alphabetically, and minifies back to a single line when you need the smallest possible payload.
Validation is the part that saves the most time. When the parser rejects your input, the error message is reported with the line and column where parsing failed, so you can jump straight to the trailing comma or unquoted key instead of scanning the whole document. Statistics below the output show the size before and after, plus the number of keys and the maximum nesting depth.
When the parser rejects your input it reports the line and column, so you jump straight to the problem instead of scanning the document.
Re-indent with two spaces, four spaces or tabs to match whatever the rest of your project uses.
Collapse the whole document back to a single line when size on the wire is what matters.
Optional key sorting makes two versions of the same object easy to compare by eye.
Size before and after, the number of keys and the maximum nesting depth are reported under the output.
Drop in an API response, a config file or any JSON string, however badly formatted.
Choose an indentation width and click Format, or click Minify to strip all whitespace.
If the JSON is invalid, the line and column of the failure are shown so you can correct it.
Copy the result to your clipboard or download it as a .json file.
The usual causes are a trailing comma after the last item, keys or strings wrapped in single quotes instead of double quotes, or unescaped line breaks inside a string. The error message points at the exact position.
No. Parsing and formatting happen in your browser, so API keys and customer data inside a payload never leave your machine.
Documents of a few megabytes format fine on a normal machine. Beyond that the browser may become briefly unresponsive while parsing.
Formatting adds indentation and line breaks so a human can read the structure. Minifying removes every optional character to make the payload as small as possible for transmission.
What people who use the JSON Formatter think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
0 reviews
Newest first
No reviews yet
Be the first to rate the JSON Formatter. It takes half a minute and no account.
Write the first reviewTurn an array of JSON records into INSERT statements, with an optional CREATE TABLE.
Generate prefixed API keys in the format modern providers use.
Parse Set-Cookie and Cookie headers, and check the security flags.
Generate a CI workflow with caching, a version matrix and the right permissions.
Build a valid package.json with scripts, exports and metadata.
Turn a URL query string into structured JSON, including nested and repeated keys.
Turn text, SVG or a small file into a data: URI you can inline anywhere.
Reformat a MAC address between every notation, and decode what it means.