Convert JSON to CSV: Generate pointer/value pairs from your data

JSONBuddy already supports converting JSON data to CSV and back from CSV to JSON. You can learn more about the standard JSON to CSV dialog on the help pages. Starting with JSONBuddy 5, there is a new way to generate CSV output from JSON input in the editor: the Convert JSON to pointer/value pairs command.

To illustrate this method, we take the following JSON input as an example:

library.json from the example files coming with JSONBuddy.

Use the JSON | Convert JSON to pointer/value pairs command from the editor. The command is applied to the active document and creates the following CSV output:

CSV output from library.json.

This CSV output contains all the data from the JSON input to create the original JSON structure again.

The left column is the JSONPointer where the actual value is located. The pointers contain object, array, and property name information from the JSON input.
The right column is the JSON value. This also means the number of lines in the CSV output equals the number of single JSON values in the input data.

You can edit and save the CSV data in the JSON editor and use it as input for other tools like Excel.