Dates written in words: German, French and Italian months to ISO 8601

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 fileCleanedStatus
4 März 20252025-03-04clean
12 janvier 20242024-01-12clean
3 aprile 20232023-04-03clean
1. Mai 20222022-05-01clean
25 décembre 20212021-12-25clean

What happened

The month names of each language are read, with their accents, and every cell becomes an ISO 8601 date. The column may mix languages.

Do it yourself

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.

More guides