Computing.Net > Forums > Windows XP > Copy directory contents to Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Copy directory contents to Excel

Reply to Message Icon

Name: bjorn
Date: September 3, 2002 at 13:06:46 Pacific
Comment:

Can someone tell me if there a way of copying file names in a directory to an Excel spreadsheet?



Sponsored Link
Ads by Google

Response Number 1
Name: Jason C.
Date: September 3, 2002 at 13:37:48 Pacific
Reply:

bjorn,

If you are running windows 2000, XP etc. (Not sure about 95, 98, ME) then you can use the "tree" command.

Get into DOS (Click Start -> Run -> "cmd").

navigate to your directory you want to list. "tree /?" gives you the options for this command. If you have subdirs use "tree /f" otherwise just use "tree".

What appears on your screen is a picture (a tree) of all your files. Maximize window, highlight with mouse and press enter (ctrl-c does not work to copy ... I don't know why).

Open excel and paste (ctrl-v).

If you are a little more experienced then try the following: "tree > filename" This will place the contentse of the directory listing into a text file called: "filename" which you can then import into Excel.

Hope this helps!!

Cheers
Jason C.


0
Reply to Message Icon

Related Posts

See More


XP internet/firewall clas... a network cable is unplug...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows XP Forum Home


Sponsored links

Ads by Google


Results for: Copy directory contents to Excel

Copying CD Contents To HDD www.computing.net/answers/windows-xp/copying-cd-contents-to-hdd/164839.html

Auto-delete TEMP directory contents? www.computing.net/answers/windows-xp/autodelete-temp-directory-contents/5106.html

Copying a file to multiple folders. www.computing.net/answers/windows-xp/copying-a-file-to-multiple-folders/130650.html