How to standardize date formats in a CSV file

Your CSV has dates in every format imaginable: MM/DD/YYYY, DD-Mon-YY, January 15 2024. You need them all in one consistent format.

This guide uses the spreadsheet editor. Jev adds decision columns instead.

Open Magic CSV

spreadsheet editor example

Prompt
"Standardize all dates to YYYY-MM-DD format"
Before
#order_iddateamount
1ORD-00112/15/2024$125.00
2ORD-002Jan 3, 2025$89.50
3ORD-0032024-11-28$210.00
After
#order_iddateamount
1ORD-0012024-12-15$125.00
2ORD-0022025-01-03$89.50
3ORD-0032024-11-28$210.00

Why use the spreadsheet editor for this?

  • Convert any date format to your standard
  • Fix inconsistent dates from multiple sources
  • Prepare data for databases and imports

Related guides

Continue in the spreadsheet editor.

Use the spreadsheet editor, AI columns, and cleanup tools within the same Magic CSV account.

How to standardize date formats in a CSV file | Magic CSV