How to Change Excel's Imported File Separator from Colon to Semicolon
Question details
The user needs to change the default list separator in Excel from a colon back to a semicolon for importing text and CSV files accurately.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Importing CSV or text files into a spreadsheet after a recent Windows update altered the default delimiter.
- Observed behavior
- Excel parses imported files using a colon as a delimiter instead of the expected semicolon, causing the data to display incorrectly or merge into single columns.
Ensure you have saved your work and closed all open Excel windows before proceeding, as changes to system settings require the application to be restarted to take effect.
Modify the Windows Regional List Separator
Excel relies on your Windows system settings to determine the default delimiter for CSV files. Modifying this global setting will permanently fix the import behavior.
When you open or import a CSV file, Excel checks the Windows Regional settings for the 'List separator' character. If a Windows OS update or an accidental system change altered this to a colon, Excel will fail to parse semicolon-delimited files properly.
Click the Windows Start menu, type 'Control Panel' in the search bar, and press Enter to launch the application.
Click on 'Clock and Region', then select 'Region' to open the system formats dialog box.
At the bottom of the Formats tab, click on the 'Additional settings...' button to customize your regional formats.
In the Numbers tab, locate the 'List separator' field. Delete the colon (:) and type in a semicolon (;).
Click 'Apply' and then 'OK' to save your changes. Launch Excel and import your CSV file again to verify the data is parsed correctly.

Use the Text to Columns Feature
If you cannot change system settings due to administrative restrictions, you can manually force Excel to use a semicolon delimiter for a specific file.
Use WPS Spreadsheet to Easily Import Delimited Files
WPS Spreadsheet offers a built-in, user-friendly text import wizard that lets you manually choose your delimiter (like a semicolon, comma, or space) during the import process without needing to alter system-wide Windows settings.
- 1. Launch WPS Spreadsheet: Open WPS Office and create a new blank Spreadsheet.
- 2. Import Your Data: Go to the 'Data' tab on the top ribbon, click 'Import Data', and select your CSV or text file.
- 3. Configure the Wizard: In the Text Import Wizard, choose 'Delimited' and click 'Next'.
- 4. Select the Delimiter: Check the 'Semicolon' option under Delimiters to instantly preview your properly separated data.
- 5. Finish the Import: Click 'Finish' to import the correctly formatted data into your spreadsheet.

Frequently Asked Questions
Why did my Excel list separator suddenly change to a colon?
This typically occurs after a Windows OS update, a change in system language settings, or when switching to a different regional format (like some European locales) that inherently uses a colon or comma as the default separator.
Can I change the CSV delimiter only for Excel without affecting Windows?
When double-clicking a CSV to open it, Excel directly inherits the Windows OS 'List separator' setting. To use a different delimiter without changing Windows settings, you must use Excel's 'Get Data' or 'Text to Columns' import wizards instead of opening the file directly.
Does changing the list separator affect my Excel formulas?
Yes. The list separator is also used to separate arguments in Excel formulas. If you change it to a semicolon, you will need to write formulas using semicolons, such as '=SUM(A1; B1)' instead of the standard '=SUM(A1, B1)'.
What if the 'Additional settings' button is greyed out in the Control Panel?
If the button is greyed out or missing, it usually means your user account lacks administrative privileges. You will need to contact your IT administrator or log in with an administrator account to modify regional formats.




