Quick Tip: How to list all user profiles in SharePoint Online

To list the user profiles of all SharePoint Online users in your tenant you can follow these steps

  1. Navigate to the User Profiles tab in the SharePoint Administration Center and click Manage User Profiles


  2. In the “Find profiles” text box type i:0#.f|membership

  3. Click the Find button to see the list of all user profiles



  • Currently there is no way to list external users (PALs)
  • In case you wonder – the “f” in the search string means we are using forms based authentication
Comments (14)

  1. Anonymous says:

    Cool..tip of the day 🙂 Thanks for sharing..

  2. Lior Arviv says:

    Great post! thanks.

  3. dom says:

    Cool but how to export this list?

  4. Adrian K says:

    How would a user (non-admin) find a list of all users?

  5. Thomas Christiansen says:

    Nice tip, thanks.

    Is there any way you can get pass the 50 user limit in the query?

  6. Lou M says:

    a non-admin user can search People and contentclass=SPSPeople AccountName:live.com since all non-anonymous external users are associated with Microsoft account.

  7. jay says:

    Great tip thanks

  8. Keith says:

    Have had a ticket open for days with MS on how to do just this!
    Just need to export this as a csv and work out how to make it only have current users

    The issue I have is when a user leaves there profile stay and HR complain as they then still show in the org charts

    Deleting the profile on SPO will have to be an additional step in the leavers process 🙁
    I don’t like manual processes

  9. Serge says:

    Great tip.. My list cuts off at 50. How can I get the full list?

    Your search returned too many results. Only the first 50 results are shown on this page

  10. Rivin says:

    How to get all the user profiles using CSOM?

  11. Priya says:

    Thank you! I was searching for this since long

  12. Anonymous says:

    Not that I’m counting but I just realized one of my blog posts actually is closing in on 100k views

  13. I always search, in the find profiles textbox, on the Active Directory name itself to find all internal users…

  14. David Tabor says:

    It appears it only shows the first 50 results. Any way to get around this?

Skip to main content