Forum Discussion
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 files.
Like in windows we right click on folder and hit on properties so it shows total number of files in particular folder.
So can anyone help me for that in share point?
Note: I have multiple subfolders so "Item Child Count" and "Folder Child Count" columns not useful for me.
Thanks,
VP
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!
8 Replies
- 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!
PamDeGraffenreid Can you pls explain me step?
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!
