Forum Discussion

Copper Contributor

Jul 14, 2020

SharePoint - How to export SharePoint User Profile Information values in CSV using powershell

Hi All, I'm new to SharePoint and I'm trying to automate the process of exporting all the user's information to a CSV file using Powershell. I've got some sample PowerShell script but it doesn't ...

Power Shell

users

gk_vasudev

Brass Contributor

Jul 16, 2020

Hi Abhi04 ,

Yes, You need to have SharePoint Admin rights

and establish the connection to SharePoint Online using Admin Credentials ,to perform Tasks like Exporting SharePoint User Profile information. Also do Check the cmdlets you used and its argument list.

and it is always recommended to use PowerShell as Administrator and use

Powershell ISE (Integrated Scripting Environment) for Automation.

Abhi04

Copper Contributor

Jul 16, 2020

Hi gk_vasudev,

Thank you for your response.

Quick question: I'm the owner of the site but not an admin. I can see all the user information on the SharePoint online site. With me having owner rights, is it not possible to export the user profile information in Powershell?

gk_vasudev
Brass Contributor
Jul 17, 2020
No, its not possible. powershell only allows admins to export profile information.