Data export and import for Microsoft Excel, SPSS and Co.

Microsoft Excel

UNIX Timestamp

• Export your data to emoTouch with the option UNIX Timestamp.
• Load and open the Excel template emoTouch Import.
• Import the emoTouch export file using the Import/Text file option (not the CSV option).
• You do not need to change the default settings of the import dialogue. Import the data into a new sheet in the same workbook.
• EXCEL displays the long numbers of the Unix timestamp in scientific notation by default (1.6xxxxE+12). This prevents you from seeing the relevant end of the timestamp with the last three numbers representing milliseconds. To change this, select the column with the timestamp and apply the cell template "UNIX Timestamp" that comes with the template.
• To convert the UNIX Timestamp to a readable Date_Time format, copy the formula in the Date_Time column of the Templates sheet and copy it to an empty column of the sheet with your imported emoTouch data. You may need to adjust the reference to the Unix timestamp column in the formula (E by default). If you only see a row of hashtags (######), the column is simply not wide enough to display the content.
• To change the format of the date_time column, you can select another option in the cell styles dialogue or create your own format.

DATE_TIME

• Export your data to emoTouch with the option DATE_TIME.
• ATTENTION: The decimal point (comma or dot) in the export file MUST match the settings of your operating system and program.
• Download and open the Excel template emoTouch Import.
• Import the emoTouch export file using the Import/Text File option (not the CSV option).
• You do not need to change the default settings of the import dialogue. Import the data into a new sheet in the same workbook.
• You should see the timestamp in date_time format with the milliseconds after the decimal point (comma or dot), which depends on your operating system and programme. If the last three digits (milliseconds) in the imported data are clipped or all set to 0, try using the other option for the decimal point in the emoTouch export options.
• To change the format of the date_time column, select another option in the cell styles dialogue or create your own format.

Open Office, Libre Office, Apple Numbers

To import the emoTouch timeline into these programmes, download the template file for Microsoft Excel, open it and follow the basic procedure in the Excel section.

SPSS

SPSS can easily import the UNIX timestamp format as a numerical value that can be used, for example, to calculate time differences. However, SPSS unfortunately does not support readable date/time formats that contain milliseconds. If you try to convert the UNIX timestamp to a readable format in SPSS or import the DATE_TIME or ISO 8601 format into SPSS, this will probably fail or produce unreliable data.