Cleanup Unix Time

Modified on Fri, 26 Apr at 8:34 AM

The Convert Unix Time function converts Unix timestamps or Epoch time to UTC format . You can add an offset of your choice to account for time zone variance. You may search the list for a specific time zone offset (e.g., London) or you can enter a specific value (e.g., -2). Be sure to consider daylight savings times when you convert Unix time to UTC. 

 

You can locate the Cleanup Unix Time function under the Tools menu at the top of your sheet, or by clicking on the ☰ menu icon in any column.

To convert a column into Unix Time, follow these steps: 


Step 1. Go to Functions > Cleanup Unix Time.



Step 2. Select a column and time zone offset.







See this video for more information on Converting Unix Time in Gigasheet.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article