CleanCSV

Standardize Date Formats in CSV and Excel Files

Turn “5 Jan 2024”, “01/05/24” and “2024-1-5” into one consistent format. Day-first and month-first columns are detected from your data.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above.

  2. 2

    Standardize dates is on and set to YYYY-MM-DD. Date columns are detected automatically, or you can choose them yourself.

  3. 3

    Pick the output format, and how to read columns that only contain ambiguous dates such as 03/04/2024.

  4. 4

    Check the converted dates in the preview, then download.

How ambiguous dates are handled

03/04/2024 is 3 April in most of the world and March 4 in the US. The tool looks at the whole column: if any value is impossible as month-first (like 25/04/2024), the column is read day-first, and the other way round. Only when a column has no such clue is your choice used. If a column mixes both styles, ambiguous values are left unchanged instead of guessed.

Supported formats

ISO dates (2024-01-05, 2024/1/5), numeric dates with /, - or . separators and two- or four-digit years, and written dates such as “5 Jan 2024”, “January 5, 2024” or “Friday, 5th January 2024”, with or without a time. Times are kept after the converted date. Values that are not dates are never changed.

Why YYYY-MM-DD

ISO 8601 dates sort correctly as text, cannot be misread in another country and are accepted by every database and programming language. If the file is for people in one country, DD/MM/YYYY or MM/DD/YYYY may be friendlier, so those are available too.

Frequently asked questions

Will Excel dates come through correctly?

Yes. Dates stored as Excel dates are read as YYYY-MM-DD when you upload a workbook, so they are never ambiguous, and Excel downloads store YYYY-MM-DD values as real dates again.

What about two-digit years?

Years 00–29 become 2000–2029 and 30–99 become 1930–1999, the same rule Excel uses.

Can I convert only one column?

Yes. Under Standardize dates, choose Choose columns and pick the columns to convert.