How to Save an Excel Worksheet as a Comma-Delimited CSV File
Question details
The user needs to save an Excel worksheet as a comma-delimited CSV file, but the file is automatically saving with semicolons as the delimiter.
- Product
- Excel
- Device & OS
- Windows
- Scenario
- Exporting data from an Excel workbook into a standard CSV UTF-8 format for use in other applications or databases.
- Observed behavior
- Excel exports the CSV UTF-8 file using semicolons instead of the expected commas because the delimiter is controlled by the default Windows regional list separator.
Before modifying your system settings, save your current Excel workbook as a standard .xlsx file to ensure no data or formatting is lost.
Change the Windows Regional List Separator
Modify your Windows regional settings to force Excel to use a comma as the default list separator when saving CSV files.
Excel relies on the Windows operating system's regional settings to determine which character to use as a list separator. In regions where the comma is used as a decimal mark, Windows defaults to a semicolon to avoid formatting conflicts. Changing this system setting will fix the Excel CSV export behavior.
Press the Windows key, type 'Control Panel' into the search bar, and launch the application.
Click on 'Clock and Region' (or just 'Region' if you are using the Large Icons view), then select 'Change date, time, or number formats'.
In the Region dialog box that appears, click the 'Additional settings...' button located at the bottom of the Formats tab.
Locate the 'List separator' field. Delete the semicolon (;) and type a comma (,) in its place. Click 'Apply', then click 'OK' to save the changes.
Return to your Excel worksheet. Go to File > Save As, choose 'CSV UTF-8 (Comma delimited) (*.csv)', and save your file. It will now be properly separated by commas.
Specify the Delimiter for Data Import
If you cannot change system settings, you can explicitly declare the delimiter in the first line of the CSV file for the importing software.
Manage CSV Files Easily with WPS Office
If navigating Windows system settings to fix Excel CSV exports is disrupting your workflow, WPS Spreadsheet provides a smooth, highly compatible environment for managing and exporting data files. Experience seamless saving and formatting without unexpected delimiter changes.
- 1. Download and Install: Download WPS Office for free from the official website and follow the simple installation prompts.
- 2. Open Your Data File: Launch WPS Spreadsheet and open the data file you wish to export.
- 3. Save as CSV: Click 'Menu', select 'Save As', choose 'CSV (Comma delimited) (*.csv)' from the file type dropdown, and securely save your file.
Frequently Asked Questions
Why does Excel save my CSV with semicolons instead of commas?
Excel relies on the default 'List separator' defined in your Windows Regional Settings. In many regions (especially Europe) where the comma acts as a decimal mark, Windows automatically assigns the semicolon as the list separator to prevent data conflicts in CSV files.
Can I change the CSV delimiter in Excel without altering Windows settings?
No, Excel does not provide a built-in application setting to change the CSV delimiter independently. You must either adjust the Windows Regional Settings, use a text editor to Find and Replace semicolons with commas, or utilize a VBA macro for customized data export.
Will changing the list separator to a comma affect other programs on my PC?
Yes. The list separator in the Control Panel is a system-wide setting. Any other application running on Windows that relies on this setting to parse lists, export data, or format numbers will also begin using the comma instead of the semicolon.
What is the difference between CSV UTF-8 and standard CSV?
CSV UTF-8 encoding supports a much wider range of global characters, including international alphabets and special symbols. Saving as CSV UTF-8 ensures that non-English text and symbols are not corrupted or replaced with question marks when the file is reopened.
