This article lists the key differences between JSON and CSV for you, illustrated with clear examples, and explains when it is best to use either JSON or CSV.
Json Editor Online
Indepth
In these articles we explore how to work with JSON data as a developer and explain how to use the online JSON editor for that.
Exploring the power of JSON: a real-life JSON file example collection
Who doesn’t love a JSON file example? Check out these examples out to understand what JSON is, or use them for testing and debugging.
How to ChatGPT JSON? Use smart prompts to query JSON
Learn how to ChatGPT JSON data. Querying and converting JSON works like a charm. Mostly. ChatGPT can also output wrong results, so, use it with care.
Is JSON valid? Validate JSON online
Is JSON valid? Or not? How to check this? There are powerful JSON validators, both for syntax and for structure. Learn how it works and and try it out.
JSON Schema validator: a powerful way to check JSON data
Learn what JSON Schema is and learn how to use a JSON Schema validator to check JSON data. Try it out in the interactive playground.
JSON vs XML: should I use JSON or XML?
This article explains the main differences between these two data formats and when to use JSON vs XML. In short: use JSON over XML when possible.
What is JSON? Learn all about JSON in 5 minutes
JSON is a lightweight data interchange format. It is simple and extremely popular. JSON values can be an array, object, string, number, boolean, or null. Read on to learn all about it.
I wasn’t going to write a CSV parser, really…
… but I ended up writing one of the fastest JavaScript CSV parsers out there. See the benchmark and learn what makes the csv42 library so fast.
Convert JSON to CSV using JSON Editor Online
Can I convert JSON to CSV? Definitely! Learn how you can import and export CSV, how to show your CSV in a table view, and how to sort, filter, and query your CSV data.
Easily transform JSON data: a hands-on tutorial
See how to query your JSON data using a powerful, visual tool. With a few clicks you can sort, filter, and select fields out of your data.
How to POST JSON data in JavaScript
This article explains what HTTP requests are and how to POST JSON data in JavaScript. Learn about common pitfalls and handy tools to fetch JSON data.
JSON compare: how to compare two JSON files?
To compare JSON data in a meaningful way, you should compare the data contents, not the plain text contents. There is a handy tool for that. Read on to learn more.
JSON to TypeScript, 4 different approaches
You can blindly cast the data to your TypeScript model, but there is more to this: ideally you validate your data before casting it. Learn how to go about this.
Why JSON comments are not allowed and what to do about it
The issue originates from using JSON for configuration files, whereas JSON is a data format in the first place. Learn what you can do about it.
Why does JSON.parse corrupt large numbers and how to solve this?
Since the early days of JSON Editor Online, more than 10 years ago, users regularly reported issues of the editor sometimes corrupting large numbers in their JSON documents. We haven’t been able to solve this until now. In this article we explain the problem in-depth and show how we solved it in JSON Editor Online.
How to fix JSON and validate it with ease
How can you figure out what is wrong, without spending too much time on it? And, of course, how to solve the problem and fix JSON?
JSON date format: 3 ways to work with dates in JSON
What is the “right” JSON date format? This article explains three solutions, including the ISO 8601 date string which which is normally the best approach.
4 handy categories of JSON tools and when to use them
There are different kinds of tools to help you work with JSON data. Learn about 4 different types of JSON tools and when to use them.
Parse JSON: What is JSON parsing and how does it work?
When you parse JSON, you convert a string containing a JSON document into a structured data object that you can operate on. Learn how this works.
Beautify JSON, 3 easy ways
Beautifying JSON is adding new lines and indentation to make JSON data readable. There are various ways to beautify your JSON, read how.
Hi!
I've set up a website to write about JSON related topics. Whilst the data format JSON is very simple in itself, there is a lot to tell about using JSON in practice.