How to find internal Column name in SharePoint

Question

I am attempting to use a migration tool that will extract properties from images (drone photos) and map them to columns in SharePoint Online. I'm focused on one property just to get the ball rolling.

In the image, I'm confident Altitude is represented as GPSAltitude. I've created a column called Altitude in SharePoint, but am not having luck. The tool requires that a txt file contain the property in the image be mapped to the corresponding SharePoint internal column name. Based on the examples given in the txt file, I'm guessing I have the internal SharePoint column name wrong. Please see the image below:

Answer 1

We can use the SharePoint Client Browser (SPCB) uses the SharePoint API (a.k.a. CSOM) to connect to a remote SharePoint site collection and shows the site structure with related properties and values.

Download: SharePoint Online Client Browser v4.3

More information: SharePoint Client Browser (SPCB)

Answer 2

Step to see Internal column name: 1.Open list.(whatever your list is)
2.Click on gear icon located on top right side.
3.Click on List Settings
4.Then scroll down, you will find column names in left side of screen.
5.Click on column name.
6.Then see its URL
i am attaching screenshot for your reference.

Answer 3

There are multiple ways to get the internal name of your SharePoint online column, via SharePoint UI (modern experience as well as classic experience), SharePoint REST API, PnP PowerShell or CLI for Microsoft 365, etc.

From SharePoint UI:

1. Go to the SharePoint online list.
2. Click on Settings (gear) icon from the top right corner and select "List settings".
3. Scroll down to the "Columns" section and click on the column name for which you want to find the internal name.
4. SharePoint will open column settings page for the respective column with browser URL like:

https://contoso.sharepoint.com/sites/wlive/_layouts/15/FldEdit.aspx?List=%7B6FBA7FAE-AFC0-45D6-99EE-0AB20629EE41%7D&Field=MultilineTextCol

Where column name (MultilineTextCol) after Field= is the internal name of your SharePoint online multiple lines of text column.

---

Using SharePoint REST API:

You can also use endpoint like below to get the internal name using SharePoint REST API:

https://contoso.sharepoint.com/sites/SPConnect/_api/web/lists/getbytitle('List Name')/fields?$select=Title,InternalName&$filter=Title eq 'Created By'

---

Using PnP PowerShell:

# Get internal name of SharePoint list column
Get-PnPField -Identity "My Column Display Name" -List "My List Name" | Select Title,InternalName

You can understand other ways to find internal name of SharePoint list columns, best practices for naming SharePoint columns, etc. in this article: How to find the Internal name of columns in SharePoint Online?

Answer 4

For anyone still wanting to do this, I have created a bookmark to get internal names of SharePoint columns that can be found here: https://github.com/A-Murchison/SharePoint-Shortcuts

After adding the bookmark you can click it to view the internal name like below:

Answer 5

For On Prem versions of SharePoint: 1.) Go to List Settings. 2.) Hover your cursor ver the name of the column. 3.) Look for the URL at the bottom of the page, the end of which is the internal name of your column.