To make Excel for Microsoft 365 on Windows export a CSV with commas instead of semicolons, change Windows’ regional List separator to a comma, then save the workbook as a CSV again. Excel generally uses that Windows setting for the delimiter when it saves a CSV; the “Comma delimited” file-type label does not guarantee that commas will appear in every regional setup.
Why Excel may use semicolons
A CSV file is a text file that stores values separated by a delimiter. A comma is common, but semicolons are also used. Excel typically takes the delimiter for a saved CSV from the list separator configured in Windows’ regional settings. In some countries or configurations, that separator is a semicolon rather than a comma.
This choice is connected to how spreadsheet data is interpreted locally. For example, a region may use a comma as the decimal mark in numbers such as 3,14. Using semicolons between CSV fields can make those values less ambiguous to software that reads the file. In a region where the decimal mark is a period, a comma may be the usual list separator.
As a result, a workbook can be saved with a filename ending in .csv and still contain semicolons between its fields. The extension describes the general file format, not a universal delimiter. CSV conventions vary between applications and regional settings, so check the actual file when another system requires a specific character.
Check which delimiter the file contains
Before changing settings, check the saved file itself. Close the workbook or save a separate copy, then open the CSV in a plain-text editor such as Notepad. A spreadsheet program may automatically interpret the file and display its fields in columns, which can hide the delimiter used in the underlying text.
For example, a row with a comma delimiter might look like North,120,2026-04-18, while the same fields separated by semicolons might look like North;120;2026-04-18. If text values include the delimiter, quotes may surround those values, as in "North, East",120. Quoting is normal CSV behavior and does not mean the file has a different delimiter.
Also check what the receiving application expects. Some import tools let you choose the delimiter, so a semicolon-separated file may work perfectly well if the import is set to semicolon. The problem is specifically a mismatch—for example, the receiver expects commas but the file contains semicolons.
Change the Windows list separator
In Windows 11 and Windows 10, the setting is in the classic Region dialog rather than in Excel’s Save As screen. The wording and route to that dialog can vary slightly by Windows build. One way to open it is to search Windows for Region or Change date, time, or number formats, open the regional settings, and select Additional settings.
- In the Region dialog, open the Formats tab if it is not already selected, then choose Additional settings.
- On the Numbers tab, find List separator.
- Replace the semicolon with a comma, select Apply or OK, and close the dialogs.
- Close and reopen Excel if it was already running. Save a copy of the workbook as CSV, then inspect the resulting text file to confirm the delimiter.
In Excel, use File > Save As or File > Save a Copy, select a CSV format such as CSV UTF-8 (Comma delimited) (*.csv) when available, and save. Excel may warn that CSV does not support all workbook features. That warning is expected: CSV stores plain-text table data, not the full workbook.
What changing the setting affects
The list separator is a Windows regional setting, not a private preference for one Excel workbook. Changing it may affect how other programs separate list values or interpret regional data. If you change it only to create one export, note the original value so you can restore it afterward. Restoring the setting does not alter a CSV file that has already been saved.
Do not confuse List separator with Excel’s Use system separators option. In Excel for Windows, that option is under File > Options > Advanced and controls the decimal and thousands separators used for numbers in Excel. It is not the direct control for the delimiter Excel uses when saving a CSV. Changing it alone may therefore leave a semicolon-separated export unchanged.
Changing the list separator can also affect how a CSV is opened. Excel may use regional settings when interpreting delimited text, so a file created for one locale may not automatically split into columns as expected in another. This is another reason to confirm the delimiter and, when importing, specify it explicitly if the import interface offers that choice.
CSV export is different from CSV import
Exporting means saving data from Excel into a text file. Importing means reading a text file into Excel. The delimiter choices you encounter during import do not necessarily control the delimiter used when exporting.
To import a file and choose how it is split, use Data > From Text/CSV in Excel for Microsoft 365 on Windows. In the preview, select the appropriate delimiter if Excel has not detected it correctly, then load the data. This is useful when a file uses semicolons but Excel is expecting commas, or when a comma inside a value could otherwise be mistaken for a field boundary.
For a one-time check, opening a CSV in Notepad answers a different question: what characters are actually in the file? Importing through Excel’s data tools answers how Excel should interpret those characters. Keeping those two tasks separate helps diagnose whether the issue is the export, the import settings, or the receiving application.
What CSV keeps—and what it loses
A CSV export normally contains the values from the active worksheet, arranged as delimited rows and columns. It does not preserve the workbook as an Excel document. Features such as formulas as formulas, formatting, charts, multiple worksheets, data validation, and macros are not carried over in the usual CSV format. Formula cells are generally represented by their displayed results in the saved text.
That makes CSV useful for transferring simple tabular data, but it is not a substitute for keeping the original workbook. Save an .xlsx copy when you need to retain formulas, formatting, multiple sheets, or other Excel features. If you want to distribute one sheet as data, check that the correct sheet is active and review the exported file before sending it.
Excel may also encode text differently depending on the selected CSV type. When the receiving system needs characters outside basic English—such as accented letters or non-Latin scripts—CSV UTF-8 is often a suitable choice if the destination supports UTF-8. The delimiter and text encoding are separate properties: choosing UTF-8 does not, by itself, mean that the separator will be a comma.
Alternatives when you cannot change Windows settings
If you cannot change the regional setting, first ask whether the destination can accept a semicolon delimiter or lets you select one during import. That is usually the simplest option and avoids changing a Windows setting that other programs may use.
If the receiving system strictly requires commas, possible approaches include:
- Ask an administrator to change the list separator temporarily, export the file, and restore the original setting.
- Use the destination system’s import or conversion tool to select a semicolon source and produce its required format.
- Use a trusted text-processing tool or script to convert the delimiter, but only when it correctly handles quoted fields, embedded delimiters, and line breaks.
A blind find-and-replace of every semicolon with a comma is risky. A semicolon may be part of a text value rather than a field boundary, and values can contain quoted punctuation or line breaks. A reliable conversion must parse the file’s structure, not merely replace characters. Keep the original export unchanged until the converted file has been checked.
Excel for Mac and Excel for the web
The steps above are specifically for Excel for Microsoft 365 on Windows. Excel for Mac uses macOS regional and Excel settings, and the exact controls and behavior can vary by version. Do not look for the Windows Region dialog on a Mac. If a Mac export has the wrong separator, check the Mac’s regional number settings and Excel’s available preferences, then verify the saved text in a plain-text editor.
Excel for the web also has a different interface and does not provide the same Windows regional-settings dialog. If your workflow requires a guaranteed comma delimiter, verify the downloaded file or use desktop Excel with the appropriate system setting. In any version, a quick text-editor check is more dependable than relying on the filename or how a spreadsheet program displays the data.
Common problems and fixes
- The file is still semicolon-separated: Check the Windows List separator, not only Excel’s decimal-separator option. Reopen Excel and save a new copy after changing the regional setting.
- The receiver puts an entire row in one field: Its expected delimiter may not match the file. Check the raw text and set the receiver’s import delimiter to the character actually present.
- Commas appear inside quoted values: That can be correct. A comma inside a text field is often quoted so it is not confused with the delimiter.
- Some workbook features disappear: That is a limitation of CSV, not a delimiter error. Keep an .xlsx copy if you need workbook features.
- Letters display incorrectly: Check whether the CSV encoding matches what the receiving program expects. Try a UTF-8 CSV option when supported.
Frequently Asked Questions
Why does Excel say “Comma delimited” but save semicolons?
Excel’s CSV export can follow the Windows List separator setting. If that setting is a semicolon, the saved text may use semicolons even when the file type’s label mentions commas.
Can I choose the delimiter in Excel’s Save As dialog?
In standard Excel for Windows CSV saving, there is not a general Save As control for choosing an arbitrary delimiter. Excel typically uses the Windows list separator, so change that setting or use a suitable conversion workflow.
Will changing the Windows list separator change decimal numbers?
The List separator is distinct from the decimal-symbol setting, but changing regional settings can affect other applications and data workflows. Check the Windows dialog carefully and record the original separator before changing it.
Does CSV UTF-8 always use commas?
No. UTF-8 describes text encoding, not the delimiter. A UTF-8 CSV can still use a semicolon as its field separator, depending on the export behavior and regional settings.
Can I keep my formulas and formatting in a CSV?
No. CSV is plain text for tabular data, not a full Excel workbook format. Keep an .xlsx copy if formulas, formatting, charts, multiple worksheets, or macros need to be preserved.
Related
- Analysis ToolPak in Excel: How to Enable and Use It
- Analysis ToolPak in Excel: What It Does and How to Enable It
- Analysis Report in Excel: How to Build a Useful Report
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Responding? Causes, Fixes, and Recovery StepsIf Excel says “Not Responding,” wait briefly if it is calculating or opening a large file; if it…
- Audit Template Excel: Build a Clear, Useful WorkbookYes. An audit template in Excel can organize audit criteria, evidence, results, findings, and follow-up actions in one…
- Circular References in Excel: How to Find and Trace ThemTo view a circular reference in Excel for Microsoft 365 on Windows, open the workbook and select Formulas…
- Excel Print Area Greyed Out: Why It Happens and FixesIn Excel for Microsoft 365 on Windows, the Print Area commands are most often greyed out because multiple…
- Custom Cover Page in Word: Create and Add Your OwnTo add a custom cover page in Word, place a new page at the start of your document,…
- Share a Calendar in Outlook: Steps and PermissionsTo share a calendar in Outlook, open Calendar, choose the calendar you want to share, select Share or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.