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

Posted on 2004-08-20
Last Modified: 2010-04-03
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.??

Question by:awehme
  • 3
  • 2
LVL 12

Accepted Solution

Gary Dewrell earned 400 total points
ID: 11857382
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

Assisted Solution

tosh9iii earned 100 total points
ID: 11857384
Could you elaborate a little on the "lookup tables"?

But for now see if this does any good:
LVL 12

Expert Comment

by:Gary Dewrell
ID: 11857393
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.
New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.


Author Comment

ID: 11857398
Thanks guys.

gdewrell is what i was looking for I didn't know that was out there

Author Comment

ID: 11857587
Is there also a way to get the attrib's to the files.  ie. Date, time, size ??

Author Comment

ID: 11857612
found it.  It's Just Dir > files.txt

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Solaris SUN OS 4.1.3 machine clone 3 42
NetApp vFiler Question 2 44
vSphere Distributed Switch - Load Based teaming for Storage Network traffic 4 90
Veeam Manuall Backup 2 59
Solid State Drive Performance Tips: Solid state storage technology is now a standard.  After testing and using several different brands and revisions of SSD's over the years I have put together a collection of tips,tools and suggestions that I ha…
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now