Converting emWave Pro JSON Exports to Excel

Note: This guide is intended for professional HRV researchers. HeartMath is not responsible for any data loss or corruption during this process.

Overview

emWave Pro data files exported in JSON format can be converted into CSV files, which are easily readable by Microsoft Excel, using online conversion tools.

Conversion Steps

1. Go to the CodeBeautify JSON Viewer.

2. Click the Open button to upload your emWave Pro JSON file.

3. Once the file is loaded, click the Export to CSV button to download the converted file.

Formatting Date and Time

The exported data uses Unix timestamps. To convert these into a readable format in Excel, follow these steps:

1. Apply Formula: Use the following formula in a new column (assuming your timestamp is in cell B26):

   =((B26/86400)+DATE(1970,1,1)+([Offset]/24))

   • Note: Replace [Offset] with your local GMT offset (e.g., -5 for EST).

2. Format Cells:

   • Right-click the cell and select Format Cells.

   • Choose Custom and enter the following format string:

     [$-409]m/d/yy h:mm:ss AM/PM;@

Your data will now display as a standard date and time.