List of file names in a folder in .txt or xls file

At work we have about 2,000 files of .rpt files ( report files ) in a folder on a server.  I want to be able to place those 2,000 filenames in a format that I can put in Excel and run lookup tables on.  Can this be done.??

Who is Participating?
Gary DewrellConnect With a Mentor Senior Network AdministratorCommented:
Hi awehme,
I can tell you a low tech way that works.

from a dos prompt in the directory issue this command:  dir /B > files.txt
then load Excel and open files.txt  It will import the file names into excel.

God Bless
tosh9iiiConnect With a Mentor Commented:
Could you elaborate a little on the "lookup tables"?

But for now see if this does any good:
Gary DewrellSenior Network AdministratorCommented:
What I gave you simply gets the names into excel. Once you have them into excel you can do what ever other functions you want to do.  Here is a step by step article on how to use lookup tables.
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

awehmeAuthor Commented:
Thanks guys.

gdewrell is what i was looking for I didn't know that was out there
awehmeAuthor Commented:
Is there also a way to get the attrib's to the files.  ie. Date, time, size ??
awehmeAuthor Commented:
found it.  It's Just Dir > files.txt
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.