Home / Tools / Date & Timezone Normalizer

CSV & data

Date & Timezone Normalizer

Turn messy dates into a timezone you choose, as ISO 8601.

About $1 per 1,000 dates.

Try it on Apify
Date & Timezone Normalizer — Turn messy dates into a timezone you choose, as ISO 8601.

It reads dates like "March 5, 2024 3:30pm" and dates that could be read two ways. You get ISO 8601, UTC, and a Unix timestamp. Strings it cannot parse are free.

What it does

  • Parses messy dates, times, and relative phrases like "tomorrow at 2pm".
  • Converts each result to a timezone you choose.
  • Returns ISO 8601, UTC, a Unix timestamp, and an optional custom format.
  • Marks numeric dates that could be read two ways (for example 03/04/05) as ambiguous.

Before and after

Messy dates

March 5, 2024 3:30pm
2024-03-05T15:30:00Z
05/03/2024
not a date at all
source: America/Chicago   target: UTC

Normalized to UTC (from the Actor test)

March 5, 2024 3:30pm   →  2024-03-05T21:30:00+00:00
2024-03-05T15:30:00Z   →  2024-03-05T15:30:00+00:00
05/03/2024             →  2024-05-03 (flagged as ambiguous; also 2024-03-05)
not a date at all      →  not parsed, not charged

From date-timezone-apify/tests/test_actor.py.

Get it

Pay per use · Apify · $0.001 per date

Blank lines, repeats, and strings we cannot parse are free.

Try it on Apify

FAQ

What does this tool do?

Turn messy dates into a timezone you choose, as ISO 8601. It reads dates like "March 5, 2024 3:30pm" and dates that could be read two ways. You get ISO 8601, UTC, and a Unix timestamp. Strings it cannot parse are free.

What does it cost?

Pay per use on Apify costs $0.001 per date. Blank lines, repeats, and strings we cannot parse are free.

Will you see my files?

The download tools run on your computer, so those files stay with you. The Apify tools run in your own Apify account. This website does not take uploads.