Yes. In Excel for Microsoft 365 on Windows, CSV exports normally use the Windows list separator, so set it to a semicolon before saving if you need semicolon-delimited data. Then choose File > Save As and a CSV format; the file-type label may still say Comma delimited even when the exported separator is a semicolon.
What controls the CSV separator?
CSV stands for comma-separated values, but the format is plain text arranged in rows and fields, and the separator can be a comma, semicolon, tab, or another character. Excel’s Windows CSV export generally follows the List separator setting in Windows regional options. In regions where a comma is used as the decimal mark, a semicolon is often used to separate fields so that a value such as 12,5 is not mistaken for two columns.
This explains why two people can save the same workbook with the same Excel option and get different delimiters. The CSV format name in the Save As list is not a reliable preview of the character Excel will use on every computer. Excel also saves a CSV as text, not as a copy of the entire workbook: formatting, charts, multiple worksheets, and many workbook features are not retained.
Set Windows to use a semicolon
To make a semicolon the list separator for Excel exports, change the Windows setting and reopen Excel. The setting is outside the Excel ribbon and applies beyond the current workbook.
- Close Excel, especially if you have unsaved changes.
- Open Control Panel and select Clock and Region > Region.
- On the Formats tab, select Additional settings.
- On the Numbers tab, change List separator to a semicolon (;), then select Apply and OK.
- Reopen Excel and save the workbook using File > Save As. Choose a folder, set Save as type to CSV UTF-8 (Comma delimited) (*.csv), and select Save.
If your version does not show that exact CSV UTF-8 option, choose an available CSV format and check the resulting file’s encoding and separator. Excel may warn that some workbook features are incompatible with CSV. Confirm only if you intend to save a text-only copy; keep the original workbook as an .xlsx file.
What changes when you edit the list separator?
Windows’ list separator is a regional setting, not a preference limited to one workbook or one Excel export. Other programs that use the Windows setting may also behave differently. Excel can use the regional list separator when it interprets or displays formula argument separators, so formulas you see or enter may use semicolons instead of commas. Excel adjusts to the active settings, but copied formulas, scripts, or instructions written for another locale may look unfamiliar.
Changing the separator does not change the decimal symbol itself. Those are separate regional settings, although they often work together: a comma decimal mark commonly pairs with a semicolon list separator. If you change the setting only to create one file, note its original value and restore it afterward if other applications or your usual work depend on it. Avoid changing unrelated number-format settings just to solve a CSV export problem.
Save the file and verify its contents
After saving, inspect the actual file rather than relying on its name or the Save As label. In File Explorer, locate the .csv file, right-click it, and choose Open with a plain-text editor such as Notepad. A row with three fields might appear as North;Books;12,5 if the data contains a comma decimal mark. The important check is that the fields are separated by semicolons, not that every comma has disappeared.
For a useful check, include a few representative records: one with a decimal value, one with accented characters, and one with text that contains punctuation. Check that each record remains on the expected line and that the separators appear between fields. If the file contains sensitive data, use an approved local editor and avoid uploading it to an online converter simply to inspect it.
Opening the CSV by double-clicking it in Excel is not a dependable delimiter test. Excel may parse it using the current regional settings and display the result in columns, which can hide what is physically in the file. A plain-text view shows the separator directly. Do not save the inspected CSV again from the text editor unless you understand how that editor handles encoding and line endings.
Import a semicolon CSV correctly
If another application receives the file, it must also recognize the semicolon as the delimiter. When opening a CSV in Excel, use Data > From Text/CSV to preview the import rather than relying on double-click behavior. In the preview, select the delimiter setting that matches the file, confirm the columns are split correctly, and then load the data. The available controls can vary slightly by Excel build.
For other software, look for an import option named delimiter, separator, or field separator and choose semicolon. Also check the text qualifier, usually a double quote. A correctly written CSV can enclose a field containing a semicolon in double quotes, so the semicolon inside that field is treated as part of the text, not as a column break. Import settings matter: a correct file can appear as one column if the receiving program expects commas.
Common problems and how to fix them
- The file still contains commas. Confirm that the Windows List separator is set to a semicolon, then close and reopen Excel before exporting again. Inspect the new file in a text editor.
- Everything appears in one column. The receiving application may be expecting commas. Import the file and explicitly choose semicolon as the delimiter.
- Numbers or dates change. CSV stores values as text and does not preserve Excel’s cell formatting rules. The program opening the file may interpret dates and decimal marks according to its own locale. Preview the import and set column types where possible.
- Accented letters look corrupted. Use CSV UTF-8 when available, and check that the receiving application reads UTF-8. A legacy CSV format may use a different character encoding.
- Only one worksheet is in the file. That is expected: a CSV holds one plain-text table, not every sheet in an Excel workbook. Save each required sheet separately or use a format that supports multiple sheets.
- Some values have quotation marks around them. Quotes are normal CSV escaping when a field includes a delimiter, a quote, or a line break. They help preserve the field as one value; they are not necessarily extra characters in the data.
Alternatives when changing Windows is inconvenient
If you need a semicolon-delimited file only occasionally, changing the Windows list separator temporarily is the direct Excel route, but it changes a shared setting. If you cannot change it, use a dedicated export tool that lets you choose the delimiter explicitly, or ask the system administrator which approved method is available. Excel’s ordinary Save As CSV workflow does not provide a separate delimiter picker for each export on Windows.
Avoid replacing every comma with a semicolon using a basic text-editor Replace command. A comma in a description or a decimal value may be data, not a field boundary, and a simple replacement can corrupt the file. CSV fields may also be quoted and include embedded line breaks. If you transform the file, use a CSV-aware tool that parses fields and writes them back with the chosen separator, then inspect the output and test it in the destination application.
On Mac, Excel’s menus and regional controls differ from Windows, and there is no equivalent Windows Region > Additional settings > List separator path. CSV delimiter behavior can depend on the Excel version and macOS regional configuration. Check the saved file in a text editor; if the delimiter must be controlled precisely, choose an export tool that exposes a delimiter option. Excel for the web also has a different interface and may not offer the same local Save As workflow as desktop Excel.
Frequently Asked Questions
Can Excel choose semicolon for just one CSV export?
In the standard Windows Save As CSV workflow, there is no per-file delimiter selector. Excel uses the Windows list separator, so changing that setting is the built-in approach. For a one-off export without changing Windows, use a CSV-aware tool with an explicit delimiter option.
Why does the option say CSV Comma delimited when the file has semicolons?
The option names a CSV file type, but Excel’s Windows export can use the active Windows list separator. The label may therefore say Comma delimited while the saved text uses semicolons. Verify the file contents in a plain-text editor.
Does saving as CSV keep all my worksheets?
No. A CSV file stores a single table from the active worksheet and does not preserve workbook features such as multiple sheets, formulas as formulas, charts, or cell formatting. Keep an .xlsx copy if you need to retain the workbook.
Will a semicolon CSV open correctly in Excel?
Usually, if Excel recognizes the active regional separator. If it opens in one column or splits incorrectly, use Data > From Text/CSV and select semicolon in the import preview. The receiving computer may have different regional settings.
Is semicolon-delimited data still CSV?
People commonly call it CSV because it is a plain-text table with separated values, even though the letters refer to commas. More precisely, it is a delimited text file using semicolons. Confirm the delimiter with whoever receives the file, since CSV does not guarantee one universal separator.
Related
- Split Text to Columns in Excel: A Practical Guide
- Split Text to Columns in Excel Online: Steps and Fixes
- Split Cell Colour in Excel: Methods and Limitations
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter Command: How to Filter Your DataIn Google Sheets, select your data and choose Data > Create a filter to add filter controls to…
- IF Rules in Google Sheets: How Formulas and Rules WorkIn Google Sheets, an IF rule is a formula that checks a condition and returns one result when…
- How to Present PowerPoint and See Your Speaker NotesTo present a PowerPoint while keeping your notes visible, connect a second display, set Windows to extend the…
- How to Add Colour to Data Validation Cells in ExcelTo colour cells based on a data-validation dropdown in Excel, select the cells and use Home > Conditional…
- Excel Set Print Area Greyed Out? Causes and FixesIn Excel for Microsoft 365 on Windows, Set Print Area is usually greyed out because Excel is not…
- Unhide Columns in Excel: Keyboard Shortcuts and StepsTo unhide columns in Excel for Microsoft 365 on Windows, select the column headers on both sides of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.