up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
50% accept rate
feedback

2 Answers

up vote 1 down vote

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.

link|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
feedback
up vote 0 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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