How to Open a JSON File on Windows, Mac, or in Your Browser

Choose a viewer or an editor

If you only need to find a value in an API response, a tree viewer is usually the clearest starting point. You can expand one branch at a time instead of searching through a wall of text. If you need to change a configuration file, use a text editor and validate the result before saving it.

A spreadsheet is useful for a list of records, but it is a poor representation of an arbitrary nested document. First identify the array that actually contains the records you want to analyze. An API response may wrap that array inside a key such as users, results, or data.

Open JSON in your browser

Open the JSON Viewer tool and use the upload icon in the input toolbar to choose a .json file. The contents are read on your device. You can also paste JSON copied from an API response or a local editor.

The right panel displays a tree. Open two levels to see the main structure, expand a branch to inspect it, and search for a key or value. The small copy icon beside a field copies its JSON Pointer, which identifies where that value lives. Large branches are shown in batches to keep the view manageable.

{"user":{"name":"Alice","active":true},"roles":["editor","admin"]}

Example paths:
/user/name
/roles/0

Open JSON on Windows or Mac

On Windows, choose Open with and select a text editor such as Notepad or an installed code editor. On macOS, use a code editor, or open the file in TextEdit as plain text. A code editor is convenient when you want syntax colors and bracket matching.

If the file opens as one long line, that is usually minified JSON rather than a damaged file. Paste it into the beautifier to add indentation. Save a separate copy when experimenting so you can return to the original file.

Know what you are looking at

Braces identify an object with named fields. Square brackets identify an array, whose items are addressed by index starting at zero. Values can be strings, numbers, booleans, null, objects, or arrays.

Quoted values such as "00123" are strings. Removing the quotes changes the type and can lose useful formatting. Likewise, null means the value is explicitly empty; a missing field means it is not present at all.

• Use the tree for navigation and the formatted text for copying a whole document.
• Copy a JSON Pointer when you want to describe an exact field to a teammate.
• Use JSONPath when you want to extract several matching fields rather than one path.

If the file will not open cleanly

A parser error often points to a trailing comma, missing quote, incomplete download, or text that is not actually JSON. An HTML error page saved with a .json extension is still HTML. Check the beginning of the file and the original response before trying to repair it.

If the data is valid but very large, turn off automatic formatting and work with a smaller sample. Browser memory is finite. For analysis, export only the record array you need; keep identifiers as strings when moving them to a spreadsheet.