How to Change the Date Format in an Excel CSV File

To change dates in a CSV using Excel, first make sure Excel has interpreted the values as real dates, then select the date cells and use Home > Number Format or Ctrl+1 to apply the format you want. Save a copy as CSV and check the exported text: CSV files do not preserve Excel formatting, so the format must be represented in the saved date values.

This guide is for Microsoft Excel for Microsoft 365 on Windows. The key distinction is that a CSV stores rows of text and values, not Excel cell styles. You can use Excel to convert and display dates, then export the results as text such as 2026-11-02. Keep an untouched copy of the original file until you have checked the saved version, especially if dates could be interpreted as either day/month or month/day.

What You’ll Need

The CSV file and Microsoft Excel for Microsoft 365 on Windows.
A copy of the original CSV, or a separate backup location. Saving as CSV can discard workbook features and may change the file’s contents.
The date format you need, such as dd/mm/yyyy, mm/dd/yyyy, or the less ambiguous yyyy-mm-dd.
If dates are ambiguous, the convention used by the source data. For example, 04/05/2026 could mean April 5 or 4 May.

Step-by-Step

Make a working copy. In File Explorer, copy the CSV and work on the copy. Alternatively, open it and immediately use File > Save As to save a separate workbook as an Excel Workbook (*.xlsx). The workbook copy is useful for checking the data and retaining formatting, but the final deliverable can still be a CSV. Do not overwrite the only source file until you have confirmed the exported dates.
Import the CSV when you need control over date interpretation. In a blank workbook, choose Data > From Text/CSV, select your file, and review the preview. Check that columns are separated correctly and that the date values appear in the intended column. If the preview has interpreted a date column incorrectly, select Transform Data to open Power Query rather than loading it immediately. In Power Query, select the date column, choose the data type control, then choose Using Locale. Set the type to Date and choose a locale whose date order matches the source, such as a day-first locale for day/month/year data. Select Close & Load when the preview is correct. The exact available locale labels depend on your Excel installation.
If Excel has already opened the CSV, check whether the dates are real dates. Select a few date cells and look at the formula bar and the Number Format list on the Home tab. A real Excel date is stored as a serial number and can be displayed in different date formats. A text value usually remains unchanged when you apply a date format. Do not assume that a plausible-looking date is correct: Excel may have silently read a day-first value as month-first, or vice versa. Compare several rows with the source convention before proceeding.
Convert text dates if necessary. First duplicate the date column or save another working copy, because conversion changes the selected values. Select the date cells, then choose Data > Text to Columns. In the wizard, select Delimited and choose Next twice. Under Column data format, choose Date and select the order that matches the source, such as DMY, MDY, or YMD, then choose Finish. Check the converted results against the original data. This method is most appropriate when values in the column consistently use one known order; it cannot resolve genuinely ambiguous dates without knowing the source convention.
Select the date cells you want to change. Click the date column heading to select the entire column, or drag across only the cells that contain dates. If the column also contains a heading or notes, selecting just the data cells can avoid applying a date format to those entries. If you have imported several date columns, format each one separately and verify that none contains text or unrelated values.
Open the detailed number-format settings. Press Ctrl+1 on Windows. In the Format Cells dialog, select the Number tab and choose Date for a built-in format, or choose Custom to enter a specific pattern. On a Mac, use Command+1 to open Format Cells; the dialog labels or import controls can vary slightly by Excel build. You can also use Home > Number Format to apply a common date style, but Format Cells gives you more control over the order and separators.
Choose the exact display format. For a built-in date, select the desired example in the Type list and check its locale if one is shown. For a custom format, enter a pattern such as dd/mm/yyyy for 02/11/2026, mm/dd/yyyy for 11/02/2026, or yyyy-mm-dd for 2026-11-02. In Excel format codes, m represents month when used in a date, d represents day, and y represents year. Choose OK and inspect multiple cells to make sure the output matches the convention you intend. For files shared across regions, year-month-day is often easier to interpret, but follow the recipient’s requirements.
Save the result as a CSV. Choose File > Save As, pick the destination, and select CSV UTF-8 (Comma delimited) (*.csv) if the recipient needs a standard comma-separated file with broad character support. Choose CSV (Comma delimited) (*.csv) if that is specifically required. Select Save, then confirm any prompt about features that are not supported in CSV. CSV keeps plain cell contents, not Excel formatting, formulas, multiple worksheets, or workbook features. Excel saves the active worksheet, so make sure it is the sheet you intend to export.
Verify the exported dates and keep the right copy. Close the file or use a plain-text editor to inspect the saved CSV. Confirm that the date fields contain the intended strings, for example 2026-11-02, and that commas, quotes, and other columns remain in the expected places. Reopening a CSV in Excel may cause Excel to interpret the date strings again, so a text editor is a useful check of what was actually saved. Keep the original or the .xlsx working copy if you may need to revise the data or retain worksheet formatting.

