Timestamp batch converter
Convert many Unix timestamps at once into the timezone and format you need.
About Timestamp batch converter
Converts many Unix timestamps at once. Paste a column from a log, a database export or a spreadsheet and get readable dates in the timezone and format you choose, with invalid lines flagged individually.
When you would use it
- Reading a list of epoch values from application logs or an API response without converting them one by one.
- Checking which timestamps in a database export fall in a given day once you view them in your own timezone.
- Producing ISO 8601 strings from numeric timestamps to paste into a ticket, a test fixture or a report.
How to use it
- Paste the timestamps, one per line or separated by commas, semicolons or tabs.
- Leave the unit on automatic detection, or pick seconds, milliseconds, microseconds or nanoseconds.
- Choose the output format and the timezone, then read or copy the results table.
Things worth knowing
- Automatic detection looks at the number of digits: up to 11 digits is read as seconds, 12 to 14 as milliseconds, 15 to 17 as microseconds and more as nanoseconds. A small millisecond value, such as one from 1970, looks like seconds, so set the unit by hand when you know it.
- Fractional values such as 1700000000.5 and negative values (dates before 1970) are accepted.
- A Unix timestamp has no timezone of its own. The timezone you select only changes how the moment is displayed, not which moment it is.
- Lines that are not numbers, or that fall outside the range JavaScript dates can represent, are marked with an error while the other lines are still converted.
Frequently asked questions
- Why does my timestamp show a date in 1970?
- The value is probably in milliseconds or microseconds but was read as seconds, or the other way around. Set the unit explicitly instead of using automatic detection.
- Is there a limit on how many I can paste?
- There is no fixed limit. Conversion runs in your browser, so a few thousand lines are instant, while a very large paste depends on your device.