1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Exporting folder contents to Excel

Discussion in 'Windows XP' started by ducky, 2005/11/15.

  1. 2005/11/15
    ducky

    ducky Inactive Thread Starter

    Joined:
    2005/11/15
    Messages:
    1
    Likes Received:
    0
    Hi all,
    I was wondering what would be the best way list a folders content to an Excel spreadsheet. Anyone know of any freeware that might do this?
    Thanks for the help. :)
     
  2. 2005/11/15
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    Open a cmd window (start -> run -> cmd & OK)

    Dir /b c:\somefolder > c:\dir-list.txt

    Open c:\dir-list.txt in Excel

    Note that if you want subdirectory contents

    Dir /b /s c:\somefolder > c:\long-dir-list.txt
     
    Newt,
    #2

  3. to hide this advert.

  4. 2005/11/15
    WhitPhil

    WhitPhil Inactive

    Joined:
    2002/01/07
    Messages:
    599
    Likes Received:
    4
    Karen's Directory Printer

    Select the required attributes, save it to file and then parse it back into Excel, if you want each to be in a unique column.
     
  5. 2005/11/18
    DoctorBeaver

    DoctorBeaver Inactive

    Joined:
    2005/11/12
    Messages:
    13
    Likes Received:
    0
    Good freeware

    I came across a neat little utility called Cathy. It's tiny & will list all the files in a folder/sub folder. You can just copy & paste straight into a spreadsheet, db or word processor. The URL for download is...

    http://www.snapfiles.com

    Then follow the links...
    Freeware > System Utilities > Disk Cataloging

    I find it very useful indeed
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.