List of files in excel from entire site collection, Please help in script which should export all the files in excel from site collection

@sns Please run the following script on the SharePoint Management Shell as an admin. 21477-script-xlsx1.txt Thanks, Echo Du ---------- If the response is helpful, please click " Accept Answer " and upvote it

here is the script which generates all files inventory report for Sharepoint site collection using CSOM (i.e. should work both for Sharepoint on-prem and online): SharePoint Online: Get All Documents Inventory in a Site using PowerShell Note that if you work with on-prem then depending on your version of Sharepoint you may need to change path to CSOM dlls in the beginning of the script. E.g. if you have Sharepoint 2013 change path to these: Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" (i.e. change 16 to 15 in the path). Read more: https://www.sharepointdiary.com/2018/03/sharepoint-online-get-all-documents-using-powershell.html#ixzz6Wi64VzT2

list of files in excel from entire site collection

Accepted answer

Echo Du_MSFT 17,181 Reputation points

2020-08-31T08:40:17.507+00:00

@sns

Please run the following script on the SharePoint Management Shell as an admin.
21477-script-xlsx1.txt

Thanks,
Echo Du

----------

If the response is helpful, please click "Accept Answer" and upvote it
Please sign in to rate this answer.
sns 9,236 Reputation points

2020-08-31T09:07:48.047+00:00

Hi Echo Du,
I tried the script you have given, came up with below error.

At line:9 char:95

... Types -eq $true) // All Document Libraries

~
Missing statement block after if ( condition ).

CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordEx
ception

FullyQualifiedErrorId : MissingStatementBlock

Echo Du_MSFT 17,181 Reputation points

2020-08-31T12:13:43.503+00:00

@sns

You could try to run the following script, the script only supports loop through excel files in a specific Document Library.
21611-script-xlsx.txt

For the script that loop through all excel files in the Site collection, we are performing research test.

Thanks,
Echo Du

----------

If the response is helpful, please click "Accept Answer" and upvote it

sns 9,236 Reputation points

2020-08-31T12:36:20.11+00:00

Hi Echo Du,
First script you have given for library alone, worked but no data in excel file.
For second script I will wait.

Echo Du_MSFT 17,181 Reputation points

2020-09-01T01:00:47.8+00:00

@sns

Thanks for your support.

Please run the following script on the SharePoint Management Shell as an admin.
21771-script-xlsx1.txt

Thanks,
Echo Du

----------

If the response is helpful, please click "Accept Answer" and upvote it

sns 9,236 Reputation points

2020-09-01T06:43:05.127+00:00

Hi Echo,
script "script-xlsx1.txt" worked , which pulled only xlsx type files
so do we need to replace .doc, .docx , pdf and .jpg for other types of files in the same script?
can we do at one shot to pull all types of files?

Echo Du_MSFT 17,181 Reputation points

2020-09-01T11:12:20.993+00:00

@sns

Yes, you can modify script code to list the specific type files.

For example :

if($filetype -eq "docx") # list all word files if($filetype -ne $null) # list all types of files

Thanks,
Echo Du

----------

If the response is helpful, please click "Accept Answer" and upvote it

sns 9,236 Reputation points

2020-09-02T05:39:12.153+00:00

This one worked
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

list of files in excel from entire site collection

1 additional answer

Read more: https://www.sharepointdiary.com/2018/03/sharepoint-online-get-all-documents-using-powershell.html#ixzz6Wi64VzT2

Your answer