Data Import & Export

How to Change Excel's Imported File Separator from Colon to Semicolon

Phi Hung VoPhi Hung Vo Nov 10, 2026 869 views

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.

How to Change Excel's Imported File Separator from Colon to Semicolon
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Control Panel

Click the Windows Start menu, type 'Control Panel' in the search bar, and press Enter to launch the application.

2
Navigate to Region Settings

Click on 'Clock and Region', then select 'Region' to open the system formats dialog box.

3
Access Additional Settings

At the bottom of the Formats tab, click on the 'Additional settings...' button to customize your regional formats.

4
Change the List Separator

In the Numbers tab, locate the 'List separator' field. Delete the colon (:) and type in a semicolon (;).

5
Apply and Restart

Click 'Apply' and then 'OK' to save your changes. Launch Excel and import your CSV file again to verify the data is parsed correctly.

Modify the Windows Regional List Separator
System-wide Application: This change will apply to all applications on your Windows system that rely on the default list separator, ensuring consistent data formatting across your entire computer.
Seamless CSV Data Import

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. 1. Launch WPS Spreadsheet: Open WPS Office and create a new blank Spreadsheet.
  2. 2. Import Your Data: Go to the 'Data' tab on the top ribbon, click 'Import Data', and select your CSV or text file.
  3. 3. Configure the Wizard: In the Text Import Wizard, choose 'Delimited' and click 'Next'.
  4. 4. Select the Delimiter: Check the 'Semicolon' option under Delimiters to instantly preview your properly separated data.
  5. 5. Finish the Import: Click 'Finish' to import the correctly formatted data into your spreadsheet.
Select custom delimiters directly during file import without touching system settings.Fully compatible with Microsoft Excel CSV, TXT, and XLSX formats.Free, lightweight, and fast office suite for daily data management.Intuitive user interface that makes formatting complex data quick and effortless.
microsoft office alternative - wps office

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.