Date Format Normalizer for a CSV Column (Mixed Formats to ISO)

Parses numeric dates and English month-name dates in a CSV column and rewrites them in one output format, such as YYYY-MM-DD.

Use the tool

Why this tool exists

Day-month order is the usual trap: 03/04/21 is 3 April in Europe and March 4 in the US. The tool does not guess; you set the order for all-numeric dates, and the summary reports how many were ambiguous.

Dates that cannot be read, or that do not exist such as 31/04/2021, are left unchanged and listed, never silently turned into something else. Two-digit years use 69 to 99 for 19xx and 00 to 68 for 20xx. Only English month names are understood.

How to use it

  1. Paste the CSV and name the date column.
  2. Choose DMY or MDY for numeric dates.
  3. Pick the output format.
  4. Copy or download the result and check the unreadable list.

Frequently asked questions

What formats are read?

YYYY-MM-DD, YYYYMMDD, D/M/Y and M/D/Y with / - or ., 4 March 2021, March 4 2021 and 4th Mar 21.

Times?

A time after an ISO date is dropped.

Why was a date unchanged?

It was not recognised or not a real calendar date.

Verified?

Checked against Python dateutil on a sample; differences were limited to cases where dateutil guesses the order.