Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .