XML, JSON, CSV and HTML conversion tool

Import CSV text and get JSON, XML or HTML

Editor to directly convert from CSV to JSON or XML.
Rename and exclude columns from the CSV input during the conversion.
Supports CSV input with different character encodings and column seperators.
Import data from sources like Excel or databases.
Transform JSON data to HTML using XSLT stylesheets.
Also available as command-line tool

Download JSONBuddy as your JSON editor now:

Download

Purchase

Convert between XML and JSON

Convert any of your XML documents to JSON with a few clicks.
Preserve attribute and namespace information on converting XML to JSON.
Provides a dialog to set all options for the conversion.
Convert JSON to XML with a single click directly in the editor.
Transform JSON to HTML using standard XSLT stylesheets.

Create CSV from any JSON input

Convert structured data to CSV text files.
Support for child objects and values.
Generate CSV from the complete JSON input.
Enables you to import JSON into Excel and any application that reads CSV.
Write CSV output with different character encodings and column seperators.
Use JSON pointer standard to define the data for the conversion.

To convert JSON data to CSV using JSONBuddy, follow these steps

Open the JSON data file in JSONBuddy. If the file is large, use the Large File view to open it, which allows you to check the structure of the JSON data and set the starting point for the conversion.
Click on the "JSON" menu, select "Convert JSON to CSV file..." option.
In the "Convert JSON array to CSV" dialog, set the starting point for the conversion using the JSONPointer location. The starting point needs to be a JSON array.
Choose the columns that you want to include in the CSV output.
Select the output format for the CSV file.
Click on the "Convert" button to convert the JSON data to CSV. The output CSV file will be written as a new document next to the JSON input with .csv as the file extension. This process may take some time depending on the size of the data.

Screencast Tutorials

Convert JSON data to CSV

This tutorial shows how to convert JSON data of any size to CSV using JSONBuddy. The screencast is a step by step guide from setting the JSON input data to defining the output format details.

Convert CSV data to JSON or XML

Learn how to convert CSV data of any size to JSON or XML using JSONBuddy. To convert CSV data to JSON, the tool is parsing the CSV file and maps a set of user defined values to corresponding JSON keys.

Take a detailed look at some other features of JSONBuddy

JSONBuddy is more than just a JSON editor for Windows ®. Learn more on clicking the images and links below.

JSON Schema editor

Get a complete JSON Schema designer with extended support for creating and testing JSON schema specifications.

JSON validation debugger

See in detail how your JSON data is validated using the JSON Schema validation debugger.

Try here

Convert JSON to CSV

XML, JSON, CSV and HTML conversion tool. Import CSV text and get JSON, XML or HTML.

Import CSV text

Import from any CSV text and get structured JSON or XML data in the editor.

JSON Pointer

JSON editor with built-in JSON pointer engine. Useful on creating JSON Schema documents and for navigation.

JSON Schema analyzer

The only JSON editor with a built-in JSON Schema analyzer.

Complete JSON tool

Text editor window and context sensitive entry-helper with a list of properties resolved from a JSON Schema.