Working with exported CSV data

You are here:
< Back

When you download CSV data you will be presented with 4 to 6 columns of information (depending on your export format). The data will typically contain:

  1. the timestamp (a 32-bit integer unix timestamp in milliseconds),
  2. the sensor type (an 8 or 16-bit integer, depending on your sensor),
  3. the sensor label and
  4. the data itself (typically a 32 or 64-bit float).
  5. Depending on your exported format, you may also have a column containing the MAC address of the sensor.

Converting the timestamp to a date format can be done in Excel and Open office with the following function:

=(((B7/60)/(60 * 1000))/24)+DATE(1970,1,1)+(-7/24)

You can also get a more detailed explanation here: http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/

Other considerations:

  1. Aretas timestamps are in millisecond precision, so (as shown in the formula provided) – you need to multiply seconds * 1000
  2. To correct for time zone, change the -7 to -5, -4 etc (whatever your correct GMT offset is)
  3. You will also need to format the cells to show the time (see the image below for an example in open office)

 

Table of Contents

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.