Google Sheets Apps Scripts: Custom Function Convert Unix Timestamp to Date

At Google Sheets, click Tools -> Script Editor.

Edit the script and click Save.

function TIMESTAMP_TO_DATE(value) {  return new Date(value * 1000);}

Now you can use this custom function / formula in Google Sheets.

=TIMESTAMP_TO_LOCAL(1563247671)

References:

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.