# Excel trick to get data directly from tempest **URL:** \ **Category:** Tempest Owners\ **Tags:** tempest\ **Created:** [April 4, 2022, 8:42pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118 "2022-04-04T20:42:00Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 4, 2022, 8:42pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/1 "2022-04-04T20:42:00Z")
Did you know you can get your data of your tempest directly into Excel? First you need to generate a personal token. Sign in to the Tempest Web App at [tempestwx.com](http://tempestwx.com), then go to Settings → Data Authorizations → Create Token, then copy that token. Open a blank new document in Excel. Click on Data (in the menu bar at the top), select (in the top left corner) Get Data → from other sources → from the web paste the following url in the popup window and use your device id (not your station id!) and the token you just created `https://swd.weatherflow.com/swd/rest/observations/device/?day_offset=0&format=csv&token=` Presto, data is now in Excel. Day\_offset=0 returns today’s data collected sofar, Day\_offset=1 returns all of yesterday’s data. you can get your device id from settings/stations/status ---
**Author:** ![Greg](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/greg/32/6871_2.png) [@Greg](https://community.tempest.earth/u/Greg)\ **Post date:** [April 5, 2022, 1:43am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/2 "2022-04-05T01:43:24Z")
I get a 401 error? ☹ {“status”:{“status\_code”:401,“status\_message”:“UNAUTHORIZED”}} ---
**Author:** ![eric](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/eric/32/13553_2.png) [@eric](https://community.tempest.earth/u/eric)\ **Post date:** [April 5, 2022, 6:54am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/3 "2022-04-05T06:54:05Z")
I just tested it and for me it loaded +/- 400 lines of data nicely formatted with headers. The update button even appends the new readings … ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 5, 2022, 7:52am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/5 "2022-04-05T07:52:46Z")
That’s weird. You did create a new personal token and used it together with your own station\_id? It should look something like this (but this token is not my valid token ;-), so it won’t work) `https://swd.weatherflow.com/swd/rest/observations/device/15033?day_offset=0&token=843785ca-1c6a-4c19-b942-10b4dba3618e` ---
**Author:** ![Greg](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/greg/32/6871_2.png) [@Greg](https://community.tempest.earth/u/Greg)\ **Post date:** [April 5, 2022, 5:59pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/6 "2022-04-05T17:59:49Z")
Maybe you can get mine to work? [https://swd.weatherflow.com/swd/rest/observations/device/22950?day\_offset=0&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299](https://swd.weatherflow.com/swd/rest/observations/device/22950?day_offset=0&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299) I took your format and changed my 2 reference, still new error: {“status”:{“status\_code”:404,“status\_message”:“NOT FOUND”}} ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 5, 2022, 6:09pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/7 "2022-04-05T18:09:02Z")
sure… you were using the wrong device\_id. You used the station\_id Try: `https://swd.weatherflow.com/swd/rest/observations/device/168731?day_offset=0&format=csv&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299` edit: I had forgotten the format=csv part ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 5, 2022, 8:28pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/13 "2022-04-05T20:28:43Z")
A better call could be [`(https://swd.weatherflow.com/swd/rest/observations/device/168731?day_offset=0&format=csv&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299)`](https://swd.weatherflow.com/swd/rest/observations/device/168731?day_offset=0&format=csv&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299) Make sure you set “do not detect data types” as otherwise the values get all screwed up. Get your device id from settings/stations/status ![Untitled-2](https://us1.discourse-cdn.com/flex020/uploads/sws/original/2X/d/d910d5e4481be5e5bd70f83d7bdf502ee3ca79a0.jpeg) ---
**Author:** ![14quaioui](https://avatars.discourse-cdn.com/v4/letter/1/dfb087/32.png) [@14quaioui](https://community.tempest.earth/u/14quaioui)\ **Post date:** [April 11, 2022, 6:45am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/24 "2022-04-11T06:45:33Z")
Sunny, thank you for this. It is rather useful, and for many owners I would guess ---
**Author:** ![g-woolf](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@g-woolf](https://community.tempest.earth/u/g-woolf)\ **Post date:** [April 12, 2022, 10:13am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/25 "2022-04-12T10:13:45Z")
Hi It doesnt work for me I tried this [https://swd.weatherflow.com/swd/rest/observations/device/71289?day\_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844](https://swd.weatherflow.com/swd/rest/observations/device/71289?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844) I get the following error We encountered an error while trying to connect. Details: “Web.Contents failed to get contents from ‘[https://swd.weatherflow.com/swd/rest/observations/device/71289?day\_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844](https://swd.weatherflow.com/swd/rest/observations/device/71289?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844)’ (404): Not Found” I dont know why Regards Graham ---
**Author:** ![gary.lynch](https://avatars.discourse-cdn.com/v4/letter/g/ebca7d/32.png) [@gary.lynch](https://community.tempest.earth/u/gary.lynch)\ **Post date:** [April 12, 2022, 10:31am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/26 "2022-04-12T10:31:05Z")
Try [https://swd.weatherflow.com/swd/rest/observations/device/192115?day\_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844](https://swd.weatherflow.com/swd/rest/observations/device/192115?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844) ---
**Author:** ![g-woolf](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@g-woolf](https://community.tempest.earth/u/g-woolf)\ **Post date:** [April 12, 2022, 10:40am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/27 "2022-04-12T10:40:37Z")
Hi Gary Yes yours works -mine doesnt Regards Graham ---
**Author:** ![jimyouse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/jimyouse/32/7793_2.png) [@jimyouse](https://community.tempest.earth/u/jimyouse)\ **Post date:** [April 12, 2022, 10:46am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/28 "2022-04-12T10:46:39Z")
I was getting the errors at first too. I realized I was entering my Station ID, not the Device ID. When I changed to Device ID it worked. ---
**Author:** ![g-woolf](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@g-woolf](https://community.tempest.earth/u/g-woolf)\ **Post date:** [April 12, 2022, 11:01am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/29 "2022-04-12T11:01:34Z")
Hi jimyouse Thank you so much - its all working now I was using station ID too - just shows it pays to read more thoroughly Regards Graham ---
**Author:** ![rmjohnston](https://avatars.discourse-cdn.com/v4/letter/r/df705f/32.png) [@rmjohnston](https://community.tempest.earth/u/rmjohnston)\ **Post date:** [April 12, 2022, 3:21pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/30 "2022-04-12T15:21:15Z")
I’m a new Tempest owner as of yesterday. I was able to get my first download just now. Great information! Thanks to all. ---
**Author:** ![mikeseal](https://avatars.discourse-cdn.com/v4/letter/m/ad7895/32.png) [@mikeseal](https://community.tempest.earth/u/mikeseal)\ **Post date:** [April 27, 2022, 5:47pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/31 "2022-04-27T17:47:53Z")
Just a question how long does a “Token” last? Mike ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 27, 2022, 5:54pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/32 "2022-04-27T17:54:40Z")
forever, or until you delete it yourself. You can do that on the same page you request a token. ---
**Author:** ![mikeseal](https://avatars.discourse-cdn.com/v4/letter/m/ad7895/32.png) [@mikeseal](https://community.tempest.earth/u/mikeseal)\ **Post date:** [April 28, 2022, 4:48pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/33 "2022-04-28T16:48:51Z")
Hi I have tried this download a number of times but get the following response, any help would be appreciated. ![image](https://us1.discourse-cdn.com/flex020/uploads/sws/original/2X/f/fe529fe41927c86fcd2b51161cb7598f26c1260c.jpeg) ![image](https://us1.discourse-cdn.com/flex020/uploads/sws/original/2X/5/515fb551725357bc10530193212cc8d54f214512.jpeg) Thanks in advance Mike [https://swd.weatherflow.com/swd/rest/observations/device/193846?day\_offset=0&format=csv&token=0ffo3075-2114-4652-9efe-6059fd89af38](https://swd.weatherflow.com/swd/rest/observations/device/193846?day_offset=0&format=csv&token=0ffo3075-2114-4652-9efe-6059fd89af38) Sorry forgot this bit!, Mike ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [April 28, 2022, 5:49pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/34 "2022-04-28T17:49:00Z")
make sure your device id is correct and that you used the token that you generated. Currently it is not a valid token for that device. The device id should be that of the tempest, not the hub. ---
**Author:** ![r\_hansen](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@r\_hansen](https://community.tempest.earth/u/r_hansen)\ **Post date:** [June 27, 2022, 7:41pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/35 "2022-06-27T19:41:09Z")
This worked well for me. But how does one convert the “timestamp” data to a Date/GMT format. Or alternatively, does the data download include a reference Date/GMT reference to which the “timestamp” data can be related? ---
**Author:** ![sunny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/sunny/32/16368_2.png) [@sunny](https://community.tempest.earth/u/sunny)\ **Post date:** [June 27, 2022, 7:55pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/36 "2022-06-27T19:55:17Z")
it counts in second from the first jan 1970. many online converters are available. Here is one: [Unix time converter - Time.is](https://time.is/Unix_time_converter) [Next page](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118.md?page=2)