JSON Viewer

View JSON Files

  • Revolutionary JSON Grid View
  • Intelligent JSON Text View
  • JSON syntax coloring & source folding
  • View JSON, JSON5, JSON Lines, JSONC
  • Context sensitive entry-helpers
  • Structural marking to match brackets / braces
  • JSON syntax checking

JSON Grid Viewer

XMLSpy includes a revolutionary, first-of-its-kind JSON Viewer called JSON Grid. This JSON Viewer provides an easy-to-understand graphical view of your JSON file along with powerful editing features like automatic type detection, in-cell commands, XQuery filters for modifying the view, XQuery formulas for generating additional output from the JSON data, and more, all of which make viewing JSON faster and easier than a text-based JSON editor.

See How the JSON Viewer Works

JSON View provides a graphical representation of the JSON document structure that is immediately easier to understand than the corresponding JSON code in text view, especially for long, complex documents with multiple nested levels of arrays and objects.

JSON Viewer in XMLSpy for a graphical view

JSON Grid Viewer includes table view that groups data under the same array or object for easy understanding and quick editing, and you can toggle between the two displays, for instance:

Toggle between list and table view in JSON Grid

JSON Grid View makes it easy to modify or reorganize the structure of the document using drag-and-drop. Active buttons in each cell provide shortcuts for the most common display, filtering, and editing tasks. During editing, these buttons make it fast to add a child item, change a type, toggle between table and list view, and so on.

For faster editing, the JSON Viewer auto-detects string, number, boolean, and null values as you type. Other types can be manually selected within the cell.

Active buttons in the JSON Viewer

JSON Grid View has numerous easy-to-remember keyboard shortcuts to make editing as fast as possible, letting you continue typing without needing to use your mouse. A right-click context menu is also available so you can edit using your preferred approach.

If there is a JSON Schema associated with your JSON document, JSON View provides auto-completion based on that schema as you type, and data types are automatically determined based on the schema as well.

JSON auto-complete based on JSON Schema

JSON Grid Filters and Formulas

XQuery filters and formulas in JSON Grid View let you use XQuery 3.1 expressions to filter the components that are displayed in the view and calculate results that can be stored in the document.

Use XQuery filters and formulas on JSON data in JSON View

 

Each table in JSON Grid includes a filter that lets you manipulate the display of object and arrays. For example, in the screenshot above, a filter has been applied to an array so that only those tracks written by Brian May are displayed. It's easy to toggle between filtered and unfiltered cells by clicking the filter icon. When you save the file, your filters are stored in metadata for later viewing purposes. They don’t affect the content of the document.

A formula enables you to generate output (nodesets as well as calculations) and to display the output in JSON Grid View. Below is an example using an XQuery formula to calculate the price of items. Clicking the save icon for the formula gives you the option to store the output of the formula in the JSON document. In this way, formulas in XMLSpy JSON Grid open an entirely new possibility: the ability to have dynamically computed content in JSON documents.

Use XQuery filters and formulas on JSON data in JSON View

Text JSON Viewer

It's also easy to view JSON documents in the XMLSpy JSON editor using text-based JSON viewer. You might find it useful to switch between JSON Text View and JSON Grid View. Both JSON viewer options help you understand the structure and content of the JSON file with line numbering, syntax coloring, source folding, and more.

The JSON viewer in text mode with syntax coloring, line numbering, and more

The text-based JSON viewer provides syntax coloring, line numbering, source folding, bookmarking, and more, making it easy to navigate and understand your JSON code, and find and edit strings. You can also take advantage of intelligent JSON editing tools.

Syntax checking and JSON validation in the JSON viewer guide you in making valid edits. Any errors are listed in the multi-tabbed Messages window, which also includes a hyperlink to the error in your document and the related JSON Schema, making trouble-shooting a breeze.

Convert JSON <=> XML

In addition to intelligent JSON viewing and editing, the JSON viewer supports one-click conversion between XML and JSON files. This allows you to, for example, quickly convert an XML file to JSON for transport with JavaScript, or convert data received in JSON format to valid XML. You can opt to convert a single file or perform a mass JSON-to-XML conversion in the Project window. This functionality makes XMLSpy so much more than a basic JSON Viewer.

It's fast and easy to convert XML to/from JSON in XMLSpy

Why choose a JSON Viewer download?

Unlike basic online tools, the XMLSpy JSON viewer provides myriad advanced features for working with JSON, letting you go way beyond simply viewing JSON file contents.

You can generate JSON files, convert between JSON and XML, edit JSON and JSON Schema, and even develop XSLT and XQuery for use with JSON. That's what makes XMLSpy the best JSON viewer available.

The JSON viewer download below is easy to install and available for a free, 30-day trial with no credit card required.