Spreadsheets

The JSON format

The format websites, apps and web services use to talk to each other: objects with names and values, even nested. Converting a table to JSON makes it ready for code.

Drop your files hereor (JSON and over 40 other formats). You can also paste an image.No upload: everything happens on your device

Fact sheet

JSON

JavaScript Object Notation

Best for: Developers, APIs, imports into databases and apps.
Limits: For non-programmers it’s less convenient than a spreadsheet.
Type: structured data
Human-readable: yes, it’s text
Used by: APIs, apps, configuration files
Extensions: .json
MIME type: application/json
Since: 2001

Convert JSON to…

Convert to JSON from…

Questions about the JSON format

How do I open a JSON file?

Usually a double click is enough: operating systems and the most common programs recognise it. If the program or website you use won’t accept it, you can convert it here to a more common format, for example CSV.

What extension do JSON files have?

.json. The MIME type is application/json.

Does converting a JSON lose quality?

The content is preserved; layout and style details may change between different formats.