Forum Discussion

RMDUser1's avatar
RMDUser1
Brass Contributor
Jul 30, 2025
Solved

Find all columns internal names in SharePoint list

Hello!

Is there a way I can find all internal names of columns in a SharePoint site?  Rather than having to go into each column individually and check the URL?

I have 20+ fields and I would like to hope there's a way to run a report of some kind to tell me what all the field names are in one list!

TIA!

 

admin
developer
Lists
microsoft lists
powershell
SharePoint Online
Sites
Usage
  • MrCharlesJenkins's avatar
    MrCharlesJenkins
    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, TypeDisplayName

    This 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,TypeAsString

    Change "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

3 Replies

  • MrCharlesJenkins's avatar
    MrCharlesJenkins
    MCT
    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, TypeDisplayName

    This 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,TypeAsString

    Change "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

Resources