Forum Discussion
Find all columns internal names in SharePoint list
- Jul 30, 2025
es! You absolutely can get all internal names of columns in a SharePoint list without checking them one by one manually. Here are the two most efficient ways, depending on your level of access and tools available:
Option 1: Use PowerShell
If you have access to PowerShell and PnP module installed:# Connect to the site Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/yoursite" -UseWebLogin # Get fields from your list Get-PnPField -List "Your List Name" | Select InternalName, Title, TypeDisplayNameThis will give you a clean table of:
- InternalName (what you want)
- Title (the display name)
- TypeDisplayName (type of column)
Option 2: Use SharePoint REST API in Browser
In your browser, paste the following URL (replace accordingly):https://yourtenant.sharepoint.com/sites/yoursite/_api/web/lists/getbytitle('Your List Name')/fields?$select=Title,InternalName,TypeAsStringChange "yourtenant", "yoursite" and "Your List Name"
You’ll get a full JSON response with all the info.
------------------------------------
Don't forget to mark as solution if my answer suits you
es! You absolutely can get all internal names of columns in a SharePoint list without checking them one by one manually. Here are the two most efficient ways, depending on your level of access and tools available:
Option 1: Use PowerShell
If you have access to PowerShell and PnP module installed:
# Connect to the site
Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/yoursite" -UseWebLogin
# Get fields from your list
Get-PnPField -List "Your List Name" | Select InternalName, Title, TypeDisplayNameThis will give you a clean table of:
- InternalName (what you want)
- Title (the display name)
- TypeDisplayName (type of column)
Option 2: Use SharePoint REST API in Browser
In your browser, paste the following URL (replace accordingly):
https://yourtenant.sharepoint.com/sites/yoursite/_api/web/lists/getbytitle('Your List Name')/fields?$select=Title,InternalName,TypeAsStringChange "yourtenant", "yoursite" and "Your List Name"
You’ll get a full JSON response with all the info.
------------------------------------
Don't forget to mark as solution if my answer suits you