Example: a date column in a CRM export that makes no sense
A sales manager exports contacts from a CRM to check who was last emailed, and the column last_contacted holds values like 1789000000123456. Excel shows it as a huge number in scientific notation.
Pasted here, it is recognised as microseconds: Thursday 10 September 2026, 00:26:40 UTC. The UK was on British Summer Time that day, so the Your time row reads 01:26:40 BST, an hour later.
1789000000123456
Read as microseconds UTC Thu, 10 Sep 2026 00:26:40 GMT ISO 8601 2026-09-10T00:26:40.123Z Your time Thursday, 10 September 2026 at 01:26:40 BST
Converting either way
Paste the timestamp
Enter a whole number, with or without a minus sign. Ten digits is usually seconds, thirteen milliseconds and sixteen microseconds; the Read as row says which was assumed.
Copy the format you need
Each row (UTC, ISO 8601, your local time and how many days away it is) has its own copy button.
Go from a date to Unix time
Use the Date and time (UTC) to Unix time box at the bottom: choose the moment and copy the seconds shown next to it into a filter or a query.
Terms you will meet in exports and APIs
- Unix time (epoch time)
- The number of seconds since 00:00:00 UTC on 1 January 1970, not counting leap seconds. It is the same everywhere in the world at a given moment.
- Milliseconds timestamp
- The same count multiplied by 1,000. JavaScript, many CRMs and most web tracking tools use this form, which is why their values have thirteen digits.
- Year 2038 limit
- Older software that keeps the count in 32 bits can only reach 2,147,483,647 seconds, which arrives early on 19 January 2038. Current systems use bigger numbers, but legacy databases can still be affected.
Questions people ask
How do I know if a timestamp is in seconds or milliseconds?
Count the digits. A present-day timestamp in seconds has ten digits, such as 1767225600, and in milliseconds thirteen, such as 1767225600000. Both of those are midnight UTC on 1 January 2026. The converter decides from the size of the number and tells you which reading it used.
How do I convert a Unix timestamp in Excel?
For seconds, divide by 86,400 and add the date 1 January 1970, then format the cell as a date and time: =A2/86400+DATE(1970,1,1). For milliseconds divide by 86,400,000 instead. The result is in UTC, so add an hour for dates in British Summer Time if you need UK local time.
What is the Unix time for the start of the 2026/27 tax year?
Midnight UTC on 6 April 2026 is 1775433600. UK clocks were already on British Summer Time, so midnight in London that day came an hour earlier, at 1775430000. Use the date box to check any other boundary you want to filter on.
Where your data goes
Timestamps are decoded by the page using your device's clock and time zone settings. No value you paste is sent over the network.
Checked against the tool on