Exporting data from the app and importing it into Excel


To export measurement data to an Excel file follow these steps:

  1. Go to Export Data;
  2. Select the desired study to export data from;
  3. Customize the start/end date based on what days and dates resolution you want (see explanation at top of screen);
  4. Select (with the Command key held down) one or more Sensor measurements to export;
  5. Click on export data.

The data is exported with a dot (.) as decimal separator

If your Excel language is set with comma (,) as the decimal separator, follow the following screens to read the data properly:

EXCEL 2109 - with Power Query editor

  1. Open an empty Excel document and go to Data -> From Text/CSV. Select the exported .CSV file from the HCM app.
    Excel pq editor 1

  2. Select as column separator: 'Semicolon' (depending on the column separator selected in the HCM app) and as Data Type Detection: 'Do not detect data types'. Press 'Import'.
    Excel pq editor 2

  3. Go to the Power Query Editor and select each measurement column. Change the data type to "decimal number" in the transformation menu.
    Open the advanced editor and at the very end add: , "en-US" to the function "Table.TransformColumnTypes".
    Example: #"Type changed" = Table.TransformColumnTypes(#"Columns deleted",{{"sales.grand_total_month", type number}}, "en-US")
    Excel pq editor 3

EXCEL without Power Query editor

  1. Open an empty Excel document and go to Data -> From external source -> From text source

Healthyclimate excel import 1 import from text

2. Select the file and open it. Specify that it is a character-separated file.

Healthyclimate excel import 2 delimiter

3. Select the column separator used when exporting the data (here semicolon ;) and go to the following screen

Healthyclimate excel import 3 semicolon

4. In the next screen, you can specify what kind of data is in each column. You only need to do this for the first column by setting it to Date (Y-M-D). Press the Advanced button

Healthyclimate excel import 4 set date advanced

5. Set a period (.) below the decimal separator. Choose your own desired thousandth separator. Press OK.

Healthyclimate excel import 5 decimal separator

6. Press Finalize/Finish and the data will be interpreted correctly. If you want to make the decimals equal, select the first row of numbers and then press 'Shift - Ctrl - Down Arrow' at the same time to select all the numbers in the tab.

Healthyclimate excel import 6 select all numbers

7. Reduce the number of decimal places as desired using the Reduce decimal places heading. (In the middle of the 'Home' toolbar .00->.0)

Healthyclimate excel import 7 decrease decimals

8. ...until you reach the desired number of decimal places.

Healthyclimate excel import 8 end result