Free JSON Tools
Format, Compare And Convert
These free JSON tools format, view, compare and convert data, from CSV and XML to YAML and SQL. Paste it in, and it stays in your browser.
- 26JSON tools
- Not neededAccount
- NoneAds
- NoneUploads
What These JSON Tools Do
Data comes back from APIs, config files and exports in many shapes. So these JSON tools start by reading it. The formatter makes it tidy, the viewer shows it as a tree, and the diff tool marks what changed between two versions.
Then the converters move data between formats. For example, you can turn an API reply into CSV for a spreadsheet, into XML or YAML for a config file, or into typed code for your app. The CSV, XML and YAML tools also work the other way round.
Finally, a few tools help you test. The path tester picks values out of a big document, and the XPath tester does the same for XML. Because every tool runs in your browser, the data you paste never leaves your computer.
Spreadsheets have a place here too. The CSV viewer opens a file as a table you can edit, and the Excel converter reads and writes real workbooks. In addition, the SQL formatter tidies a long query, and the CSV to SQL tool turns rows into insert statements. So a file can go from an export to a database without a script.
Which JSON tool fits your job? If a file will not load, start with the formatter, because it finds the mistake. If two files should match, use the diff tool. And if a team needs the data in a sheet, convert it to CSV and open it in Excel.
These tools also suit people who do not write code every day. For instance, a marketer can turn an API export into a sheet, and a support agent can check that a settings file is valid before sending it on. No install, no account and no command line are needed.
More free tool categories
All Free JSON Tools On This Page
Data formats first, then CSV, XML, YAML and SQL. Open any card to start.
JSON and data tools
Format, check and convert JSON, CSV, XML, YAML and SQL. Your data never leaves the tab.
- JSON Formatter
Beautify or minify JSON, and see the exact line and column of any mistake it contains.
- JSON Viewer
Read JSON as a tree or a table, search it, copy paths and edit values.
- JSON Stringify
Stringify, escape, URL-encode or Base64 JSON, and undo each one.
- JSON Diff
Compare two JSON, XML or YAML documents and list every change.
- JSONPath Tester
Run a JSONPath on your JSON and see every match with its path.
- JSON to Code Converter
Turn a JSON sample into classes for C#, Java, TypeScript and six more.
- Excel Converter
Open an Excel file and convert it to JSON, CSV or XML, or build a workbook from your data.
- JSON to HTML Table Converter
Turn JSON, CSV or spreadsheet cells into clean table code, or clean up text from Word.
- XPath Tester
Run XPath on your XML, see every match, open a tree or turn XML into text.
- XSLT Transformer
Run an XSLT stylesheet on your XML, preview the HTML, or turn XML into classes.
- YAML Validator and Formatter
Check YAML with exact line errors, tidy it, view a tree, or convert it to JSON and Base64.
- XML to CSV Converter
Turn XML, YAML, CSV, TSV and JSON into each other in one box.
- CSV Viewer and Editor
Read CSV in a table, fix cells by hand, clean it up and copy it back.
- SQL Formatter
Format, minify, escape and unescape SQL in your browser.
- CSV to SQL Converter
Turn CSV, TSV and JSON into SQL, or SQL INSERT rows into data.
- HTML to JSON Converter
Turn HTML into JSON, XML, YAML, CSV, text or code strings, and back.
- BBCode to HTML Converter
Turn BBCode, HTML and Pug into each other, with a safe live preview.
- RSS Feed Viewer
Read RSS, Atom and OPML in a clean list, and copy them as JSON, CSV or XML.
- JSON to CSV Converter
Turn nested JSON into a clean spreadsheet table, with long IDs kept exact and every change listed.
- CSV to JSON Converter
Turn a spreadsheet export into clean JSON records, with quoted commas read right and zip codes kept whole.
- JSON to XML Converter
Turn JSON into valid XML with one root, real attributes from @keys and tag names that always parse.
- XML to JSON Converter
Read any feed or API reply as JSON, with attributes kept as @keys and repeated tags turned into lists.
- YAML to JSON Converter
Turn configs and manifests into exact JSON, with anchors resolved and every indent error pinned to its line.
- JSON to YAML Converter
Write clean YAML from JSON, with values like NO, 1.10 and dates quoted so they keep their meaning.
- XML Formatter
Also pretty print, minify and validate XML, with every error shown on its line.
- Markdown to HTML Converter
Then convert Markdown to tidy HTML, or take HTML back to Markdown.
Questions about these JSON tools
Are these JSON tools free?
Yes. Every tool here is free, with no account and no size limit beyond your browser.
Is my data uploaded anywhere?
No. The tools run in your browser, so your data never reaches a server.
How do I find an error in a data file?
Paste it into the formatter. It shows the exact line and column of the mistake.
Can I open API data as a spreadsheet?
Yes. The CSV converter makes a file that Excel and Google Sheets open directly.
Can I convert CSV back to JSON?
Yes. The CSV to JSON converter reads the header row as keys and makes one object per row.
Does the JSON viewer handle big files?
Yes. It shows the data as a tree you can open and close, so even a large file stays easy to read.
Which tool turns JSON into code?
The JSON to code tool. It writes typed classes or interfaces for several languages from a sample.