JSON Parser Online: Parse and View JSON as a Table

What is a JSON parser?

A JSON parser reads JSON text and turns it into data a program can use: objects, arrays, strings, numbers. Every language has one built in. What none of them give you is a way to look at the result. Paste a 400-order response from an API and you get a wall of braces, and you end up counting brackets to work out which "status" belongs to which order.

This page parses the JSON the same way and then draws it as a table. An array of objects becomes rows, and every key becomes a column. A nested object, like the customer inside an order, becomes a small table inside that order's cell, so you can read three levels deep without expanding anything. If records have different keys, the columns are the union of all of them and the missing values are just empty cells. null shows as an empty cell too.

Two things it does that a plain parse does not. Long integers keep their exact digits: a SIM card ICCID like 8901240544102066246 stays 8901240544102066246 here, where JavaScript's own parser would quietly turn it into 8901240544102066000. And double-encoded JSON, a JSON string that holds more JSON (common in logs and message queues), is unwrapped and shown as the real table. Parsing happens in your browser, and nothing is uploaded unless you click Share.

Parsing JSON in your own code

If you landed here looking for how to parse JSON in a program rather than in a browser tab, here are the two calls most people need, with the trap each one hides.

JavaScript and Node.js

const order = JSON.parse('{"orderId": "ORD-2291", "total": 48.5, "items": 3}');
console.log(order.total);   // 48.5

JSON.parse('{"messageId": 1187634512339927051}').messageId;
// 1187634512339927000   <- a different message ID

JSON.parse() turns every number into a double, which only holds about 15 to 16 significant digits. Anything past 9,007,199,254,740,991 is rounded without an error. If your JSON carries database IDs, snowflake IDs or ICCIDs, ask the API to send them as strings, or parse with a reviver that reads the raw text. Broken JSON throws a SyntaxError. Paste {'name': 'Ada'} into Chrome or Node 22 and you get Expected property name or '}' in JSON at position 1 (line 1 column 2); older versions say Unexpected token ' in JSON at position 1. Both mean the same thing: JSON needs double quotes.

Python

import json

order = json.loads('{"orderId": "ORD-2291", "total": 48.5, "items": 3}')
print(order["total"])   # 48.5

json.loads('{"messageId": 1187634512339927051}')["messageId"]
# 1187634512339927051   <- exact; Python ints have no size limit

Python's json module keeps big integers exact, so the message ID above comes back exactly as sent. The usual surprise is the error text: the same single-quoted input gives json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1). Python dicts printed with print() use single quotes, which is how a lot of not-quite-JSON ends up in log files. Use json.dumps() when you write it out.

For a longer walkthrough, see how to parse JSON in JavaScript and reading and writing JSON in Python. If you have JSON that will not parse at all, the JSON Validator points at the exact line.

How to Use the JSON Parser

Follow these steps to parse, view, and work with your JSON data. Each step uses the actual buttons and features on this page.

[{"id": 1, "subscriberId": "SUB-1001", "plan": "Unlimited 5G", "dataUsage": 45.2}, {"id": 2, "subscriberId": "SUB-1002", "plan": "Family Plan", "dataUsage": 120.5}]

When people reach for it

Common questions