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

How to use it

  1. Paste the timestamps, one per line or separated by commas, semicolons or tabs.
  2. Leave the unit on automatic detection, or pick seconds, milliseconds, microseconds or nanoseconds.
  3. Choose the output format and the timezone, then read or copy the results table.

Things worth knowing

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.

All the tools