Normalize Date Columns
Turn a messy column of dates into one consistent format. It spots the date columns for you, handles day-first and month-first, and runs entirely in your browser.
- Free, no sign-up
- Files stay on your device
- Day-first or month-first
- Real Excel dates
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Normalize date columns in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your file
Load a spreadsheet from your device: XLSX, XLS, ODS or CSV. Keep the sheet box blank to cover all sheets.
- STEP 02
Choose the format
Pick how dates should be written, and which order to assume for unclear ones like 03/04/2024. Name the date columns, or let them be found automatically.
- STEP 03
Download
The note shows how many dates were converted and how many values could not be read.
What Normalize date columns does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Finds date columns itselfA column counts as dates when most of its filled cells are dates. You can also name columns by header or letter.
- Many input stylesReads 2024-03-31, 31/03/2024, 3.4.24, 31 March 2024, Mar 31, 2024 and similar, with optional times.
- Seven output formatsISO 2024-03-31, 31/03/2024, 03/31/2024, 31-03-2024, 31.03.2024, 31 Mar 2024 and Mar 31, 2024.
- Smart day and month orderIf any value in a column has a first or second number above 12, the order for the whole column is worked out from it.
- Real dates in ExcelText dates in a workbook become true Excel dates with your chosen format, so sorting and date maths work.
Good to know
- Truly ambiguous columnsIf every value could be read either way, the tool uses your day-first or month-first choice. Check a few results.
- Unreadable values are left aloneAnything that is not recognised as a date, such as TBD, stays as it was and is counted in the note.
- In CSV the result is textA CSV has no date type, so dates are written as text in the format you chose. Two-digit years below 50 become 20xx and others 19xx.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Normalize date columns
Combine data from two countries
Make UK and US date styles agree.
Prepare for sorting and pivots
Consistent dates sort correctly and group by month.
Clean order exports
Marketplaces write dates in different styles.
Get ISO dates for code
Produce year-month-day text for databases.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
The 03/04/2024 problem
Is it 3 April or March 4? The answer depends on the country that wrote it. This tool looks at the other values in the same column. One entry like 25/03/2024 proves the column is day-first, and one like 03/25/2024 proves it is month-first. Only when nothing settles it does your choice apply.
Excel dates and text dates
Cells that are already real Excel dates just get the new display format. Cells that hold date-like text are converted into real dates. Times, if present, are kept with the date.
Imported a CSV where only year-month-day dates became real dates? CSV to Excel handles those, and this tool covers the rest. For text numbers that need the same treatment, use Convert numbers stored as text, then check results with Spreadsheet column statistics.
Questions, answered
How do I convert text dates to real dates in Excel?
Add the file, choose a format and download. Text dates in the date columns become real Excel dates.
Are my dates and records sent to a server?
No. The file is processed in your browser.
How does it decide between day-first and month-first?
It checks the column for a value that only fits one order. If there is none, it uses your setting.
What happens to values that are not dates?
They are left untouched and counted in the summary.
Does it work on CSV files?
Yes. The dates are rewritten as text in your chosen format.
Can I use it on Android, iPhone, Mac or Windows?
Yes, it runs the same way in Chrome, Safari, Edge and Firefox on every platform.