Batch Epoch Converter

Paste a list of timestamps or dates, one per line, and convert all of them in one go. Numbers become ISO dates and dates become seconds or milliseconds.

Use the tool

Why this tool exists

A log excerpt or a database export may hold hundreds of epoch values. Converting them one at a time in a single-value converter is painful, and writing a throwaway script for every incident is no better.

This tool processes a whole list at once. Each numeric line becomes an ISO 8601 UTC date, and each date line becomes a Unix timestamp in seconds, or in milliseconds if you tick the option. A line that cannot be parsed gets its own error message, but the other lines still convert. That makes it easy to spot the odd row in a long list. Processing is local.

How to use it

  1. Paste your values, one per line: epoch numbers, ISO dates or other date strings.
  2. Leave the numeric unit on auto, or choose seconds or milliseconds.
  3. Tick "Dates to milliseconds" if you want dates converted to milliseconds instead of seconds.
  4. Copy the converted lines.

Frequently asked questions

How does it decide between converting to a date or to a number?

Lines that are purely numeric are treated as timestamps and shown as ISO dates. Any other line is parsed as a date and shown as a timestamp.

What happens when a line is invalid?

That line shows ERROR with the reason, and the remaining lines are converted normally. Your output keeps the same order as your input, so you can find the bad row.

Are results in UTC?

Timestamps are converted to ISO 8601 in UTC, ending in Z. A date string without a zone is read in your local time before it is turned into a timestamp, so add Z or an offset for exact results.

How does it tell seconds from milliseconds?

On auto, by size: roughly 10-digit values are seconds and 13-digit values are milliseconds. If your data mixes units unusually, set the unit explicitly.