Excel or your CRM swaps day and month in dates (US vs EU format)
Why 03/04/2026 becomes April 3rd or March 4th and how to import dates reliably.
The message you see
Dates swapped: 03/04 becomes 4 MarchFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- The file uses DD/MM but the software expects MM/DD (or the other way around).
- Dates up to the 12th are ambiguous and silently converted; others become text.
How to fix it
- 1Use the unambiguous ISO format YYYY-MM-DD for imports.
- 2Check which rows are ambiguous before converting — don't let a tool guess.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support