Timestamp Batch Converter

Convert multiple timestamps between formats at once

Input (one per line)

Output

1704067200
2024-01-01T05:30:00
1704153600
2024-01-02T05:30:00
1704240000
2024-01-03T05:30:00
2024-01-15T10:30:00Z
2024-01-15T16:00:00
2024-01-20 14:00:00
2024-01-20T14:00:00
5 timestamps • 5 valid

Related Tools

Batch Timestamp Converter

A powerful developer tool designed to convert mixed lists of timestamps into a single, uniform format. Whether you're parsing server logs, cleaning database exports, or debugging API responses, this tool handles thousands of lines instantly—all within your browser.

Supported Input Formats

  • Unix Timestamp (Seconds) 1704067200 Standard 10-digit epoch time.
  • Unix Timestamp (Milliseconds) 1704067200000 Common in JavaScript `Date.now()`.
  • ISO 8601 / RFC 3339 2024-01-01T00:00:00Z The international standard for date interchange.

Why Use This Tool?

  • 📊 Normalization: Turn a messy list of mixed ID types (seconds vs ms) into a clean ISO column for CSVs.
  • 🌎 Timezone Conversion: Instantly see what `1704067200` corresponds to in your local time vs UTC.
  • 🔒 Data Privacy: Data never leaves your device. Process sensitive logs without sending them to a server.

Understanding Time Formats

What is Unix Time?

Unix time (or Epoch time) is the number of seconds that have elapsed since January 1, 1970, at 00:00:00 UTC. It is widely used in computing because it represents time as a single number, making it easy to sort and calculate differences.

What is ISO 8601?

ISO 8601 is the international standard for representing dates and times. It typically looks like `YYYY-MM-DDTHH:mm:ss.sssZ`. The `Z` at the end indicates UTC time (Zulu time), ensuring no ambiguity across time zones.

Frequently Asked Questions

My input has mixed seconds and milliseconds. Will it work?
Yes! The parser automatically detects if a number is 10 digits (seconds) or 13 digits (milliseconds) and processes them correctly in the same batch.
Can I convert Excel dates?
Not directly. Excel stores dates as the number of days since Dec 30, 1899. This tool handles standard string dates and Unix timestamps. For Excel, convert the column to text/ISO format within Excel first.
Is there a limit to how many lines I can paste?
Since processing is client-side, the only limit is your browser's memory. Pasting 10,000+ lines typically takes just a fraction of a second on modern devices.