Forum Discussion

Greg68's avatar
Greg68
Copper Contributor
Aug 11, 2022

How to Export SharePoint list with over 5000 records to excel

Hello everyone,   Do you have an idea of how to export a SharePoint list with large data, over then 5000 records? when I export to csv, it shows only 5000 and if I export it as Excel query, it sho...
Lists
microsoft lists
SharePoint Online
Greg68's avatar
Greg68
Copper Contributor
Sep 02, 2022

@kalpeshvaghela  Seems this needs an administrator account to run, I am the creator of the list and the site on SharePoint but it asks for an admin account.
Is there a way to overcome this issue?

kalpeshvaghela's avatar
kalpeshvaghela
Iron Contributor
Sep 05, 2022

Greg68 

 

As this script is using PnP.PowerShell, it will require one time consent which can be done by Global Admin User Only.

See Authentication steps here.

 

If it's not possible for you then you need to convert this script to only CSOM PowerShell

 

Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

  • michael1900's avatar
    michael1900
    Copper Contributor
    Jan 12, 2023

    kalpeshvaghela Hi Sir , I try to copy ur code and modify and run in powershell but got below error :

     

    Do you mind to help me to change the code , i really need it .

     

    my site URL : https://danny520.sharepoint.com/sites/teamssites

    List Name: https://danny520.sharepoint.com/sites/teamssites/Lists/list3/AllItems.aspx

     

     

     

    Really appreciated for your help.

Resources