JSON Formatter & Beautifier
Pretty-print JSON with your choice of indentation and optional key sorting. Errors are shown with line and column.…
JSON to CSV Converter
Convert JSON arrays into CSV for spreadsheets. Nested objects become dot-separated columns, and you can choose the delimiter.
How to use
- Paste a JSON array of objects (or a single object).
- Choose the delimiter: comma, semicolon or tab.
- Download the CSV and open it in your spreadsheet app.
What this tool does
Every key found in any object becomes a column. Nested objects are flattened (address.city), arrays of simple values are joined with a pipe, and cells containing the delimiter, quotes or line breaks are quoted correctly.
Tips
- Use semicolons if your spreadsheet uses commas as decimal separators.
- Turn on formula protection before opening data from untrusted sources in Excel.
Frequently asked questions
What does "protect against formulas" do?
Cells that start with =, +, - or @ are prefixed with an apostrophe so spreadsheet apps show them as text instead of running them.
Related tools
JSON Validator
Check whether JSON is valid and find the exact line and column of any syntax error.
Remove Duplicate Lines
Delete repeated lines from any list, with options to ignore case and surrounding spaces, remove empty lines and…
UUID Generator (v4)
Generate one or up to 1,000 random v4 UUIDs at once, with uppercase, no-hyphen and brace options.
URL Encoder / Decoder
Encode or decode URLs and query values with percent-encoding, and inspect a URL's host, path and parameters.
Unix Timestamp Converter
Convert Unix epoch timestamps to readable dates in UTC and your local time zone, or turn a date…
Regex Tester
Test JavaScript regular expressions against your text with highlighted matches, capture groups and a live replace preview.
JSON Minifier
Remove all unnecessary whitespace from JSON and see how many bytes you save.