Why Excel Imports CSV Dates as Text After a Windows 11 Upgrade
Question details
User needs to understand why Excel treats CSV dates as text after upgrading to Windows 11 and how to restore correct date recognition.

- Product
- Microsoft Excel
- Device & OS
- Windows 11
- Scenario
- After upgrading to Windows 11, a user opens a CSV file in Excel and finds that date columns are no longer recognized as dates.
- Observed behavior
- Excel imports valid CSV dates as text because the new Windows regional date format does not match the date order used in the CSV file.
Before changing any settings, open the CSV file in a plain text editor such as Notepad and note whether dates are written as mm/dd/yyyy, dd/mm/yyyy, or another order. Then check the current Windows regional date format in Settings so you know exactly which side to adjust.
Match the Windows 11 Regional Date Format to the CSV Date Format
Use this first when a CSV value such as 08/14/2023 is stored as month/day/year but Windows 11 is set to day/month/year.
Excel uses the Windows regional date settings to parse CSV date fields. If the order does not match, a value like 08/14/2023 becomes invalid and is imported as text instead of a date.
Press Windows key + I to open Settings, then go to Time & language > Language & region.
Under Regional format, note the active format and click the drop-down menu to compare it with the date order used in the CSV file.
Select the regional format that uses the same date order as your CSV data, such as English (United States) for mm/dd/yyyy.
Close and reopen the CSV file in Excel, or re-import it, and confirm that the date column is now parsed as Date rather than text.

Import the CSV Through Power Query with a Locale-Specific Date Type
Use this if you cannot change the Windows regional format or need to keep a different system locale for other applications.
Use WPS Office Spreadsheets as a Free Excel Alternative for CSV Date Work
The CSV date import problem is tied to Microsoft Excel’s handling of Windows regional date settings. WPS Office is a free, lightweight alternative with excellent Microsoft Office format compatibility, a familiar spreadsheet UI, and seamless migration, so you can open, edit, and manage CSV and Excel date columns without replacing your workflow.

Frequently Asked Questions
Why does Excel import CSV dates as text after a Windows 11 upgrade?
After a Windows 11 upgrade, the regional date format may change from mm/dd/yyyy to dd/mm/yyyy or another setting. Excel uses that Windows regional format to parse CSV dates, so a value like 08/14/2023 becomes invalid for dd/mm/yyyy and is imported as text.
How do I check the Windows 11 regional date format?
Open Settings > Time & language > Language & region, then look under Regional format. The selected format controls how Excel interprets ambiguous date values in CSV files.
Can I keep my Windows regional format and still import CSV dates correctly in Excel?
Yes. Use Data > From Text/CSV, select the date column, click the data type icon, choose Using locale, and set the locale that matches the CSV date format before loading the data.
Does changing the Windows regional format affect other applications?
Yes, it changes date, time, and number formatting for Windows and many apps. If that is not desirable, use the Power Query locale-specific import method instead of changing the system format.
What should I do if the CSV date format is inconsistent?
Open the CSV in a text editor and check the date column. If multiple date orders are present, clean the source data first or import the file through Power Query so you can apply a locale per column.




