Why are the dates in my CSV the wrong way round, or stuck as text, in Excel on a Mac?

By Kayabyte · Last updated 4 November 2026

A date such as 03/04/2026 is 3 April in one country and 4 March in another, and a CSV file does not say which. If Excel reads it the wrong way round, or leaves it as left-aligned text, the fix is to tell it the order for that column, not to retype the dates. Dates with a day above 12 (28/10/2026) can only be read one way, so a column that contains some of those usually settles the order for the whole column.

Why it happens

A CSV is plain text with no column types. When you open it, Excel decides for each column what it holds, as Microsoft’s page on importing text and CSV files describes (support.microsoft.com, checked 4 November 2026). That page also says that if Excel does not convert a column the way you want, you can convert it after the import, and it points to a separate Microsoft article on converting dates stored as text. Dates written day first and month first in the same file cannot both be right, and an export from a system in another region is the usual cause.

How to tell which order you have

Look for a date whose first number is above 12 (28/10/2026). That column is day first.
Look for one whose second number is above 12 (10/28/2026). That column is month first.
If you find both in one column, the file mixes orders. Split the rows by source if you can, because no single setting fixes it.
If no date in the column has a number above 12, nothing in the file settles it. Ask whoever made the export, or check a date you know, such as an invoice you remember.

Method 1: Text to Columns with the date order

Select the column of dates stored as text.
Choose Data, Text to Columns, and go to the third step.
Under column data format choose Date and pick the order that matches the text (for example DMY for day first).
Finish, then format the column as a date and check a few cells against the CSV.

Menu names vary by Excel version, so look for Text to Columns on the Data tab. A column that mixes orders cannot be fixed by one setting.

Method 2: a formula for one fixed layout

If every date is text in the form dd/mm/yyyy with two-digit day and month, this builds a real date: =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)). Fill it down, then copy and Paste Special, Values over the original. It breaks on dates like 3/4/2026 where the day or month has one digit.

What to avoid

Changing the cell format to Date and nothing else. On a cell that holds text, a date format does not turn it into a date.
Swapping day and month in some rows by hand. Check which rows are already right first, or you will swap them back.
Saving over the original CSV before you have checked a few dates against it.

With Gridhand

Gridhand works out the order from the file itself and says so when it cannot. In Clean, text dates become real dates in one format. The order is detected per column: a date with a first number above 12 means day first, a date with a second number above 12 means month first. If nothing in a column settles it, those dates are left as text with a warning, and you can choose day-first or month-first in the Clean options and run it again. If a column has proof of both orders, the dates that could be read either way stay text, with a warning. Convert, which turns CSV, TSV and text files into .xlsx, applies the same evidence rule: a column with proof of both orders is left as text with a warning, and a column with no proof is left as text with a note. Originals are never modified, and a preview comes first.

This page does not cover what a particular version of Excel does with the resulting files beyond opening them; check a few dates after opening. Gridhand’s month-name handling in date cleaning is English only.

Steps with Gridhand

Drop the CSV or Excel files, or a folder of them, into Gridhand and choose Clean (or Convert for CSV files).
Tick the date step and, if you know the order, choose day first or month first.
Read the preview and the notes marked “Check these” for columns left as text.
Choose an output folder, press Run, and compare a few dates with the source.

Free for up to 3 files per run; Gridhand Pro is USD 49 once. Download Gridhand · Pricing

Questions

Will Gridhand guess when the order is unclear? No. It leaves those dates as text and tells you, so a wrong guess does not slip in.

Can it fix a column that mixes both orders? No. It leaves the dates that could be read either way as text and warns you. Split the source by origin first.

Does it change my original files? No. Results are written as new files in the folder you choose.

Microsoft and Excel are trademarks of the Microsoft group of companies. Gridhand is made by Kayabyte and is not affiliated with or endorsed by Microsoft.