• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Tachytelic.net

  • Get in Touch
  • About Me

How to Encode SharePoint Column Display Names to Internal names

June 22, 2021 by Paulie Leave a Comment

When you create a field in a SharePoint list it creates two things:

  • An Internal name
  • A display name, for use in views forms etc.

It is simple to change the display name, but the internal name can never be changed. Sometimes, when you create a column, if the column name contains certain characters, it will be encoded. For example, Paulie’s Test List would become Paulie_x0027_s_x0020_Test_x0020_List.

For this reason I always like to create my field names using camelCase such as pauliesTestList and then modify the display name afterwards. But if you’re working with SharePoint, you are going to come across field names like this on a regular basis.

For much more information on internal column names, check out this useful post written by Tom Riha.

SharePoint Column Name Converter

To make it super easy for you, simply type the name of your SharePoint column here and the correct escaped name will be generated for you in the box below.


List of SharePoint Character Mappings

Below is a complete list of characters that are escaped in SharePoint Column names. I hope you find it useful.

CharacterDescriptionHex CodeInternal SharePoint Code
Space20_x0020_
~Equivalency sign – tilde7E_x007e_
!Exclamation mark!_x0021_
@At symbol40_x0040_
#Number23_x0023_
$Dollar24_x0024_
%Per cent sign25_x0025_
^Caret – circumflex5E_x005E_
&Ampersand26_x0026_
*Asterisk2A_x002a_
(Open parenthesis (or open bracket)28_x0028_
)Close parenthesis (or close bracket)29_x0029_
+Plus2B_x002B_
–Minus or Hyphen2D_x002D_
=Equals3D_x003D_
{Opening brace7B_x007B_
}Closing brace7D_x007D_
:Colon3A_x003A_
“Double quotes (or speech marks)22_x0022_
|Vertical bar or Pipe7C_x007C_
;Semi Coloin3A_x003A_
‘Single Quote27_x0027_
\Backslash5C_x005C_
<Less than (or open angled bracket)3C_x003C_
>Greater than (or close angled bracket)3E_x003E_
?Question mark3F_x003F_
,Comma2C_x002C_
.Period, dot or full stop2E_x002E_
/Slash or divide2F_x002F_
`Grave accent or back tick60_x0060_

Filed Under: Office 365 Tagged With: SharePoint Online

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Link to my LinkedIn Profile
Buy me a coffee

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 245 other subscribers.

Go to mobile version