How to Open a JSON File (and Actually Read It)
You downloaded a .json file, double-clicked it, and got either a wall of unreadable text or a 'choose an app' dialog. Here's what the file is and the right way to open it for reading, editing, or spreadsheet work.
In short
Open a .json file by dragging it into a browser-based JSON reader or viewer for instant formatting and validation, use a code editor like VS Code (or an online JSON editor) for ongoing edits, or convert it to CSV first if you need it in Excel or Google Sheets. Plain Notepad or TextEdit shows only unreadable raw text and can silently corrupt quotes.
What a .json file actually is
Plain text — nothing exotic. A .json file contains structured data in JSON format: exports from apps (Twitter archives, browser bookmarks, game saves), API payloads, configuration. Because machines write these files, they usually arrive as a single enormous line with no spacing — technically perfect, humanly unreadable. The fix isn't a special program; it's a viewer that understands the structure.
Open it to read: the 10-second route
Drag the file onto our JSON Viewer (or any tool page) — it loads, formats, and validates instantly, opening straight into a collapsible tree view that turns 50,000 lines into a dozen foldable branches. Nothing uploads anywhere: the file is read locally by your browser, which makes this route safe even for exports containing personal data.
Native alternatives: Firefox renders .json files with a built-in viewer if you open them directly; Chrome shows raw text unless you add an extension.
Open it to edit
For ongoing work, use a code editor — VS Code is the free default and highlights, folds, and validates JSON out of the box. For a one-off edit without installing anything, our JSON Editor gives you the same Monaco engine in a tab: edit with live validation, then download the result. Avoid Notepad/TextEdit for editing: they'll happily let you break the syntax, and TextEdit can silently substitute curly quotes that corrupt the file.
Open it in Excel or Google Sheets
Spreadsheets want rows and columns, so convert first: run the file through JSON to CSV, which flattens records into a table (nested fields become dot-path columns), then open the CSV normally. This is the answer to 'how do I open JSON in Excel' — Excel's own Power Query JSON import works too, but the convert-first route is faster and shows you exactly what the table will look like.
Sources
Frequently asked questions
What program opens JSON files by default?
Often nothing useful — Windows may suggest Notepad, which shows the raw single-line text. Any browser, code editor, or online viewer opens them properly. There's no proprietary format involved; it's UTF-8 text.
Is it safe to open a JSON file someone sent me?
JSON is inert data — no macros, no scripts, nothing executable — so opening it in a viewer or editor is safe. The usual caution applies to what the DATA contains, not the act of opening it. Client-side viewers like ours add privacy: the file never leaves your machine.
Why is my JSON file all on one line?
Machines omit whitespace because parsers don't need it and bytes cost bandwidth. One pass through a formatter restores indentation and line breaks without changing the data — that's literally what 'pretty printing' means.
Drag any .json file onto the JSON Viewer — formatted, validated, and explorable as a tree in seconds, 100% locally.
Open a file nowKeep working
Related tools
JSON Viewer
Explore any JSON document in an interactive, collapsible tree — keys, types, and counts at a glance, with code view one click away.
JSON Editor
A full VS Code-style editing experience for JSON — highlighting, error squiggles, undo/redo, search, and formatting in one place.
JSON to CSV
Flatten JSON arrays into spreadsheet-ready CSV — nested keys become dot-path columns, quoting handled for you.
JSON Size Calculator
Measure exactly what a JSON payload costs — raw, minified, pretty-printed and gzipped bytes — and see which keys are eating the budget.
JSONL Viewer
The JSON Viewer can't open a .jsonl file at all — JSON.parse fails on line two. This page reads it the way it's actually structured: one JSON value per line.