How to Fix Unexpected Internal Names in SharePoint List Columns
Question details
Users are experiencing an issue where certain SharePoint list columns are assigned unexpected, encoded internal names.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Creating new columns in a SharePoint list manually or via the Microsoft 365 CLI.
- Observed behavior
- Specific column names like ABC1 or Fax1 receive encoded internal names (e.g., _x0041_BC1), while other similar names remain completely unchanged.
Ensure you have Site Owner or List Administrator permissions to create, edit, and review list settings before proceeding with these troubleshooting steps.
Test and Verify Column Names in a New SharePoint List
Since this behavior might be isolated to a specific list or environment, creating a clean test list helps determine if the encoding is a persistent system rule or a localized glitch.
SharePoint automatically encodes certain characters in internal field names to ensure URL safety. However, standard alphanumeric names shouldn't normally trigger this unless they conflict with reserved system properties or formatting rules.
Navigate to your SharePoint Site contents, click on 'New', and select 'List'. Choose 'Blank list' to ensure no pre-existing templates interfere with your test.
Click 'Add column' in your new list and type the exact names that previously failed (e.g., ABC1, Fax1). Save the columns.
Click the Gear icon (Settings) and select 'List settings'. Scroll down to the Columns section and click on the newly created column.
In your browser's address bar, look at the very end of the URL for 'Field='. The text immediately following the equals sign is your true internal column name. Note whether it encoded to _x0041_BC1 or remained ABC1.

Use the Rename Strategy for Clean Internal Names
Use a proven workaround to force SharePoint to assign a clean internal name before changing the display name to your desired title.
Try WPS Office for Seamless Document Management
While SharePoint and Microsoft 365 handle your list architectures, managing your actual documents shouldn't be a hassle. WPS Office is a lightweight, highly compatible alternative to Microsoft Office that lets you edit Word, Excel, and PowerPoint files flawlessly and for free.
- 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and launch: Run the installer and follow the on-screen prompts. Once installed, open WPS Office.
- 3. Open your Microsoft formats: Drag and drop your existing .docx, .xlsx, or .pptx files directly into the WPS workspace to continue editing seamlessly.

Frequently Asked Questions
Why does SharePoint encode characters in column names?
SharePoint internal names are used in databases, URLs, and API calls. To prevent system errors, SharePoint encodes spaces (as _x0020_) and certain special or leading characters into their hexadecimal equivalents so they remain URL-safe and schema-compliant.
Can I change a SharePoint column's internal name after it is created?
No, a SharePoint column's internal name is permanently locked the moment it is created. If you need a different internal name, you must delete the existing column and create a new one with the correct initial name.
How can I find the true internal name of a SharePoint column?
Navigate to the list, click the gear icon to open 'List settings', and click on the specific column name. Look at the browser's address bar; the internal name is the text located at the very end of the URL, right after 'Field='.




