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.g., DD/MM vs MM/DD)
  • Dry-run mode to preview changes before writing output

Usage

python fix_dates.py input.xlsx --sheet Sheet1 --columns 'Date' 'Timestamp' --output clean.xlsx

Requirements

Python 3.8+. Install dependencies:

pip install -r requirements.txt

Download

Buy for $29 →

Buy once, download immediately. ZIP includes the full script, README, and usage examples.

License

Personal & Commercial Use. You may use this tool in your own personal and commercial projects. Redistribution or resale of the source code is not permitted.