Windows 11 uses the regional list separator when some programs interpret or export delimited data. In the United States it is commonly a comma, but another character may be used when regional number formats make a comma unsuitable. The setting is part of the older Region control panel rather than the main Windows 11 Settings app.
How to Change the List Separator in Windows 11
- Open Start and search for Region.
- Open the Region control-panel result.
- Select Additional settings.
- Find List separator on the Numbers tab.
- Enter the separator you need.
- Select Apply, then OK.
Close and reopen applications that were already running so they can pick up the changed regional setting.
Why Excel Users Change This Setting
Excel can use the Windows list separator when opening or saving certain delimited text files. However, changing the Windows setting is system-wide and can affect other applications. If your only goal is importing one CSV or text file, Excel’s import tools may let you specify that file’s delimiter without changing Windows globally.
Comma vs. Semicolon
Some regions use a comma as the decimal symbol. In those configurations, a semicolon is often used as the list separator so decimal values are not confused with field boundaries. Do not change the separator without considering the regional number format and the format expected by other systems.
Changing the Separator Does Not Rewrite Existing Files
The setting affects how compatible applications handle delimiters going forward. It does not automatically convert the characters inside existing CSV or text files. If an existing file uses the wrong delimiter, import or transform that file explicitly.
Work or School Computers
Regional settings may be standardized by an organization. If a required application depends on a particular delimiter, confirm its requirements before making a system-wide change. In data workflows, explicitly selecting the delimiter during import/export is often more reliable than assuming every computer has the same Windows list separator.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.