Spreadsheet Date Import Fixer
Fixes common date parsing issues when importing Excel files into databases or data pipelines. Ideal for data analysts and engineers who need clean, consistent date formats from spreadsheets with mixed or ambiguous date strings. Works with any Excel file (.xlsx, .xls) and outputs standardized ISO 8601 dates. Features Auto-detect and parse multiple date formats (e.g., ‘22/05/2026’, ‘05/22/2026’, ‘2026-05-22’) Handle timezone offsets and named timezones (e.g., ‘13:26 EDT’, ‘13:26 UTC-4’) Output to CSV or new Excel file with consistent datetime columns Configurable fallback for ambiguous dates (e....