CSV Data
The Airthings for Business Dashboard enables CSV data export at both the Building and Space levels.
Building Level Export
The Dashboard can export a CSV file containing data samples from all sensors within a building for a specified timeframe.
To export CSV data from a Building:
Navigate to Buildings.
Choose Export.
Select the Time range.
Choose the Sensors.
Click Export.
Time Zone
In the exported CSV file, you'll find two timestamp columns:
"samplerecorded": Recorded in UTC.
"samplerecorded_local": Displayed in the building’s local time zone.
For data comparison with the Dashboard, use "samplerecorded_local" as it matches the time zone shown on the Dashboard.
Space Level Export
You also have the option to export a CSV for a single Space.
To export CSV data from a Space:
Navigate to the Space.
Click the download button in the top-right corner.
Select the Time range.
Click Confirm.
Time Zone
In Space-level exports, only the "samplerecorded" column is available. This is recorded in Coordinated Universal Time (UTC). This is not your local time zone! If you prefer data in the building’s local time, we recommend exporting data from the Building level.
Opening the CSV in Excel
The CSV files you can download from the Airthings Dashboard are comma-separated. If you open them in Excel, it could be that you see all the data in one column:
If the CSV looks like the file above, follow the steps below:
Select Column A
Go to the Data tab
Click Text to Columns
Choose Delimited and click Next
Select Comma as delimiter and click Finish
Now, all the data should appear in separate columns!