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...
  • MrCharlesJenkins's avatar
    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