--- title: Understand and Convert Hexoskin Timestamps description: This article explains how to convert the Hexoskin CSV data file timestamps from UNIX to human date and time. --- [Skip to content](https://support.hexoskin.com/understand-and-convert-hexoskin-timestamps#main-content) English Show submenu for translations [More support](https://support.hexoskin.com/kb-tickets/new?hsLang=en) [![Hubspot - Hexoskin Logo - Rectangle](https://support.hexoskin.com/hubfs/Hubspot%20-%20Hexoskin%20Logo%20-%20Rectangle.svg)](https://support.hexoskin.com/?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://support.hexoskin.com/kb-tickets/new) - [Contact us](https://support.hexoskin.com/kb-tickets/new) [Contact us](https://support.hexoskin.com/kb-tickets/new?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Hexoskin Support Community](https://support.hexoskin.com/?hsLang=en) 2. [Hexoskin Data Analysis](https://support.hexoskin.com/hexoskin-data-analysis?hsLang=en) # Understand and Convert Hexoskin Timestamps ## This article explains how to convert the Hexoskin CSV data file timestamps from UNIX to human date and time. The CSV files of a Hexoskin record or range (activity), the timestamps are formatted as on the image below: ![](https://support.hexoskin.com/hs-fs/hubfs/Screenshot%202024-07-31%20at%201-12-16%E2%80%AFPM-png.png?width=115&height=375&name=Screenshot%202024-07-31%20at%201-12-16%E2%80%AFPM-png.png) These timestamps can be converted into human-readable date and time values by following the simple steps shown in this article. ### **Step 1: Conversion Into UNIX Epoch Format** To convert the "Hexoskin" timestamps into "Unix Epoch" timestamps, divide each of them by 256 as seen in the image below: **![](https://support.hexoskin.com/hs-fs/hubfs/image-png-Jul-31-2024-05-14-14-2997-PM.png?width=261&height=406&name=image-png-Jul-31-2024-05-14-14-2997-PM.png)** **NOTE:** If using Astroskin data, divide the initial "Astroskin" timestamps by 1000 instead of 256.   UNIX Epoch is a widely used timestamp format in computing that encapsulates both date and time as a single numerical value. This number represents the total seconds that have elapsed since January 1, 1970. ### Step 2: Conversion Into Human-Readable Time (GMT) To convert UNIX Epoch timestamps into human-readable date and time format in GMT, first use the following formula: **Human-Readable Time (GMT) = (“Time (Unix)” / 86400) + 25569** Once this is done, on Excel, be sure to then change the data format to "Short Date", "Long Date" and/or “Time” to get an actual Date or Time value.  ![](https://support.hexoskin.com/hs-fs/hubfs/image-png-Jul-31-2024-04-22-14-6298-PM.png?width=168&height=393&name=image-png-Jul-31-2024-04-22-14-6298-PM.png) The image below demonstrates what your timestamps look like once you have completed this step and changed the data format into "Time": **![](https://support.hexoskin.com/hs-fs/hubfs/Screenshot%202024-07-31%20at%201-15-43%E2%80%AFPM-png.png?width=457&height=443&name=Screenshot%202024-07-31%20at%201-15-43%E2%80%AFPM-png.png)** **NOTE:** You can also use an online UNIX Epoch timestamp [converter](https://www.epochconverter.com/). ### **Step 3 (if needed): Conversion Into Your Timezone** If you want to get your timestamps in your specific timezone, you can simply subtract or add the number of seconds from which your timezone is behind or in front of the GMT timezone. For instance, if your timezone is CDT, which is 5 hours behind GMT, you should subtract 18000 (i.e. -5h \* 3600s) from your UNIX GMT value. ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXeU_MuB0NufohdTGFQdS4hMqRXhTDoYPJh9a79N0WILPuDQ6nv0oZpMZxuuMUrRaJpGqnn98az7LiZjcq6JnQCgEHL7daat4FNG1Lo6Q0SL74n4QTABVWok4yYvabxZfCJpIhWDA6ue2JMfRBDD8lZ-JRxh?key=gwOJZKdNmU0t9uqwnqLy_g) You can use this reference to find the proper number of seconds you should add or subtract from the UNIX GMT value to get your specific timezone: [https://www.epochconverter.com/timezones](https://www.epochconverter.com/timezones)    Please don't hesitate to reach out to [support@hexoskin.com](mailto:support@hexoskin.com) if you have any questions or need further assistance. - [Hexoskin OneSync Software](https://support.hexoskin.com/hexoskin-onesync-software?hsLang=en#main-content) - [Hexoskin OneSync Advanced Features](https://support.hexoskin.com/hexoskin-onesync-software?hsLang=en#hexoskin-onesync-advanced-features) - [Hexoskin OneSync Basics](https://support.hexoskin.com/hexoskin-onesync-software?hsLang=en#hexoskin-onesync-basics) - [Hexoskin Data Analysis](https://support.hexoskin.com/hexoskin-data-analysis?hsLang=en) - [Hexoskin Support Topics](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#main-content) - [Hexoskin Mobile App](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#hexoskin-mobile-app) - [Hexoskin Articles](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#hexoskin-articles) - [Hexoskin Set-up and Configuration](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#hexoskin-set-up-and-configuration) - [Hexoskin Recorder](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#hexoskin-recorder) - [Hexoskin Troubleshooting](https://support.hexoskin.com/hexoskin-support-topics?hsLang=en#hexoskin-troubleshooting) - [Hexoskin FAQ](https://support.hexoskin.com/hexoskin-faq?hsLang=en#main-content) - [Frequently Asked Question for the Hexoskin community](https://support.hexoskin.com/hexoskin-faq?hsLang=en#frequently-asked-question-for-the-hexoskin-community) - [Order](https://support.hexoskin.com/hexoskin-faq?hsLang=en#order) - [Hexoskin OneView dashboard](https://support.hexoskin.com/hexoskin-oneview-dashboard?hsLang=en) - [Hexoskin OneSync](https://support.hexoskin.com/hexoskin-onesync?hsLang=en) - [Hexoskin Smart Garments](https://support.hexoskin.com/hexoskin-smart-garments?hsLang=en#main-content) - [Hexoskin Device](https://support.hexoskin.com/hexoskin-smart-garments?hsLang=en#hexoskin-device) - [Hexoskin App](https://support.hexoskin.com/hexoskin-app?hsLang=en) - [Hexoskin Dashboard](https://support.hexoskin.com/hexoskin-dashboard?hsLang=en) - [Help for Developers](https://support.hexoskin.com/help-for-developers?hsLang=en) - [Ordering Your Hexoskin](https://support.hexoskin.com/ordering-your-hexoskin?hsLang=en) - [Hexoskin Support](https://support.hexoskin.com/hexoskin-support?hsLang=en) [![Hexoskin - Logo - No Tagline - Rectangle - White - Transparent-Nov-28-2023-04-38-48-1716-PM](https://support.hexoskin.com/hs-fs/hubfs/Hexoskin%20-%20Logo%20-%20No%20Tagline%20-%20Rectangle%20-%20White%20-%20Transparent-Nov-28-2023-04-38-48-1716-PM.png?width=200&height=50&name=Hexoskin%20-%20Logo%20-%20No%20Tagline%20-%20Rectangle%20-%20White%20-%20Transparent-Nov-28-2023-04-38-48-1716-PM.png "Hexoskin - Logo - No Tagline - Rectangle - White - Transparent-Nov-28-2023-04-38-48-1716-PM")](https://hexoskin.com) 5800, Saint-Denis, Suite 601, Montréal (Québec), Canada Copyright © 2026, Hexoskin