Forum Discussion
How to get total number of file counts in SharePoint?
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!
- 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!
- SO HELPFUL! Thank you so much
If PowerShell, ShareGate, or any other nice tools are not available, PowerQuery can work adequately.
In Excel (or PowerBI) : Get data -> From file -> From Sharepoint Folder -> enter your site URL.
Gives a list of all files with the folder path for each file. Work with the folder path (Text to columns maybe) and then pivot to get folders, subfolders, counts, as PamDeGraffenreid noted.
Not pretty but it works 🙂
