Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'd like to know how many Excel files are on my File Server. There may be hundreds of thousands. When I remote into it and search for *.xls I get a huge list of files. However, when I try to right click and choose properties (for a count and total space used), nothing happens no matter how long I seem to wait.

How can I determine the count and spaced used by this file type?

share|improve this question
add comment

2 Answers

How about running dir *.xls /s >"C:\Temp\xls.txt" at the cmd prompt. It will give you a total file count at the bottom, as well as in each directory, and the space being used.

share|improve this answer
    
nice solution! here is an improved version: dir *.xls *.xlsx /s >"C:\Temp\xls.txt" (this command can include both xls & xlsx, but exclude *.xls.lnk, *.xlsx.lnk, etc) –  wilson Sep 13 '10 at 7:27
add comment

Install the wonderful Everything search engine, call it up and let it search the disk for a few minutes.

Then all you need to do is type *.xls* (for xls and xlsx), to instantly get their count.

share|improve this answer
    
file extension of Excel files is 'xls' & 'xlsx' –  wilson Sep 13 '10 at 7:25
    
@wilson: Oups. Fixed that - thanks. –  harrymc Sep 13 '10 at 7:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.