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

   

 

Note

• 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

• Anonymous
  January 01, 2003
  Cool..tip of the day :) Thanks for sharing..

• Anonymous
  June 21, 2012
  Great post! thanks.

• Anonymous
  June 05, 2013
  Cool but how to export this list?

• Anonymous
  July 08, 2013
  How would a user (non-admin) find a list of all users?

• Anonymous
  October 23, 2013
  Nice tip, thanks. Is there any way you can get pass the 50 user limit in the query?

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

• Anonymous
  February 06, 2014
  Great tip thanks

• Anonymous
  May 13, 2014
  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
  

• Anonymous
  August 18, 2014
  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

• Anonymous
  September 29, 2014
  Hi,
  How to get all the user profiles using CSOM?
  

• Anonymous
  December 06, 2015
  Thank you! I was searching for this since long

• Anonymous
  February 20, 2016
  Not that I'm counting but I just realized one of my blog posts actually is closing in on 100k views

• Anonymous
  April 03, 2017
  I always search, in the find profiles textbox, on the Active Directory name itself to find all internal users...

• Anonymous
  April 06, 2017
  It appears it only shows the first 50 results. Any way to get around this?

• Anonymous
  May 08, 2017
  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 sharing.

• Anonymous
  May 13, 2017
  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!

• Anonymous
  May 22, 2017
  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

• Anonymous
  May 29, 2017
  Fabulous, what a web site it is! This web site provides useful data to us, keep it up.

• Anonymous
  July 23, 2017
  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.

• Anonymous
  August 11, 2017
  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.

• Anonymous
  October 30, 2017
  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!