Common Mistakes

Changing appearance without changing the underlying value. Applying a date format changes how a real date is displayed; it does not fix a date that Excel imported incorrectly. If 03/04/2026 was read using the wrong regional convention, formatting it as yyyy-mm-dd can make the incorrect interpretation look clear without making it correct. Check the source order and convert or re-import with the right locale first.

Trying to save formatting inside the CSV. A CSV has no cell-formatting instructions. Excel may write a formatted date string when it exports a cell, but the CSV will not remember a date style for the next application. If someone opens the file in Excel, Excel can reinterpret that string according to their settings. If the recipient needs an editable Excel file with persistent cell formatting, provide an .xlsx file as well as, or instead of, the CSV.

Using the wrong date order or applying a format to text. A value like 12/11/2026 is ambiguous, and applying a new style to text does not necessarily convert it. Confirm what the source means. Use the import locale or Text to Columns date order that matches the source, then check the result before saving.

Overwriting the only copy or exporting the wrong worksheet. CSV export can remove workbook structure and only saves the active sheet. Save a backup first, click the intended worksheet tab, and inspect the saved file before replacing any source or sending it onward.

Tips

Use yyyy-mm-dd when a date needs to be clear across regions. It places the largest time unit first and avoids the common day/month ambiguity.
Keep a separate original-text column when converting uncertain source data. It makes it easier to compare the imported result with the supplied value and identify mistakes.
For recurring files, import through Data > From Text/CSV and set the column’s locale rather than relying on double-clicking the CSV. Direct opening can use Windows regional settings and automatic type detection.
Check the first, middle, and last rows, not just one example. A column can contain mixed formats, blanks, or values that Excel did not recognize as dates.
If the CSV must use a particular delimiter or date representation for another system, follow that system’s specification. Regional list-separator settings can affect CSV output, so inspect the exported text rather than assuming every comma-separated file will look identical.
Excel for the web can display and edit many CSV values, but its import and locale controls may differ from desktop Excel. For precise text import and date conversion, use the Windows desktop steps above; on Mac, use the available Data import controls and Command+1 for Format Cells.

Troubleshooting

The date format changes nothing. The selected cells may contain text rather than real dates. Try importing the file through Data > From Text/CSV and setting the date type with Using Locale, or use Data > Text to Columns with the correct DMY, MDY, or YMD choice. Work on a copy and confirm that the converted dates match the source before applying a display format.

Dates switch month and day. Stop before saving over the original. Check the source convention and the locale used during import. Re-import with the matching locale or repeat Text to Columns with the correct date order. If the values are inherently ambiguous and you cannot confirm the convention, ask the data provider instead of guessing.

Cells show ######. This usually means the column is too narrow to show the formatted value, rather than the date being lost. Widen the column by dragging the boundary between its heading and the next one, or double-click that boundary to AutoFit. If the value still looks wrong, inspect the formula bar and check the underlying date.

The saved CSV looks different when opened again. Excel may automatically convert the saved text according to your regional settings. Inspect the CSV in a plain-text editor to see its stored characters. If the text is correct but Excel displays it differently, import it using Data > From Text/CSV and specify the correct locale instead of double-clicking the file.

The CSV has semicolons or missing columns. Excel may use your Windows list separator when writing a CSV, and the selected CSV type and regional settings can affect delimiters. Check the recipient’s required separator and inspect the saved file in a text editor. If a specific import system expects semicolons or another delimiter, choose an export or conversion method that meets that system’s requirements rather than changing date formats repeatedly.

Other sheets or formulas disappeared. That is expected when saving as CSV: the format stores a single worksheet’s plain data, not a full Excel workbook. Reopen the .xlsx backup to recover workbook features, then export the intended sheet again if needed.

Frequently Asked Questions

Can I change the date format in a CSV without Excel?
A text editor can replace date strings, but it does not understand dates or reliably distinguish ambiguous formats. A spreadsheet or data-import tool is safer when values need conversion. Keep a backup and verify that the replacement has not altered other text in the file.

Does a CSV file retain the date format I chose in Excel?
No. CSV does not store Excel cell styles. Excel can export the displayed date as text, but another program may interpret that text differently when it opens the file. Use an .xlsx file when persistent Excel formatting is required.

Which date format is safest to share?
Use the format required by the receiving system. If there is no requirement, yyyy-mm-dd is generally less ambiguous than formats that put the day and month first or second. Confirm that the recipient accepts that representation.

Why does Excel change my dates as soon as I open the CSV?
Excel may automatically recognize date-like text and interpret it using regional settings. Importing through Data > From Text/CSV gives you more control over the column type and locale. If the values must remain untouched as text, import that column as text instead of a date.

Can I make the dates display differently but keep the original CSV values?
Not in the same CSV as a persistent cell style; CSV has no formatting layer. Keep the original CSV and use an .xlsx copy for a different display, or export a second CSV containing the date strings in the required format.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.