How to Fix Excel CSV Date Import Problems
You export a CSV from a UK system, double-click it in Excel on a US laptop, and suddenly28/05/2026becomes something that looks like May 28th — or worse, an entirely wrong day. This guide explains why Excel does this and how to fix it without corrupting your data.
Quick fix: Use Date Format Fixer to detect ambiguous dates and export ISO columns, then continue with CSV to JSON if you need structured data for an API.
Why Excel breaks CSV dates
CSV files are plain text. They do not store type information — Excel guesses types using your operating system locale. A US Excel install assumes MM/DD/YYYY; a UK install assumes DD/MM/YYYY. When you double-click a CSV, Excel opens it directly and reinterprets every date-like string before you can stop it.
- • Dates where day ≤ 12 are especially dangerous — they can silently swap meaning.
- • Excel may convert dates to serial numbers (e.g. 44927) on re-export.
- • Two-digit years add another century-guessing layer.
Import CSV safely in Excel
- 1. Open Excel first — do not double-click the CSV file.
- 2. Data → Get Data → From Text/CSV (or From Text on older versions).
- 3. Mark date columns as Text during import if you need to preserve the original string.
- 4. Convert deliberately once you know the source region (US vs UK).
Use ISO 8601 for data exchange
For any CSV shared across regions, agree on YYYY-MM-DD (ISO 8601) at the schema level. It is unambiguous, sorts correctly as plain text, and is the default for JSON APIs and SQL databases.
| Original (ambiguous) | US read | UK read | ISO (safe) |
|---|---|---|---|
| 03/04/2025 | 04/03/2025 | 03/04/2025 | Pick source region |
| 28/05/2026 | — | 28/05/2026 | 2026-05-28 |
| 05/28/2026 | 05/28/2026 | — | 2026-05-28 |
Fix dates with FormatList
If the damage is already done, paste your date column into these free browser tools:
- Date Format Fixer Batch fix, highlight ambiguous rows, export ISO CSV.
- Ambiguous Date Checker See US vs UK side-by-side for risky values.
- UK Date to US Date Convert DD/MM columns for US forms and exports.
FAQ
Why did my dates turn into numbers like 44927?
Excel stores dates internally as serial numbers. When a column is formatted as General, you may see the raw serial instead of a formatted date. Use Date Format Fixer to convert serials back to readable dates.
Should I fix dates before or after CSV to JSON conversion?
Fix dates first. JSON objects with wrong date strings will propagate errors into your API and database. Normalize to ISO, then convert to JSON.