Skip to content
Get a Free Audit

JSON formatter, validator and repair tool

Format, validate and fix JSON with clear error messages that show the exact line. View it as a tree or table, and convert to CSV, YAML or TypeScript. Your data stays in your browser.

This tool needs JavaScript. Please turn it on, or open the page in a current browser.

How to use this tool

  1. Paste or open your JSON Paste JSON into the left box, open a .json file, or try the sample.
  2. Read the error, if any If the JSON is broken, you see the line, the column and what to fix, in plain words. “Go to error” jumps there.
  3. Repair or format Click Repair to fix common mistakes like single quotes, missing commas or comments. Click Format to tidy it.
  4. Explore the data Switch to Tree to fold and unfold, or Table to see a list of records as rows. Copy any path.
  5. Convert and download Get CSV for Excel, YAML for config files, or TypeScript types for code. Copy or download.

JSON rules people often miss

  • Keys and text need double quotes: "name": "Priya".
  • No comma after the last item, and no comments.
  • Use true, false and null in lower case.

Safe sharing

  • Remove passwords, API keys and tokens before sharing JSON. This tool warns you when it sees them.
  • Do not paste customer data (phone numbers, Aadhaar, PAN) into online tools that upload it. This one does not upload anything.
  • Long ID numbers stay exact here; some tools round them.

Good to know

  • Repair guesses what you meant. Always check the result.
  • Duplicate keys are allowed by some parsers but the last one wins; we warn about them.
  • CSV cells that start with =, +, - or @ get a quote mark so Excel does not run them as formulas.

Questions about this tool

How do I find the error in my JSON?

Paste it in. The tool shows the line and column, explains the problem in plain words, and “Go to error” moves the cursor there.

Can it fix broken JSON?

Yes. Repair fixes comments, single or curly quotes, unquoted keys, extra or missing commas, True/False/None and unclosed brackets.

Will big numbers like order IDs change?

No. Numbers are kept exactly as written, even very long ones.

Can I convert JSON to Excel?

Yes. Choose CSV and download. Excel opens it directly. Nested fields become columns like address.city.

Is my JSON sent to a server?

No. Everything runs in your browser, and nothing is saved.