XML, JSON, CSV and HTML conversion tool

Convert from CSV to JSON, XML or HTML

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:

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.
Convert between XML and JSON
Convert JSON to CSV

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

  1. 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.
  2. Click on the "JSON" menu, select "Convert JSON to CSV file..." option.
  3. 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.
  4. Choose the columns that you want to include in the CSV output.
  5. Select the output format for the CSV file.
  6. 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.