Normalize date columns

Rewrite mixed dates like 3/4/24 and 4 March 2024 in one format.

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

Add your file

Choose or drop it in. It opens right here in your browser.

2

Pick the settings

Or keep the defaults, which suit most files.

3

Download

Your file is made on your own device, then saved like any download.

More spreadsheets tools

Remove duplicate Excel rowsDelete repeated rows from a sheet, comparing all or some columns.Remove duplicate CSV rowsDelete repeated rows from a CSV file and keep the first of each.Delete blank Excel rowsRemove every empty row from a sheet or CSV file.Delete empty columnsRemove columns that have no values from a sheet or CSV file.Trim Excel whitespaceStrip stray spaces from the start and end of every text cell.Find and replace spreadsheet valuesReplace text in every cell of a sheet or CSV, with regular expressions if you like.Remove spreadsheet formulas (keep values)Replace formulas with their results; XLSX formatting stays exactly as it was.Sort CSV rowsSort a CSV by one or more columns, as numbers, dates or text.