™ Registered trademark.

 

Gunamoi Software

   SaveJson2CSV - a free tool to convert JSON files to CSV files.






SaveJson2CSV

Description/Download










SaveJson2CSV is a free tool to convert JSON files to CSV files in a windows GUI. 

JSON is an open-standard format that uses human-readable text to transmit data objects consisting of attribute-value pairs.  It is commonly used for asynchronous browser/server communication, as an alternative to XML.  Read more about JSON formats on Wikipedia

A comma-separated values (CSV) file stores tabular data (numbers and text) in plain text.  Each line of the file is a separate data record.  And each record consists of one or more fields, separated by commas.  Read more about CSV formats on Wikipedia

The CSV file format is not standardised, however we assume the common formatting used by most spreadsheet programs, such as Microsoft Excel or OpenOffice Calc.  Text fields may include commas and other formatting, such as line-breaks, provided the text field is surrounded by quotation marks ("...").  If text fields need to include quotation marks, they must be doubled.  For example (He said "hello".) must become ("He said ""hello"".") in a CSV file, to be properly read by a spreadsheet program. 

SaveJson2CSV will use a separate column for each key name in the JSON file.  The first line in the output CSV file is a list of the column headers, based on the JSON key names.  Each record of a JSON Array will be placed on a separate record line in the CSV file, and the order of the original array records will be maintained.  So JSON Object names become the columns in the CSV and JSON Array elements become the rows in the CSV.  However, JSON Objects are defined as an unordered collection of data, so the order of the columns in the CSV may not match the order of the Objects in the original JSON file. 

While CSV is intended for storing tabular data, JSON data need not be tabular.  So CSV output files may sometimes appear rather sparse, or repetitive, if the JSON data is not well suited to a tabular format. 

SaveJson2CSV also tries to be forgiving of any formatting or non-ASCII characters in the JSON file. 

System Requirements:

Latest version: Windows 7 or later, 32 bit or 64bit versions available.
Legacy version 1.6: Windows XP, 32bit only.

This is free software and is provided free of charge, 'as is' with no warranty.  No registration required.  There is no installer for this program, just unzip the executable and run it as described below. 

Download the program here.

  DOWNLOAD SaveJson2CSV (v1.7) (Windows 32 bit) (3.14MB) 

  SHA1 checksum: cde65dc2af9d9b66cbd3af399f955d473d9d0ed8

  DOWNLOAD SaveJson2CSV (v1.7) (Windows 64 bit) (3.61MB) 

  SHA1 checksum: 7fd3e8b2d5034838852c65baab98650baeba6e64

Download the old version SaveJson2CSV v1.6 application for Windows XP here.

  DOWNLOAD SaveJson2CSV (v1.6) (Windows 32 bit) (3.03MB) 

  SHA1 checksum: 22ada27cae1546df60a4701d8f8f3dfbece1336c

Installation steps:

1. Download the appropriate SaveJson2CSV zip file from this page (see buttons above).

2. Unzip the SaveJson2CSV executables to any location and run them directly.  There are no special install requirements. 

3. "SaveJson2CSV.exe" is the Windows GUI executable. 

4. "SaveJson2CSVcmd.exe" is the command line executable. 

	Usage: SaveJson2CSVcmd [/h] [/sh] [/jh] [/dt] [/st] [/o] [input file] [output file]
	/h, --help            displays this help on the command line parameters
	/sh, --sh             Simple text headers (default)
	/jh, --jh             Header names showing JSON structure
	/dt, --datetime       Keep input file 'last modified' date and time
	/st, --striptags      Strip HTML tags from JSON strings
	/o, --overwrite       Overwrite any existing files

Sample SaveJson2CSV Screenshot

Sample Screenshot

Please note that the exact look and feel of the program will vary on each computer depending upon the individual user's operating system and theme settings. 

Version History

Version 1.7 released September 2021:

  • Fix bug reading JSON files containing strings with escaped unicode characters.
  • Add option to strip all HTML tags from JSON text strings.

Version 1.6 released March 2021:

  • Minor update to latest library versions.
  • Added checkbox to Keep input file 'Last modified' date and time.
  • Added button to force output folder same as input folder.
  • Added command line version SaveJson2CSVcmd.exe for shell script/batch use.
  • Add option to 'Keep All' numbered output files instead of overwriting any existing files of same name.  This is the default action for the command line version, which requires the '/o' switch to force overwriting.

Version 1.5 released February 2020:

  • Minor update to latest library versions.

Version 1.4 released February 2020:

  • Minor library updates, and now Input Files header indicates the number of files selected.

Version 1.3 released March 2019:

  • Improved error checking & error reporting.

Version 1.2 released February 2018:

  • Add UTF8 BOM to CSV files so Excel properly recognises UTF8 characters.

Version 1.1 released October 2016:

  • Improved treatment of JSON arrays in CSV header line.

Version 1.0 released October 2016.

This is absolutely free software, provided ad-free and without obligations.
However, should you find it useful, and wish to show your appreciation, you may buy me a coffee via PayPal using the button below: