# 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:** 4
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 2:48pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/79 "2023-10-02T14:48:35Z")
So, on the first part, when I click the first “Get”, and before I hit “try it out”, I get the not found error. ![image](https://us1.discourse-cdn.com/flex020/uploads/sws/original/2X/f/f495dc67e38de0d9a035365f40b750df0af62043.png) ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 2:56pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/81 "2023-10-02T14:56:03Z")
The last block says success. ![image](https://us1.discourse-cdn.com/flex020/uploads/sws/original/2X/1/140d1a076f2e908c3353a27e00f7d3cf4572af28.png) ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 3:00pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/82 "2023-10-02T15:00:12Z")
Could it be that I haven’t shared the station publicly? I just saw the knowledgebase article on finding station ID and it mentions setting it to shared publicly. ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 3:03pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/83 "2023-10-02T15:03:43Z")
No, I guess not. I just looked and that is set by default apparently. ---
**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:** [October 2, 2023, 3:12pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/85 "2023-10-02T15:12:51Z")
or you can go to settings/stations/status it will list the device id ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 3:19pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/86 "2023-10-02T15:19:43Z")
Okay, so 119813 I think is the device ID of the hub. The body of text referenced 298688 and that is the devide ID under the Tempest device. Going to try that. ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 3:21pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/87 "2023-10-02T15:21:28Z")
Bingo! That worked! Again, I think instructions in your inital post regarding how to find the device ID would be most helpful! Thanks again! ---
**Author:** ![karss](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/karss/32/16530_2.png) [@karss](https://community.tempest.earth/u/karss)\ **Post date:** [October 2, 2023, 3:21pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/88 "2023-10-02T15:21:59Z")
You need to use the device ID of the Tempest device. This works: [https://swd.weatherflow.com/swd/rest/observations/device/298688?day\_offset=0&format=csv&token=770e7711-b879-4a8a-aa3d-bc655c7227c7](https://swd.weatherflow.com/swd/rest/observations/device/298688?day_offset=0&format=csv&token=770e7711-b879-4a8a-aa3d-bc655c7227c7) just copy paste in a browser and hit return, will download the csv file. ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 3:45pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/89 "2023-10-02T15:45:09Z")
I’ve used the formula given to convert unix timestamp and it works fine. My timestamp in the first row of data is 10/2/2023 12:00am as expected but, the last entry says 3:34PM but it’s only 11:43AM as I write this. My timezone is GMT-5:00. I’ve tried using "-18000) where you have 7200 in the formula in this post but then all I get are “#” in the cells meaning Excel can’t interpret the data according to the format. Any ideas? ---
**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:** [October 2, 2023, 3:49pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/90 "2023-10-02T15:49:28Z")
=(($D2+7200)/86400)+DATE(1970,1,1) make your column wider (the answer doesn’t fit your column) and make sure you format the column as a date. ---
**Author:** ![insixdays41705](https://avatars.discourse-cdn.com/v4/letter/i/47e85d/32.png) [@insixdays41705](https://community.tempest.earth/u/insixdays41705)\ **Post date:** [October 2, 2023, 4:25pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/91 "2023-10-02T16:25:25Z")
I did not have an option for 4-digit year with time. I think that was the issue. I’ve got it working now but with 2-digit year. Thanks for all you help! You’ve been great! ---
**Author:** ![jmhalleman](https://avatars.discourse-cdn.com/v4/letter/j/ac91a4/32.png) [@jmhalleman](https://community.tempest.earth/u/jmhalleman)\ **Post date:** [October 8, 2023, 6:54pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/94 "2023-10-08T18:54:58Z")
I want to download my weather data to a Microsoft Windows Excel spreadsheet. Can someone point me to the information? Thank you. Regards, ---
**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:** [October 8, 2023, 7:47pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/95 "2023-10-08T19:47:02Z")
as simple as using the search option with the word Excel … and voilà … I even added your post to the end of it. Happy reading ---
**Author:** ![kimhuy.sok12](https://avatars.discourse-cdn.com/v4/letter/k/df788c/32.png) [@kimhuy.sok12](https://community.tempest.earth/u/kimhuy.sok12)\ **Post date:** [March 29, 2024, 3:06am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/96 "2024-03-29T03:06:42Z")
Hi Sunny! I am Kimhuy, a new user of Tempest station. Thanks Sunny for your useful link to download the data from Tempest. I wonder if we can download data from Tempest station for a specific duration using your provided link. For example from 01/Jan/2024 to 01/Mar/2024 Regards, Kimhuy ---
**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:** [March 29, 2024, 8:19am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/97 "2024-03-29T08:19:51Z")
you can by using the time\_start and time\_end options instead of day\_offset, but the resolution of the data might be reduced. Click an the API button on top of this page to get info on how to use that. You’ll have to enter the times in unix time. for example midnight 01/jan/2024 would be 1704067200 ---
**Author:** ![harjassingh02](https://avatars.discourse-cdn.com/v4/letter/h/e68b1a/32.png) [@harjassingh02](https://community.tempest.earth/u/harjassingh02)\ **Post date:** [March 30, 2024, 11:48pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/98 "2024-03-30T23:48:10Z")
Thanks for a great trick to get this data, I managed to do so with ease thanks to everyone who has contributed their advice. I’m most interested in air temperature, for which this script imports in degrees C to the nearest tenth…does anyone have a clue as to how I can either a) import it as F (i doubt it) or b) import as C but to the hundredth’s or thousandth’s place? P.S. Thank you @sunny for your suggestion of the time\_start and time\_end tip…I referenced the API like you said at it works great…what a lucky time for me to stumble upon this thread a day after you mentioning it lol ---
**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:** [March 31, 2024, 3:38pm UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/99 "2024-03-31T15:38:23Z")
you should be able to convert it to Fahrenheit in excel, and no, you cannot have temperatures with a precision of 0.001. You will have a hard time finding a consumer device that does that. ---
**Author:** ![mabeatty1978](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/mabeatty1978/32/15139_2.png) [@mabeatty1978](https://community.tempest.earth/u/mabeatty1978)\ **Post date:** [August 28, 2024, 1:30am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/100 "2024-08-28T01:30:55Z")
To add on to this thread a little. I made a dynamic Google Sheets doc that accepts any time/date start/end range to return any values between those two time stamps. Just enter your access token and Device ID and adjust the dates to your liking > **[WeatherFlow Data Public](https://docs.google.com/spreadsheets/d/1DFtGTvGaJkt7l3M8HvALVxZkVu6rgM_BOXHUoJrNRVs/edit?usp=sharing)** > > This Sheet is private ---
**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:** [August 28, 2024, 6:52am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/101 "2024-08-28T06:52:01Z")
why not share your file? currently it is set to private. ---
**Author:** ![mabeatty1978](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tempest.earth/mabeatty1978/32/15139_2.png) [@mabeatty1978](https://community.tempest.earth/u/mabeatty1978)\ **Post date:** [August 28, 2024, 11:45am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/102 "2024-08-28T11:45:04Z")
It’s shared…it should be available for anyone with the link to view. If I open an incognito window and browse to it not logged into Google, it pulls up just fine. You can’t edit it, but you can download a copy of it and edit it that way. Does it not pull up for you? [Previous page](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118.md?page=3) [Next page](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118.md?page=5)