Dates from ERP, CRM or CSV imports are often stored as text: left-aligned, green triangle, cannot sort or calculate. Upload a file, convert in bulk, file deleted after processing.
Common date problems
- Dates show as text "2024-01-01" and cannot sort or filter
- Cells display numbers like 45292 instead of readable dates
- After CSV import, dates are left-aligned with green triangle warning
- Excel to SQL treats dates as strings and INSERT fails
- Need dates exported as fixed yyyy-MM-dd text
How to use
- Upload .xlsx, .xlsm or .csv (first row = headers)
- Choose sheet, mode (text to date / date to text / serial to date) and columns
- Click Preview to see success/fail stats and sample before/after
- Download the fixed XLSX file
Use cases
-
CSV export with text date columns needs batch conversion
-
Excel shows serial numbers like 45292 — convert to yyyy-MM-dd
-
Normalize dates before Excel to SQL database import
-
Deliver reports with dates as fixed text yyyy-MM-dd
-
Mixed locales (dd/MM/yyyy vs MM/dd/yyyy) with auto parse
vs Excel desktop
| Feature | Excel desktop | ComTools online |
|---|---|---|
| Batch text to date | Text to columns or formulas per column | Multi-column, one-click preview & export |
| Serial to date | Manual format change | Auto OADate serial detection |
| CSV direct | Must open in Excel first | Upload CSV directly |
| Preview before export | No batch preview | Sample rows + success/fail stats |