CSV duplicate remover
Remove duplicate rows from a CSV by any column, then download the cleaned file.
Data & Developer
Beautify, validate or minify JSON. If something is wrong, see the exact line and column.
Private by design — your data stays on your device.
Paste JSON to beautify it with clean indentation, minify it, or check that it is valid. If there is a syntax error, this JSON formatter and validator shows the line and column with a plain-English explanation of what went wrong.
JSON is parsed in your browser. API responses, tokens and configuration you paste here are never uploaded to a server.
A JSON validator checks whether the text follows the JSON standard and reports the first error. A formatter (or JSON beautifier) rewrites valid JSON with consistent indentation. This tool does both: it validates first, then formats.
Trailing commas after the last item, single quotes instead of double quotes, unquoted property names, and comments. All of these are allowed in JavaScript but not in strict JSON.
Paste your JSON and press “Minify”. Spaces, tabs and line breaks outside strings are removed, so the data is identical but the file is smaller.
Formatting only changes whitespace. If you tick “Sort keys”, object keys are reordered alphabetically, which doesn’t change the meaning of JSON. Very large numbers beyond JavaScript’s safe precision may lose digits, as in any browser-based tool.
The tool makes no network requests with your data; everything is processed in the page. As a general habit, though, avoid pasting live secrets into any website you don’t need to.