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
- Paste the CSV and name the date column.
- Choose DMY or MDY for numeric dates.
- Pick the output format.
- 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.