Follow

Wave: Exporting Data

The option to export the data from your wave is now available from the Airthings Dashboard.

 

Step 1: Login to the Airthings Dashboard with the same credentials as you use for your Airthings Wave App.

Screen_Shot_2018-03-19_at_11.25.17.png
https://dashboard.airthings.com/login


Step 2: Downloading the data from your device as a csv file.

- Select the data set from your device by clicking on it.

Screen_Shot_2018-03-19_at_10.07.15.png

- Click on Options and select "Export to csv"

Screen_Shot_2018-03-19_at_10.06.53.png

- This starts the download, now you have the data set from your device available as a csv file, it looks something like this depending on what program you use to view it:

Screen_Shot_2018-03-19_at_11.22.46.png

 

Step 3: Importing the csv file into a spreadsheet:


A: Google sheets

B: Excel

 

A) Google Sheets - how to import a csv file (with correct formatting)

- Once you have the .csv file download in your preferred location

1. Start Google Sheets with a blank spreadsheet open.

2. Select "File" on the ribbon, and then "Import".

Screen_Shot_2018-03-19_at_12.50.54.png

3. Click on "Upload" and then "Select a file from your computer".

4. Once you have uploaded the .csv file and clicked "Select", the import menu will open.

5. Choose between "Create new spreadsheet" or "Replace spreadsheet"

6. Set "Separator type" to "Custom" and input semicolon (;).

7. Click "Yes" on "Convert text to numbers and dates".

8. When you are done, click "Import data".

Screen_Shot_2018-03-19_at_13.00.25.png

Your finished result will look something like this:

Screen_Shot_2018-03-19_at_13.11.52.png

 As you can see on the picture above, the csv includes:
Date, time, hourly radon sample, humidity and temperature.

The column called short term average is simply the average radon concentration for that hour per m3 or L depending on what measurement units you have configured under settings.

 

 

 

B) EXCEL - how to import a csv file  (with correct formatting)

- Once you have the .csv file download in your preferred location

1. Start Excel with a blank workbook open.

2. Select "Data" on the ribbon, and then "From Text". (If the menu options are greyed out this could be because you do not have a workbook open).

Screen_Shot_2018-03-19_at_12.24.15.png3. Browse for the *.csv file you want to open, and click "Import".

4. In the Text import wizard, ensure the "Delimited" option is selected. Click "Next."

Screen_Shot_2018-03-19_at_12.24.54.png

5. In the delimiters section, tick "Other" and set the input as semicolon (;). The text qualifier box should show the double-quote symbol. Click "Next."

Screen_Shot_2018-03-19_at_12.25.03.png

6. Mark every columns as "Text". The first column only will initially be highlighted. Move the horizontal cursor as far as it will go to the right; then, holding the shift key down, click the very last column heading. You should now have every column highlighted. Click the "Text" data format. It will now say "Text" in the header of every column. Click "Finish."

Screen_Shot_2018-03-19_at_12.25.22.png

7. It may ask you "Where do you want to put the data?". It will allow you to click into any cell on the blank worksheet to determine where the data should go. Click 'OK' to proceed.

8. The data should now appear in the spreadsheet. Where column headings are included these will appear in the top row. Check that fields have not lost leading zeros where applicable.

Your finished results should look something like this:

Screen_Shot_2018-03-19_at_13.11.52.png

 As you can see on the picture above, the csv includes:
Date, time, hourly radon sample, humidity and temperature.

The column called short term average is simply the average radon concentration for that hour per m3 or L depending on what measurement units you have configured under settings.

 

If you have any questions or issues, please send us an email at support@airthings.com :)

Was this article helpful?
19 out of 26 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.