Turn text dates into real dates
A date stored as text does not sort and cannot be calculated with. The tool reads European, US and ISO dates, decides the day and month order from the evidence in the values (a day above 12), and refuses dates that do not exist.
What this tool does
- DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, with or without a time, and the compact YYYYMMDD form.
- The day and month order decided per column, never cell by cell.
- Serial numbers (a date turned into a number, such as 46023) on request.
- Impossible dates (February 31st, February 29th of a common year) flagged, not invented.
What it does not do: A column where nothing goes above 12 (03/04/2026) keeps the order of your language, unless you set it. Dates written in words ("3 April 2026") are not read yet.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.