A date like 03/04/2025 reads as the 3rd of April in Europe and as the 4th of March in the United States. One cell cannot tell which; the column can. A single 15/04/2025 in the same column proves that the first number is the day, because there is no 15th month.
Column type: DATE
| In the file | Cleaned | Status |
|---|---|---|
03/04/2025 | 2025-04-03 | ambiguous |
15/04/2025 | 2025-04-15 | clean |
28/02/2025 | 2025-02-28 | clean |
01/12/2024 | 2024-12-01 | ambiguous |
09/10/2024 | 2024-10-09 | ambiguous |
Data Cleaner reads the column as a whole, settles the order from the cells that can only be read one way, and writes every date as ISO 8601 (YYYY-MM-DD). The cells that would have read differently the other way round keep a flag, is_ambiguous, so a reader can check them; the order chosen is the column's, not a guess per cell.
https://mcp.data-cleaner.com/mcp, then ask it to clean your file.curl -X POST https://data-cleaner.com/clean/v1/column \
-H 'Content-Type: application/json' \
-d '{"values": ["03/04/2025", "15/04/2025", "28/02/2025", "01/12/2024", "09/10/2024"]}'
The answers above are the API's own, captured when this page was built.