How do I create a simple excel or word list of the file names of excel files in a particular folder.?

Question

Besides retyping the whole list.

Answer 1

I use the Terminal (/Applications/Utilities/Terminal) to list the directory:
(You can drag & drop a folder into the terminal to get its full path, so you don't need to type it!)
cd /Path/to/Directory
ls

Then I copy and paste it into what ever I like. OS X makes everything easy.

Answer 2

Hi,
I would do it this way: -
Click on start - run - cmd

Then browse to that folder e.g: -
c:/documents and settings/owner/my documents

then type in

dir

this would list all the files in that folder. Then, click on the top left of the window and u will see a drop down menu. From that, click on Edit-Mark. Then select the names of the files and then again click on the top left of the window and click on Edit - copy.


OR

after browsing to that folder, just type this in : -
dir > wordlist.txt

Then go to that folder and u will find a notepad document which will have a list of all those files in that folder.

Then open excel or word and paste the list as simple as that!

If u need help or do not understand any bits, do not hesitate to comment back.

Hope that helps.
Hasnain Mir Mohammed

Answer 3

Click Start
Run
type Cmd
in the console window navigate to the folder your after by using the cd command ie

cd C:/mydocs/bannannas

then type

dir > wordlist.txt

open word list and you will find the names of all your files

if you need anything more explaining, write back

Answer 4

I trust using the command instantaneous to generate a itemizing of archives and then beginning it in Excel. Assuming you desire to get a itemizing of all archives on your C: power, you're able to enter this: C: And press enter. This makes beneficial you're on the proper (root) of the C: power. Then, type this as already pronounced: dir *./s /b >> filename.txt And press enter. you could replace the be conscious "filename" to a minimum of a few thing else like Filelist.txt or regardless of is wise to you . you additionally can type the document to the reveal after that is created, assuming you're on the muse of the C: power, type this: type filename.txt And press enter. The contents of the document will scroll on your reveal. there are the thank you to pause the scrolling, etc., yet whilst all you desire to do is make beneficial it worked, you do no longer could be bothered approximately that. additionally, in case you desire to shrink the document types extremely than getting ALL archives, you could specify a variety like this (utilising Excel archives as an occasion): dir *.xls /s /b >>filename.txt And press enter. basically archives with the .xls extension would be indexed. next, you're able to open the document in Excel - Excel will desire to "parse" the document. in case you basically desire a itemizing in Excel, you could basically click the "end" button. in case you desire the document direction separated into columns, you're able to click the "next" button as quickly as and, on the subsequent reveal, whilst asked appropriate to the delimiters, type a backslash in the "different" determination and then click the "end" button. this could show you how to variety the archives via any area of the document direction. additionally, notice that Excel has a shrink to the form of rows you could import right into a single sheet - you're able to probably exceed that shrink (sixty 5,536) ensuing in an incomplete record. sturdy success

Answer 5

Click start | run
type cmd.exe
press enter
in the black window type:

dir /B [path_to_your_files]\*.xls >> c:\mylist.txt

This will write the names of your Excel files to a text file called mylist.txt. You can than open this in MS-WORD.