Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: sort files/folders using multiple criteria

30 Aug 2011   #1
rustyw

Windows 7
 
 
sort files/folders using multiple criteria

Hi,

Is there an easy way to sort files/folders using multiple criteria--say by size, date and folder for instance? A free utility perhaps?

and/or

An easy way to capture the data in Wins' file explorer (view=detail) that I can bring into EXCEL?

Thanks,
Rusty


My System SpecsSystem Spec
.
30 Aug 2011   #2
gigagiggles

Windows 7 Home Premium x64
 
 

A directory lister program from krksoft seems fairly easy to use. Trial and error to get the output CSV file you want or need from the many options available. Otherwise, Windows has its own command prompt, 'dir', and plenty of options as well.
My System SpecsSystem Spec
30 Aug 2011   #3
Quatrix

Windows 7 Professional x64
 
 

I'm not sure if this is what you mean, but you can sort by multiple columns in Explorer. Shift-click columns to specify additional criteria. For example, let's say you want to sort by type (application, text file, whatever) and then by date modified. First click the "Type" column so that it shows an arrow pointing up, indicating ascending order. Hold Shift and then click the "Date modified" column. The up arrow remains on the "Type" column, but now the date modified is a secondary sort key. Shift-click "Date modified" again to switch between ascending/descending.

If you want to export a directory listing to Excel or whatever, I agree with the "dir" suggestion. You can import using whitespace as the delimiter.
My System SpecsSystem Spec
.

02 Sep 2011   #4
rustyw

Windows 7
 
 

Quote   Quote: Originally Posted by Quatrix View Post
I'm not sure if this is what you mean, but you can sort by multiple columns in Explorer. Shift-click columns to specify additional criteria. For example, let's say you want to sort by type (application, text file, whatever) and then by date modified. First click the "Type" column so that it shows an arrow pointing up, indicating ascending order. Hold Shift and then click the "Date modified" column. The up arrow remains on the "Type" column, but now the date modified is a secondary sort key. Shift-click "Date modified" again to switch between ascending/descending.

If you want to export a directory listing to Excel or whatever, I agree with the "dir" suggestion. You can import using whitespace as the delimiter.
Awesome!!

Thanks!
Rusty
My System SpecsSystem Spec
Reply

 sort files/folders using multiple criteria




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to get folders to sort both subfolders and files?
When I sort my folders using "date modified," instead of ordering everything, I instead get all of the subfolders sorted, and then below that everything else, so it looks like this: FOLDER A: 10th Jan FOLDER B: 7th Jan FOLDER C: 5th Jan Randomfile.png: 12th Jan Randomfile.mp3: 11th Jan...
General Discussion
Explorer Slow to sort folders/files.
Why is there a huge delay on the sorting of files/folders in windows explorer? If I enter a folder that has many subfolders and extra files, it seems to load everything at once in alphabetical order, then there's a delay while it sorts the folders and the individual files separately, also in...
Performance & Maintenance
Removing the de facto sort into files and folders
In Win 7 explorer, I note that whatever settings I use for file/folder sorting - it all appears to get over-ridden by an initial sort into a) folders and b) files. Even if a file and a folder have the same name (bar the extension) I cannot get the files and folders to intermingle as I expect. ...
General Discussion
Win 7 sort by date issue - 2011 files/folders now "A Long Time Ago"
Hello there & Happy New Year. :) :party: I have encountered this particular inconvenience on the 2nd day of 2012 while i was transfering photos and files into my PC with Win7. In my Win7 PC, all files/folders created or modified within Dec'2011 and earlier are now all grouped under as "A Long...
General Discussion
Sort Order for folders
Hi, Somehow my sort order has been changed somehow. On another post I see that it goes to the view tab to change the order, however the view tab is not shown when I open a folder. What I see is "organize, share with, Burn, and new folder. I would like to change back to normal aphabetical...
Customization
sort by size within folders
Hi Forum! I've been on Windows 7 for a week. One difference I've noticed between 7 and Vista is I can't see any way to sort files in a folder (say, video, jpegs, or documents) by size. They are all automatically sorted by name. Is there a way to do this I just haven't found yet? Thanks, ...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:05.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App