Spreadsheet tools Free · No sign-up · No upload

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
Choose spreadsheetsor drop them here · XLSX, XLS, ODS, CSV, XLSM
Sheet name or number (several: 1, 3). Leave empty for every sheet. Not used for CSV.
Leave empty to find date columns automatically, or name them: Order date, F.
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: XLSX → OUT: XLSX
How was Normalize date columns?
How it works

Normalize date columns in three steps

No account, no email, no waiting for an upload.

  1. 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.

  2. 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.

  3. STEP 03

    Download

    The note shows how many dates were converted and how many values could not be read.

What you get

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.
Private by design

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 device→Their server→Your device

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

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

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.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends 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.

FAQ

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.