Cleanup Unix Time

Modified on Wed, 24 May 2023 at 02:04 PM

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 atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article