Free tool
Fix the dates in your CSV
03/04/2024, 2024-04-03 and 3 Apr 2024 in one column? Drop the file and every date comes out in one format your import accepts.
Free, no sign-up. Your file is read in this browser tab and never uploaded.
How it works
- Finds the date columns by reading the cells, not the header.
- Works out whether 03/04 means 3 April or March 4 from dates like 25/12 in the same file. A cell whose own numbers settle it is read that way.
- Rewrites each date it can read. Any other cell is kept exactly as written and listed, so nothing is guessed silently.
What it reads
2024-04-033/4/2024, 03.04.2024, 03-04-20243 Apr 2024, Apr 3, 20243/4/242024/04/03
Two-digit years: 00 to 68 are the 2000s, 69 to 99 the 1900s. A time after the date is dropped.
Questions
- Is my file uploaded?
- No. The file is read by this page inside your browser tab. Nothing is sent to a server.
- Which dates are kept as written?
- Impossible dates like 31/02/2024, and text that is not a date. They are listed first in the preview so you can fix them by hand.
- Is there a row limit?
- No row limit. Files over 50 MB are refused because a browser tab runs out of memory.