Forum Discussion
Solved
How to get total number of file counts in SharePoint?
Hello All, I have uploaded multiple folder in SharePoint Site, but many files failed to upload. So now I wants to check in SharePoint that particular folder contain how many subfolders and total fi...
VPatel21 Here you go
1- Export to Excel
2 - Open the downloaded file into Excel. You may get a security prompt, click Enable. The table will be selected by default when it opens.
3 - Go to the Insert Tab, and select Pivot Table
4 - Configure your PivotTable fields like this...
Result:
At the top level there are 4 folders and two files
Every folder has a unique path, so for each path (folder) - you'll get a count of files and folders.
Good luck!
Did you try an export to excel? Open it up and insert a pivot table using Path for rows to get the full folder path and count of files.
Thanks, this was very helpful!