Data Import & Export

How to Fix Excel Dates Imported Incorrectly from CSV Files

Partner Editor Sep 30, 2026 868 views

Question details

The user needs to resolve an issue where dates in a downloaded CSV file are displayed incorrectly or automatically converted to text when opened.

How to Fix Excel Dates Imported Incorrectly from CSV Files

Product: Excel
Device & OS: not provided
Scenario: Opening downloaded CSV data files from services like Azure, SharePoint, Exchange, or user group services.
Observed behavior: Excel interprets dates using local regional settings, often incorrectly swapping months and days, or converting dates into plain text if the day exceeds 12.

Before you start

Ensure you have the original, unmodified CSV file saved on your local drive. Do not overwrite or save changes to the raw CSV file until you have successfully imported and verified the date formats.

Solution 1Recommended

Import CSV Data and Save as XLSX

Use the built-in Data Import tool to manually specify the correct date format before Excel automatically interprets it, then save the workbook as a native Excel file.

When you double-click a CSV file, Excel attempts to guess the data formats based on your computer's regional settings. By using the import wizard, you can explicitly define how the dates should be read.

Create a blank workbook

Open Excel and create a new, blank workbook rather than opening the CSV file directly.

Launch the Import Wizard

Go to the 'Data' tab on the top ribbon, click on 'Get Data' (or 'From Text/CSV' depending on your version), and select your downloaded CSV file.

Specify the date column format

In the import preview window, locate your date column. Change the Data Type for that specific column to match the format used in the source file (e.g., Date, then choose the appropriate locale like English (US) or English (UK)).

Load the formatted data

Click 'Load' to bring the properly formatted data into your Excel worksheet.

Save as Excel Workbook

Go to 'File' > 'Save As'. In the 'Save as type' dropdown menu, select 'Excel Workbook (*.xlsx)'. This prevents the dates from reverting to unformatted text the next time the file is opened.

Permanent Fix: Saving explicitly as an XLSX file ensures all date formatting rules are locked in and won't be reinterpreted by Excel in the future.

Solution 2

Adjust System Regional Date Settings

Change your computer's regional settings to match the origin of the CSV file, which prevents Excel from misinterpreting the dates upon opening.

Easily Import and Format Data with WPS Office

Import CSV Files and Manage Dates Effortlessly in WPS Spreadsheet

WPS Spreadsheet offers a highly intuitive Text Import Wizard that gives you full control over how your CSV data is parsed. You can easily specify correct date formats during import to avoid the frustrating issue of dates turning into text.

1. Open WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and create a new blank document.
2. Import the CSV File: Navigate to the 'Data' tab on the ribbon and click 'Import Data', then select your downloaded CSV file.
3. Use the Text Import Wizard: Follow the wizard prompts. When you reach the column data format step, select the column containing dates and choose the 'Date' option with the correct YMD/MDY sequence.
4. Finish and Save: Click 'Finish' to populate the sheet. Then go to 'Menu' > 'Save As' and select 'Microsoft Excel Workbook (*.xlsx)' to preserve the correctly formatted dates.

Seamlessly import text and CSV files without automatic date corruption.High compatibility with Microsoft Office file formats including XLSX, XLS, and CSV.User-friendly Text Import Wizard for precise column formatting.Free and lightweight Office suite with a familiar interface for quick task completion.

Frequently Asked Questions

Why does Excel change my dates to text after the 12th day of the month?

This happens due to a conflict between US (MM/DD/YYYY) and UK/International (DD/MM/YYYY) date formats. If your computer expects a month first, and it reads a day greater than 12 (like 13/05/2023), it doesn't recognize 13 as a valid month. Consequently, Excel converts that specific cell into plain text.

Can I fix the dates by just changing the cell format to 'Date' after opening?

Usually, no. Once Excel incorrectly parses a date as text during the initial opening of a CSV file, simply changing the cell format from the Home ribbon will not revert the text string back into a valid numerical date. You must re-import the data correctly.

Does saving the file back as a CSV keep my corrected date formatting?

No. CSV (Comma Separated Values) is a plain text format that strips away all formatting rules. If you save it as CSV, the next time you open it, Excel will attempt to interpret the dates from scratch. Always save your imported and formatted data as an XLSX workbook.

Excel & Data Problems