Please enable JavaScript to view this site.

Altova XMLSpy 2020 Professional Edition

JSON Grid View enables you to see the structure of the JSON document (JSON instance/schema) in a grid, to edit the document more easily in a grid, and to restructure blocks of structured text. This provides you with an overview and editing capability that is not always present in Text View, especially in the case of long and complexly structured documents. In the case of JSON documents, such complexity can occur in the form of arrays and objects being nested within other arrays and objects at multiple levels. For example, compare the JSON text listed below (as it would appear in Text View) and its representation in Grid View (as shown in the screenshot further below).


Note:Avro support is available in the Enterprise Edition only.



While the document structure in Text View (listing above) is difficult to discern without a longer, more careful reading, the structure in Grid View (screenshot below) is more readily seen at a glance.

Click to expand/collapse

Additionally, the structure can be easily modified by adding, deleting, or moving objects in the grid. Entire blocks of text can be reorganized (for example, by sorting them or moving them). Content, too, can be edited easily in Grid View, this being made even easier with the availability of in-cell commands in individual cells.


In this section

This section is organized into the topics listed below. These descriptions explain features that are specific to JSON Grid View. For a more general description of Grid View features, such as moving objects in the grid, see the section Grid View.


How the JSON document is displayed in JSON Grid View

Editing document structure

Editing document content

Commands in the context menu

Using the table display

Using XQuery filters and formulas

JSON Lines and JSON Comments


© 2020 Altova GmbH