Dates in reports and exports from Switzerland, Germany, France and Italy are often written with the month's name, in the language of the author, sometimes with an ordinal dot (1. Mai 2022). A spreadsheet or pandas.to_datetime without the right locale leaves them as text.
Column type: DATE
| In the file | Cleaned | Status |
|---|---|---|
4 März 2025 | 2025-03-04 | clean |
12 janvier 2024 | 2024-01-12 | clean |
3 aprile 2023 | 2023-04-03 | clean |
1. Mai 2022 | 2022-05-01 | clean |
25 décembre 2021 | 2021-12-25 | clean |
The month names of each language are read, with their accents, and every cell becomes an ISO 8601 date. The column may mix languages.
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": ["4 März 2025", "12 janvier 2024", "3 aprile 2023", "1. Mai 2022", "25 décembre 2021"]}'
The answers above are the API's own, captured when this page was built.