™ 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. (Note that from v2.1, users may select alternate custom separator characters, instead of the default comma).  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. 

If you are wanting to convert Fitbit JSON files to CSV for Garmin upload, try our other program F2GConvert

System Requirements:

Latest versions: 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 (v2.3) (Windows 32 bit) (2.76MB) 

  SHA1 checksum: 8379b2e581bcc336596957643e7133b4cd37cd3e

  DOWNLOAD SaveJson2CSV (v2.3) (Windows 64 bit) (3.07MB) 

  SHA1 checksum: 08930677fc63dc3b2dbff9c1ec5073b7c89882ce

Download older version SaveJson2CSV v1.7 application for Windows 7+ here.

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

  SHA1 checksum: cde65dc2af9d9b66cbd3af399f955d473d9d0ed8

Download the legacy 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] [/sep <str>] [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
	/sep, --separator=<str>       Non-comma separation character

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 2.3 released March 2023:

  • Minor update to latest library versions.

Version 2.2 released May 2022:

  • Fix bugs related to wxWidgets Debug Alert at program start on some machines.
  • Ensure output CSV files are always UTF8 encoded.

Version 2.1 released May 2022:

  • Added the option to replace commas in output file with a custom separator character, in both windows and command line versions.  For example, a valid command line might be:
     SaveJson2CSVcmd /sh /sep ";" "test1.json"

Version 2.0 released April 2022:

  • Using a newer JSON library, leading to a 10% improvement in processing time.
  • Note however, that the new library may be less forgiving of JSON format errors than previous.
  • Note also, that while the contents of CSV output files will be the same, the exact ordering of the headers and columns may be different than previous versions.

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: