SOLVED

How to get total number of file counts in SharePoint?

%3CLINGO-SUB%20id%3D%22lingo-sub-3459644%22%20slang%3D%22en-US%22%3EHow%20to%20get%20total%20number%20of%20file%20counts%20in%20SharePoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459644%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3CBR%20%2F%3EI%20have%20uploaded%20multiple%20folder%20in%20SharePoint%20Site%2C%20but%20many%20files%20failed%20to%20upload.%3C%2FP%3E%3CP%3E%3CSTRONG%3ESo%20now%20I%20wants%20to%20check%20in%20SharePoint%20that%20particular%20folder%20contain%20how%20many%20subfolders%20and%20total%20files.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20in%20windows%20we%20right%20click%20on%20folder%20and%20hit%20on%20properties%20so%20it%20shows%20total%20number%20of%20files%20in%20particular%20folder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20can%20anyone%20help%20me%20for%20that%20in%20share%20point%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%20I%20have%20multiple%20subfolders%20so%20%22Item%20Child%20Count%22%20and%20%22Folder%20Child%20Count%22%20columns%20not%20useful%20for%20me.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EVP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3459644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3463047%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20total%20number%20of%20file%20counts%20in%20SharePoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3463047%22%20slang%3D%22en-US%22%3EDid%20you%20try%20an%20export%20to%20excel%3F%20Open%20it%20up%20and%20insert%20a%20pivot%20table%20using%20Path%20for%20rows%20to%20get%20the%20full%20folder%20path%20and%20count%20of%20files.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3463075%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20total%20number%20of%20file%20counts%20in%20SharePoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3463075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195800%22%20target%3D%22_blank%22%3E%40PamDeGraffenreid%3C%2FA%3E%26nbsp%3B%20Can%20you%20pls%20explain%20me%20step%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3465037%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20total%20number%20of%20file%20counts%20in%20SharePoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3465037%22%20slang%3D%22en-US%22%3EIf%20PowerShell%2C%20ShareGate%2C%20or%20any%20other%20nice%20tools%20are%20not%20available%2C%20PowerQuery%20can%20work%20adequately.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Excel%20(or%20PowerBI)%20%3A%20Get%20data%20-%26gt%3B%20From%20file%20-%26gt%3B%20From%20Sharepoint%20Folder%20-%26gt%3B%20enter%20your%20site%20URL.%3CBR%20%2F%3E%3CBR%20%2F%3EGives%20a%20list%20of%20all%20files%20with%20the%20folder%20path%20for%20each%20file.%20Work%20with%20the%20folder%20path%20(Text%20to%20columns%20maybe)%20and%20then%20pivot%20to%20get%20folders%2C%20subfolders%2C%20counts%2C%20as%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195800%22%20target%3D%22_blank%22%3E%40PamDeGraffenreid%3C%2FA%3E%20noted.%3CBR%20%2F%3E%3CBR%20%2F%3ENot%20pretty%20but%20it%20works%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3465557%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20total%20number%20of%20file%20counts%20in%20SharePoint%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3465557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1411343%22%20target%3D%22_blank%22%3E%40VPatel21%3C%2FA%3E%26nbsp%3B%20Here%20you%20go%3C%2FP%3E%3CP%3E1-%20Export%20to%20Excel%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PamDeGraffenreid_0-1654271036491.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PamDeGraffenreid_0-1654271036491.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377437iC6431EBA9333C7CC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PamDeGraffenreid_0-1654271036491.png%22%20alt%3D%22PamDeGraffenreid_0-1654271036491.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2%20-%26nbsp%3B%20Open%20the%20downloaded%20file%20into%20Excel.%26nbsp%3B%20You%20may%20get%20a%20security%20prompt%2C%20click%20Enable.%26nbsp%3B%20The%20table%20will%20be%20selected%20by%20default%20when%20it%20opens.%3C%2FP%3E%3CP%3E3%20-%20Go%20to%20the%20Insert%20Tab%2C%20and%20select%20Pivot%20Table%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PamDeGraffenreid_1-1654271150985.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PamDeGraffenreid_1-1654271150985.png%22%20style%3D%22width%3A%20281px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377440i22DC48CD1BC8900B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PamDeGraffenreid_1-1654271150985.png%22%20alt%3D%22PamDeGraffenreid_1-1654271150985.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E4%20-%20Configure%20your%20PivotTable%20fields%20like%20this...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PamDeGraffenreid_2-1654271223795.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PamDeGraffenreid_2-1654271223795.png%22%20style%3D%22width%3A%20305px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377441iB4C5445C572E7BF6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PamDeGraffenreid_2-1654271223795.png%22%20alt%3D%22PamDeGraffenreid_2-1654271223795.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EResult%3A%3C%2FP%3E%3CP%3EAt%20the%20top%20level%20there%20are%204%20folders%20and%20two%20files%3C%2FP%3E%3CP%3EEvery%20folder%20has%20a%20unique%20path%2C%20so%20for%20each%20path%20(folder)%20-%20you'll%20get%20a%20count%20of%20files%20and%20folders.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PamDeGraffenreid_3-1654271326385.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PamDeGraffenreid_3-1654271326385.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377444i2A8422636EBBAD62%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PamDeGraffenreid_3-1654271326385.png%22%20alt%3D%22PamDeGraffenreid_3-1654271326385.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

4 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.

@PamDeGraffenreid  Can you pls explain me step?

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 :)
best response confirmed by VPatel21 (New Contributor)
Solution

@VPatel21  Here you go

1- Export to Excel

PamDeGraffenreid_0-1654271036491.png

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

PamDeGraffenreid_1-1654271150985.png

4 - Configure your PivotTable fields like this...

PamDeGraffenreid_2-1654271223795.png

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.

PamDeGraffenreid_3-1654271326385.png

Good luck!