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 (21)

  1. Anonymous says:

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

  2. dom says:

    Cool but how to export this list?

  3. Adrian K says:

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

  4. Thomas Christiansen says:

    Nice tip, thanks.

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

  5. 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.

  6. jay says:

    Great tip thanks

  7. 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

  8. 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

  9. Rivin says:

    How to get all the user profiles using CSOM?

  10. Priya says:

    Thank you! I was searching for this since long

  11. Anonymous says:

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

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

  13. David Tabor says:

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

  14. It is in reality a great and useful piece of info.

    I’m glad that you just shared this helpful information with us.
    Please stay us informed like this. Thanks for

  15. Wow, marvelous weblog structure! How long have
    you ever been blogging for? you made blogging glance easy.

    The overall look of your site is excellent, let alone the content material!

  16. I think this is one of the so much significant info for me.
    And i’m glad studying your article. However should remark on few general issues,
    The web site style is ideal, the articles is
    really great : D. Good process, cheers

  17. TUPPER says:

    Fabulous, what a web site it is! This web site provides useful data to us, keep
    it up.

  18. gain weight says:

    Hmm is anyone else experiencing problems with the images on this blog loading?
    I’m trying to determine if its a problem on my end or if it’s
    the blog. Any responses would be greatly appreciated.

  19. dream says:

    I’m very pleased to find this great site. I want to
    to thank you for your time for this wonderful read!!
    I definitely enjoyed every little bit of it and I have you book-marked to look at new stuff on your website.

  20. Mazie says:

    We absolutely love your blog and find nearly all of your post’s to be just what I’m looking for.
    Do you offer guest writers to write content to suit your needs?
    I wouldn’t mind composing a post or elaborating on a number of the subjects you write regarding here.
    Again, awesome web site!

Skip to main content