Knowledgebase


Knowledgebase Search:



Knowledgebase Article

How to convert an emWave Pro data file export in JSON format to an Excel-readable format

May 24, 2018

Here is a Web site that will convert a JSON data file to a CSV file that can be read by Excel.
http://codebeautify.org/view/jsonviewer
 
Screen shot below.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Use the “open” button to open the JSON file.
Use the “Export to CSV” button to create the CSV file that can be read into Excel.
 
Date and time fields in the data file are in Unix timestamp format.
Use this function to convert to a readable format:
 
=(((B26/60)/60)/24)+DATE(1970,1,1)+(-5/24)
 
Replace B26 with the appropriate cell location. Replace “-5” with the appropriate GMT offset for your time zone.
 
Use a custom cell format like “[$-409]m/d/yy h:mm:ss AM/PM;@” to display the date and time.




Back to Top