When a timestamp is sent from a flow to a spreadsheet, it will be sent in Unix time. This format is commonly used across software and technical features. You can easily convert this timestamp using this formula:
=IF(A1="", "", TEXT(A1/1000/86400 + DATE(1970,1,1) + (2/24), "DD.MM.YYYY HH:MM:SS"))
This formula is made up of the following parts:
-
=IF(A1="", "",: highlights the cell you are pulling the timestamp from -
TEXT(A1/1000/86400 + DATE(1970,1,1): adds a formula to the Unix number in order to change it into a recognisable time and date -
+ (2/24),: Unix time is based on UTC (Coordinated Universal Time) so this is needed to change the timezone. In this example, we are translating the timestamp into German Daylight Savings time (CEST), which runs 2 hours in front of UTC. -
"DD.MM.YYYY HH:MM:SS": the final formatting of the date and time in the cell e.g. 01.01.2026 12:30:25
Here's how to use your formula in your spreadsheet.
-
Create a spreadsheet to collect your data. Add the columns you want to add data from each attribute to. Add in a timestamp column, and add a "Converted time" column to the right hand side of it.
-
Make sure your flow is connected to your spreadsheet, with the right attributes being sent to the right columns. You will not need to factor in your "Converted time" column here, as we will be adding the formula separately.
- Test your flow so data pulls into your sheet.
- Add the following formula in your "Converted time column":
=IF(D1="", "", TEXT(D1/1000/86400 + DATE(1970,1,1) + (2/24), "DD.MM.YYYY HH:MM:SS"))
In my example, I have added D1, as that is the column my timestamp is. Please change the column according to where you've sent your timestamp.