In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

    Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.

    Published in Microsoft Excel

    Unix Timestamp Converter

    Converter

    Insert your 10 digit timestamp number into the relevant field and click on view results to covert it to a readable  date.