Espace Agent SheetClean AI
Standardize Excel Dates
Fix mixed, broken, and text dates. Converts serial dates and irregular formats into ISO YYYY-MM-DD instantly.
Déposez votre feuille de calcul ici ou cliquez pour parcourir
Prend en charge les fichiers .xlsx, .xls et .csv jusqu'à 50 Mo
Date Normalization
End Excel Date Format Frustrations
Inconsistent dates are the #1 cause of failed CRM, Shopify, and SQL imports. SheetClean fixes them deterministically.
ISO 8601 Output
Outputs unambiguous YYYY-MM-DD dates natively supported by PostgreSQL, MySQL, BigQuery, and Salesforce.
Serial & Epoch Recovery
Identifies Excel 1900-system day counts (like 44927) and Unix epoch timestamps without corrupting true numeric fields.
Time Component Preservation
Optionally preserve hours, minutes, and seconds in ISO datetime format (YYYY-MM-DD HH:mm:ss).
FAQ
Frequently Asked Questions
Clear answers about Excel and CSV date formatting.
Why does Excel store dates as random 5-digit numbers like 45321?▼
Excel internally stores dates as serial numbers counting days since January 1, 1900. When formatting is lost during CSV export or copy-paste, they appear as numbers. Our engine recognizes serial dates and restores readable ISO calendar dates.
How does it handle ambiguous US (MM/DD) vs European (DD/MM) dates?▼
The Agent analyzes the distribution across the entire column to determine the predominant date convention before executing standardization.
Can I choose my desired output date format?▼
Yes. You can output to ISO standard YYYY-MM-DD (recommended for databases and CRM imports), DD/MM/YYYY, or MM/DD/YYYY.
Does this repair dates that Excel misclassifies as text?▼
Yes. Invisible spaces or leading apostrophes often trap dates as text. Our cleaner sanitizes the string and standardizes it into a valid date.