CSV Data
The Airthings for Business dashboard is capable of exporting csv data from the Insights pages, Building level, and Device level.
Insights
Air Quality / Energy
Air Quality / Energy
These options will export data related to Time over threshold. The dashboard can export one file per parameter. The values are presented in minutes over your set threshold.
Space usage
Space usage
These options will export data related to the amount of time a space is in use. The file provides the serial number, floor, room type, and usage time in minutes.
Building
The dashboard can export a CSV file containing all data samples for all sensors within a given timeframe.
Device
Selecting a device from the device list will bring up a view of the most recent readings. To the top right, there is an option to export CSV data or generate a PDF. The CSV file will contain all of the data samples since the device was brought online.
Opening the CSV in Excel
The CSV files you can download from the Airthings Dashboard are semicolon-separated files. If you open them in Excel, it could be that you see all the data in one column. Below you will find some guidelines that will avoid manual work to split the data into separate columns.
Change the delimiter symbol in Windows settings:
Open the Control Panel in Windows.
Click on "Region" or "Region and Language" depending on your version of Windows.
Click on the "Additional settings" button.
In the "List separator" field, change the list separator to a semicolon symbol:
Click "OK" to save the changes.
Now open the CSV in Excel, and you can work with the data as you would in any other Excel spreadsheet.
Import the CSV in Excel from a text file:
Open Excel and go to the "Data" tab.
Click on "From Text/CSV" button.
Navigate to the folder where your CSV file is located.
Select the file and click "Import".
Click "Load" to import the data into Excel.
You can now work with the data as you would in any other Excel spreadsheet.
Both of the above methods will allow you to open and work with a CSV file delimited in Excel. You can choose the method that best suits your needs.
Time zones
Within the CSV files, you will encounter two columns containing timestamps indicating when the data was recorded:
"samplerecorded": presented in the UTC time zone.
"samplerecorded_local": represented in the local time zone of the building.
For effective data comparison with the dashboard, it is advisable to utilize "samplerecorded_local" since it aligns with the timezone displayed on the dashboard.