JSON Tool Guide
Paste JSON on the left, or click "Import" / drag a .json file onto the page
Click "Format / Validate / Minify / Sort keys" — the result and status show instantly on the right
Click "Copy" to save the result, or "To Excel / CSV / XML" to export other formats
✅What this tool does
- Format & minify: beautify the layout or collapse to one line to save space
- Validate & locate errors: shows the reason and the exact line/column, with jump & fix
- Sort keys & convert: shallow/deep key sort, export to Excel, CSV, XML
💡Tips
- When converting to Excel/CSV, an array of objects expands into rows with columns from each field
- Nested objects or arrays are placed into cells as JSON strings to avoid breaking the table
- Validation errors are usually a trailing comma, a missing quote or unbalanced brackets — try "Fix errors"
JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy to read and write, widely used in web development, API debugging and config storage. This tool formats, validates and converts JSON fast.
🔒 Runs entirely locally in your browser, nothing is uploaded; supports format, validate & locate, minify, key sort and Excel/CSV/XML export — no install, no signup.