Excel CSV Delimiter: How to Change the File Separator

In Excel for Microsoft 365 on Windows, CSV exports normally use the Windows regional List separator. To change the delimiter Excel writes, close Excel, change the List separator under Control Panel > Region > Additional settings, then reopen Excel and save the workbook as a CSV file. Excel does not provide a separate delimiter picker in its Save As dialog, so changing this setting can affect other apps as well.

How Excel chooses a CSV delimiter

A delimiter is the character that separates values in a row. Commas are common, but semicolons, tabs, and other characters can be used. CSV is a plain-text format, and the name does not guarantee that every file uses a comma: the separator depends on how the file was created and the settings of the application that created it.

When Excel saves a worksheet as CSV on Windows, it uses the system’s regional list separator. In a region where the comma is the list separator, the exported rows typically look like Product,Quantity,Price. If the list separator is a semicolon, they may look like Product;Quantity;Price. Excel’s Save As file type may still be labelled CSV (Comma delimited); that label does not necessarily mean the file will contain commas when Windows is configured to use another list separator.

This design helps avoid confusion in regions where a comma is used as the decimal mark. For example, a value such as 12,50 could be mistaken for two fields if commas were also used between columns. A semicolon can separate the fields instead.

Change the Windows list separator

To make Excel export CSV files with a different separator, edit the Windows regional setting. The exact Control Panel labels can vary slightly by Windows version, but the setting is in the regional number-format options.

Save your work and close all open Excel windows. Closing Excel first helps ensure that it picks up the changed setting when it starts again.
Open Control Panel, select Clock and Region, and open Region.
On the Formats tab, select Additional settings.
On the Numbers tab, find List separator and enter the character you want, such as a semicolon.
Select Apply and OK to close the dialogs, then reopen Excel.
Use File > Save As, choose a CSV format, and save the file. If Excel warns that some workbook features are not compatible with CSV, confirm only if you intend to save the active sheet as a plain-text CSV.

To return to your usual configuration, revisit the same setting and restore the separator used by your regional format. The Windows List separator is a system setting, not a preference that applies only to one workbook or one Excel file.

What the setting can affect

Changing the Windows list separator may affect more than CSV exports. It can influence how other applications interpret delimited text and, depending on regional and Excel settings, the separator expected between arguments in formulas. If a formula that previously used commas between arguments is rejected after the change, check the separator Excel now expects rather than assuming the formula itself is wrong.

The Windows list separator is different from Excel’s decimal and thousands separators. In Excel, the related controls are under File > Options > Advanced, in the Editing options section, where Use system separators and the decimal and thousands separator fields are available. Those controls govern number display and entry; changing them is not the same as changing the Windows List separator used for CSV behavior. Avoid changing multiple regional settings at once unless you understand how each one affects your work.

If you share a computer, use software that relies on a particular separator, or need different delimiters for different projects, changing a global setting can be inconvenient. In that case, consider a conversion tool that supports an explicit output delimiter, or export with the standard setting and convert the file using a CSV-aware application.

Export a worksheet and check the result

CSV stores plain text, not a complete Excel workbook. When you save a workbook in a CSV format, Excel exports the active worksheet rather than preserving every sheet, chart, formula, style, or workbook feature. Formulas are represented by their displayed results, and formatting such as colors and column widths is not retained. Keep the original workbook as an Excel file if you need to preserve those features.

After saving, check the actual file rather than relying on its name or the file-type label. Open a copy in a plain-text editor, or inspect it with a text editor that does not automatically arrange values into spreadsheet columns. Look at the boundary between the first two fields in a row: a comma, semicolon, or tab will show which character was written. Avoid making edits in a text editor unless you understand CSV quoting, since a careless change can alter the data.

Excel may display a compatibility warning when saving as CSV because the format cannot retain all workbook content. Choose the CSV option only when a text data file is what you need. If you need to send a workbook with multiple sheets or formatting, use an Excel workbook format such as XLSX instead.

Changing the export delimiter is not the same as importing

Importing a CSV is a separate task from exporting one. If a file opens into a single column, or its values split at the wrong character, use Excel’s import controls rather than changing the Windows setting immediately. In Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, and check the delimiter in the preview. Select the delimiter that matches the file, then load the data or continue to transform it.

This approach is useful when a file uses a semicolon but your usual regional setting expects a comma, or when the file contains tabs. Importing through the preview also gives you a chance to inspect how Excel interprets columns before loading the data. Opening a CSV directly, for example by double-clicking it, may apply regional parsing rules without giving you the same clear opportunity to choose a delimiter.

