How to Fix Incorrect Date Formats After Exporting Data to Excel
Question details
The user needs to correct date values that appear with day and month reversed after exporting CRM data to Excel or WPS Spreadsheets.

- Product
- WPS Office Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- The user exported date fields from a CRM system into an Excel file and needs those dates to be interpreted and displayed correctly.
- Observed behavior
- Dates appear with day and month values reversed, or are interpreted according to the wrong regional date format.
Open the exported file in WPS Spreadsheets and identify which cells show reversed day and month values. Check the original CRM export date order and your computer's regional date settings before applying a format or reimporting the file.
Reinterpret Reversed Date Values with Text to Columns
Use this when dates are already imported but WPS Spreadsheets or Excel misread the source day/month order, such as DMY values interpreted as MDY.
Text to Columns is the most reliable way to correct an existing date column because it parses the selected cells using the original source date order. It works in WPS Spreadsheets and keeps the file compatible with Microsoft Excel.
Open the exported workbook in WPS Spreadsheets and click the column header or drag to select only the date cells that show reversed values.
Go to the Data tab and click Text to Columns. In the dialog, choose Delimited if the file uses a delimiter such as comma or tab; otherwise choose Fixed width, then click Next.
In Step 2, clear delimiter check boxes if not needed and click Next. In Step 3, select Date and choose the source order that matches the CRM export, such as DMY for dd/mm/yyyy or MDY for mm/dd/yyyy.
Click Finish. Check the column to confirm day and month values are now in the correct positions, then apply the desired display format if necessary.

Apply the dd/mm/yyyy Date Format with Format Cells
Use this when dates are real date values and you only need to change how they are displayed in WPS Spreadsheets.
Reimport the File with the Correct Date Settings
Use this when you can re-export or re-import the CRM file and want to prevent date misinterpretation before editing.
Fix Incorrect Date Formats After CRM Export in WPS Spreadsheets
Use WPS Office Spreadsheets to correct reversed day and month values with Text to Columns, apply dd/mm/yyyy through Format Cells, or reimport CSV data with the proper date format. WPS Spreadsheets keeps Excel-compatible date handling without a Microsoft 365 subscription.
- 1. Open WPS Spreadsheets: Download and install WPS Office, then open the exported .xlsx or .csv file that contains the incorrect dates.
- 2. Select the affected date column: Click the column header or select the cells where day and month values appear reversed.
- 3. Reinterpret the source date order: Go to Data > Text to Columns, choose Delimited or Fixed width, click Next, select Date, and pick the original CRM date order such as DMY.
- 4. Apply the desired display format: With the corrected cells selected, right-click > Format Cells > Date or Custom, enter dd/mm/yyyy, and click OK.

Frequently Asked Questions
Why do my CRM dates appear reversed after exporting to Excel?
Excel and WPS Spreadsheets interpret date text according to the computer's regional settings or the file's format. If the CRM exports DD/MM/YYYY but the system expects MM/DD/YYYY, values like 03/04/2025 may become March 4 instead of April 3.
How do I change the date format to dd/mm/yyyy in WPS Spreadsheets?
Select the date column, right-click and choose Format Cells, go to Date or Custom, enter or choose dd/mm/yyyy, and click OK. This changes the display for valid date cells.
What should I do if Format Cells does not fix the reversed dates?
Use Data > Text to Columns. Select the column, click Text to Columns, continue through the wizard, choose Date, select the original source order such as DMY or MDY, and click Finish.
Can I prevent date misinterpretation when importing a CRM CSV file?
Yes. In WPS Spreadsheets go to Data > From Text/CSV, select the file, and set the date column format in the import preview before loading. In the CRM, use an unambiguous format such as YYYY-MM-DD when possible.
Does WPS Spreadsheets support the same date formats as Excel?
Yes. WPS Spreadsheets opens and saves Microsoft Excel .xlsx and .csv files and provides compatible date formats, but regional settings and source format still affect how date text is interpreted, so use the import or Text to Columns options for control.




