Normalize Date Formats in a Spreadsheet

One column holds 03/04/2024, 2024-03-05 and 6 March 2024: sorting, filtering and every chart built on it become unreliable. Add the Normalize dates step, pick the column, and every value comes out in a single format.

Choose ISO (2024-03-05) for databases and scripts, or a day-first or month-first style for people. Values that can only be read one way are resolved automatically; when a date like 03/04/2024 is genuinely ambiguous, tell the tool which order your file uses and the rest are converted too.

Clean a Table

Remove duplicates, trim spaces, split columns, find and replace, fill blank cells. Build a cleaning recipe and export the result. The file never leaves your browser.

Your data never leaves this browser

The file is parsed, previewed and charted on your own device. Nothing is uploaded — not even a sample. Close the tab and the data is gone.

Or paste table text
Import a file to get started. Everything runs locally.

How it works

  1. 1.Import an Excel, CSV, TSV or JSON file, or paste the table. It is parsed on your own device.
  2. 2.Pick the columns to show: one category axis and up to three values.
  3. 3.Generate once, then keep tweaking — chart type, aggregation, sorting and theme update instantly.
  4. 4.Download an image, or publish the result as an encrypted link that expires on its own.

Frequently asked questions

What happens to ambiguous dates like 03/04/2024?
On the automatic setting they are left untouched, because day-first and month-first are both plausible. Pick day-first or month-first for the column and those values are converted as well.
Are times and unreadable values preserved?
A value that includes a time keeps its time after conversion. Anything the tool cannot read stays exactly as it was, so you can filter for the leftovers instead of losing them.

Related tools

Text to Columns Converter

Split one column into several in your browser: the split step is ready, pick the column and the delimiter, preview the result and export CSV or Excel.

Remove Duplicate Rows Online

Delete duplicate rows from a CSV or Excel file in your browser: keep the first occurrence, see how many rows were removed, and export the clean table.