# Excel trick to get data directly from tempest

**URL:** <https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118>\
**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:** 1\
**Showing post:** 39

<div class="post-metadata">

**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:** [July 9, 2022, 11:32am UTC](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118/39 "2022-07-09T11:32:09Z")

</div>

so the formula to convert unix time to date/time in excel is =(($D2+7200)/86400)+DATE(1970,1,1) and in order to display the date and time, format the column to have a custom format “dd/mm/jjjj uu:mm” Note I added 7200 seconds in order to compensate for the right time zone. You might want to add/subtract according to your time zone.

---

_[View the full topic](https://community.tempest.earth/t/excel-trick-to-get-data-directly-from-tempest/17118)._