SmartTechnology solutions for business

Table Date Format Normalizer

Read stated date formats, convert them to one format, and ask you to resolve ambiguous values such as 03/04.

A table or a list of dates. Only cells that look like dates are changed; other cells stay as they are.

How the dates are written now
Write them as

Your result

Paste a table with dates, then choose how they are written now.

How to use it

  1. Paste or upload the table.
  2. Choose how the dates are written and the format you want.
  3. Check the highlighted cells and download the CSV.

Examples

  • Day/month/year05/03/2026 2026-03-05
  • Arabic digits١٢/٠٣/٢٠٢٦ 2026-03-12
  • A date that does not exist31/02/2026 Left as it is and listed
Tool details and privacy

Rewrite dates written in mixed ways in a table into one format. You tell it the current day and month order, so nothing is guessed.

03/04 can mean 3 April or 4 March; a declared order prevents mistakes.

Options

  • Output: 2026-03-05, 05/03/2026 or 03/05/2026.
  • A value starting with a four-digit year is read as year/month/day.

Limits

  • The year needs four digits.
  • Month names such as "March" are not read.

Privacy

What you type or open stays in your browser. Nothing is uploaded or saved on the server.

Questions

Are non-date cells changed?

No.

What happens to an impossible date?

It stays, highlighted and listed.

Are Arabic digits accepted?

Yes.

Is the table uploaded?

No.

Related tools

All tools