In Excel for Mac, the regional and CSV options differ from Windows, and there is no identical Windows Control Panel List separator path. If you need a custom delimiter on a Mac, check the current macOS region settings and verify the saved file’s contents, or use a converter that lets you choose the delimiter. Excel for the web also has different file-handling capabilities from the Windows desktop app, so these Windows export steps should not be assumed to apply there.

Choose a delimiter that fits the receiving system

The best separator is usually the one expected by the software that will read the file. Before changing a system-wide setting, check the recipient’s import instructions or the requirements of the destination system. A file that looks correct in a text editor can still be read incorrectly if the receiving application expects a different delimiter or encoding.

Comma: A common choice for data exchange, especially when the destination expects conventional comma-separated CSV.
Semicolon: Often useful in regional formats where commas serve as decimal marks, or when the receiving system explicitly requests semicolons.
Tab: Often used for tab-delimited text. It is a different kind of delimited text file, even if a recipient informally calls it a CSV.

Do not choose a separator just because it appears rarely in the first few rows. Check the full data set and the receiving system’s specification. If a separator also occurs inside a value, a correctly formatted CSV uses quotation marks around fields as needed. The receiving application must support standard CSV quoting to interpret those fields correctly.

Why a simple find-and-replace can damage a CSV

A tempting workaround is to save a comma-separated file and replace every comma with a semicolon. That can break the data. A comma might be part of a sentence, an address, or a number, rather than a field boundary. For example, a field containing a city and region could be quoted in CSV so its internal comma stays within one value. Replacing all commas would change both the field boundaries and the text inside that field.

Similarly, a file may contain quotation marks that are escaped according to CSV rules. Editing delimiters safely requires distinguishing separators between fields from characters inside quoted fields. Use a CSV-aware converter or a script that reads and writes CSV records with the intended delimiter, rather than a global text replacement. Keep the original file until you have checked the converted output in Excel or the destination application.

For a one-off export, changing the Windows List separator may be convenient if you are comfortable with its wider effects. For repeatable work that needs different delimiters for different recipients, a dedicated conversion process is usually more predictable because it can specify the input and output separators without relying on a global regional preference.

CSV encoding and other export choices

The delimiter is only one property of a text export. Encoding determines how characters such as accented letters, symbols, and non-Latin scripts are stored. In Excel for Microsoft 365 on Windows, the Save As file-type list may include CSV UTF-8 (Comma delimited) as well as CSV (Comma delimited). Choose the UTF-8 option when the recipient supports it and reliable handling of a wider range of characters matters. As with the delimiter, inspect the saved file if the exact output matters.

CSV also does not preserve data types in the same way as XLSX. A value that looks like an identifier with leading zeros may be interpreted as a number by the next program; dates can be interpreted according to the recipient’s regional settings. If a receiving system has strict requirements, confirm its preferred encoding, delimiter, date format, and treatment of text fields before exporting. CSV is a useful interchange format, but it is not a guarantee that every application will interpret every value identically.

Frequently Asked Questions

Can I choose a delimiter in Excel’s Save As dialog?

Excel for Microsoft 365 on Windows does not offer a general delimiter selector in the CSV Save As dialog. It normally uses the Windows regional List separator. Change that setting for a system-level adjustment, or use a CSV-aware converter when you need a per-file choice.

Why does Excel save a semicolon-delimited file as CSV?

CSV describes a delimited text format and does not guarantee that commas separate fields. Excel uses the Windows regional list separator, so a semicolon can be the separator even when the chosen file type is labelled CSV (Comma delimited).

How do I open a semicolon-separated file correctly?

In Excel for Microsoft 365 on Windows, use Data > From Text/CSV, select the file, and choose semicolon in the import preview. Confirm that the preview shows the intended columns before loading the data.

Will changing the Windows separator change my Excel formulas?

It may affect the argument separator Excel expects in formulas, depending on the regional and Excel settings. If formulas stop parsing, check the separator expected in your current configuration. The list separator setting is also used beyond a single workbook, so consider its broader effects before changing it.

Does saving as CSV keep all my worksheets?

No. A CSV export contains the active worksheet’s data as plain text, not the full workbook. It does not retain other sheets, formatting, charts, or formulas as workbook features. Save a separate XLSX copy if you need to keep the complete workbook.

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.