Excel tool

Standardize Excel Dates

Remove ambiguity from date text by choosing the source convention explicitly. Invalid dates are left unchanged and reported.

Private by designRuns in your browser
Recent tools
Ctrl / ⌘ + Enter to run

Loading workspace…

Preparing the controls for this tool. Your files have not been selected or uploaded.
QUICK START

How to use Standardize Excel Dates

  1. Upload XLSX or CSV, inspect the worksheets and select the sheet. The first row is treated as headers.
  2. Choose the one-based date column, source format and output format. For 31/12/2025, choose DD/MM/YYYY.
  3. Process, review unchanged-value warnings and download the XLSX result.
BEFORE YOU BEGIN

What to expect

Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.

Local processing

Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.

Formats and example

Available source formats are DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD and Excel serial. Outputs use the chosen date text convention. With DD/MM/YYYY input, 31/12/2025 becomes 2025-12-31 when ISO-style output is selected.

Ambiguity and calendar checks

The tool does not guess whether 03/04/2025 means 3 April or March 4. Impossible calendar dates and unmatched values remain unchanged. Excel serial conversion uses the 1900 date system and rejects the fictitious serial day 60; confirm sources using the 1904 system separately.

HELP & TROUBLESHOOTING

Frequently asked questions

Why were some dates not changed?

They may not match the selected source format or may be impossible dates. Read the warnings and correct the source values instead of choosing a format at random.

Are original Excel date styles retained?

No. The exported worksheet contains values, including normalized date text, rather than the original cell styles or recalculated formulas.

Where is my input processed?

Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.