Show the total number of files in a SharePoint library

%3CLINGO-SUB%20id%3D%22lingo-sub-3179573%22%20slang%3D%22de-DE%22%3EShow%20the%20total%20number%20of%20files%20in%20a%20SharePoint%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3179573%22%20slang%3D%22de-DE%22%3E%3CP%3EMy%20users%20(non%20developers)%20are%20often%20complaining%20that%20it%20is%20so%20hard%20in%20SharePoint%20to%20show%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20total%20number%20of%20files%20(not%20items)%20in%20a%20library%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20its%20possible%20to%20see%20the%20total%20number%20of%20items%20if%20I%20go%20to%20%22site%20contents%22%20and%20find%20the%20document%20library%20there.%20But%20this%20includes%20the%20folders.%20Often%20people%20are%20interested%20how%20many%20files%20are%20there.%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20total%20number%20of%20files%20inside%20a%20folder%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Windows%20Explorer%20I%20can%20right%20click%20a%20folder%20and%20see%20the%20number%20of%20files%20in%20the%20details.%20But%20in%20SharePoint%20I%20can%20only%20show%20the%20top%20level%20children%20via%20changing%20the%20view%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22David_Elsner_0-1645114949463.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349107i08433F8F038EBB70%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22David_Elsner_0-1645114949463.png%22%20alt%3D%22David_Elsner_0-1645114949463.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20info%20is%20worthless%20for%20most%20of%20the%20people.%20They%20want%20to%20see%20the%20number%20of%20files%20including%20all%20sub%20folders.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Is%20there%20a%20way%20to%20archive%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20huge%20document%20libraries%20and%20it%20is%20not%20recommended%20to%20sync%20those%20via%20OneDrive%20client.%20This%20would%20be%20a%20(bad)%20way%20to%20archive%20what%20we%20need%20via%20Windows%20Explorer.%3C%2FP%3E%3CP%3EBut%20there%20must%20be%20a%20way%20in%20SharePoint%20how%20to%20do%20this%20that%20does%20not%20require%20a%20PowerShell%20skript.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20how%20to%20(easily%2C%20for%20normal%20users)%20do%20this%20in%20the%20GUI%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3179573%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3Efiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFolders%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EViews%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3181271%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20the%20total%20number%20of%20files%20in%20a%20SharePoint%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3181271%22%20slang%3D%22en-US%22%3ENot%20sure%20if%20this%20will%20work%20on%20a%20large%20library%2C%20but%20you%20could%20try%20exporting%20to%20Excel%20and%20filter%20to%20only%20see%20the%20Item%20Type%20-%20Item.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3191383%22%20slang%3D%22de-DE%22%3ESubject%3A%20Show%20the%20total%20number%20of%20files%20in%20a%20SharePoint%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191383%22%20slang%3D%22de-DE%22%3EYou%20can%20use%20the%20sum%20function%20of%20a%20view%3C%2FLINGO-BODY%3E
Contributor

My users (non developers) are often complaining that it is so hard in SharePoint to show:

 

- The total number of files (not items) in a library

 

I know that its possible to see the total number of items if I go to "site contents" and find the document library there. But this includes the folders. Often people are interested how many files are there.

Is there any way to do this?

 

- The total number of files inside a folder

 

In the Windows Explorer I can right click a folder and see the number of files in the details. But in SharePoint I can only show the top level children via changing the view:

 

David_Elsner_0-1645114949463.png

 

But this info is worthless for most of the people. They want to see the number of files including all sub folders. 

 

- Is there a way to archive this?

 

We have huge document libraries and it is not recommended to sync those via OneDrive client. This would be a (bad) way to archive what we need via Windows Explorer.

But there must be a way in SharePoint how to do this that does not require a PowerShell skript.

 

Any idea how to (easily, for normal users) do this in the GUI?

3 Replies
Not sure if this will work on a large library, but you could try exporting to Excel and filter to only see the Item Type - Item.
You can use the sum function of a view
What do you mean with "sum"-function?