Back to Top
How to convert an emWave Pro data file export in JSON format to an Excel-readable format
May 24, 2018Here 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.