How ambiguous dates are handled
03/04/2024 is 3 April in most of the world and March 4 in the US. The tool looks at the whole column: if any value is impossible as month-first (like 25/04/2024), the column is read day-first, and the other way round. Only when a column has no such clue is your choice used. If a column mixes both styles, ambiguous values are left unchanged instead of guessed.
Supported formats
ISO dates (2024-01-05, 2024/1/5), numeric dates with /, - or . separators and two- or four-digit years, and written dates such as “5 Jan 2024”, “January 5, 2024” or “Friday, 5th January 2024”, with or without a time. Times are kept after the converted date. Values that are not dates are never changed.
Why YYYY-MM-DD
ISO 8601 dates sort correctly as text, cannot be misread in another country and are accepted by every database and programming language. If the file is for people in one country, DD/MM/YYYY or MM/DD/YYYY may be friendlier, so those are available too.