Map Extract
Free tool

Unix timestamp to date converter

Paste the long number from a CSV export, an API response or a log and see the date it stands for. The tool works out whether it is in seconds, milliseconds or microseconds on its own, and shows the current Unix time ticking above.

Runs in your browser. Nothing you enter is uploaded.

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.

Input
1789000000123456
Result
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

  1. 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.

  2. 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.

  3. 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

Top