Fix Excel Green Triangle Date Warning - CSV Text Date Converter
Green triangle + "number stored as text" after CSV import? ComTools batch-converts text dates to real dates online.
What is the green triangle?
Excel flags cells that look like numbers/dates but are text. Common after CSV open, web paste, ERP export.
Excel built-in vs online tool
Excel can convert one-by-one via warning menu or Text to Columns — slow on large files. ComTools: multi-column, preview, no Excel required.
Recommended workflow
CSV to Excel → date converter → Excel Format → Excel to SQL. Ensures correct date types before database import.
Prevention
Import CSV via Data → From Text/CSV and set column type to Date; or export ISO yyyy-MM-dd from source. Fix existing files with this tool.
Green triangle fix tips
- Use Text → Date mode
- Preview failed rows before export
- Do not select mixed numeric ID columns
- After fix, dates should align right and sort correctly