File names to first column in Excel

cwoodham

Hi, I wonder if anyone can help on this. I need to regularly copy lists of file names from Explore file manager into the first column of an Excel worksheet. What I've been doing till now is highlighting each file then clicking on it to make the name editable, then copying and pasting that into each Excel cell. There must be an easier way for a long list of file names. And I don't want to paste all the file names into one cell. I'm using Excel 2000.
Thanks

f1charlie

How about this:

http://www.webmasterworld.com/forum10/1154.htm

Hungerdunger

I've used Karen's Directory Printer. Set it up to save file names to disk; you can then open that file in Excel and either use that, or if you already have a sheet set up, just copy and paste the filenames.

[Deleted User]

If i need to do something like this, i'll open up a command prompt (Start menu -> run -> 'cmd') then find the directory and list it's content.. copy and paste from the box and import into Excel.

But i'm a geek...

cwoodham

Thanks for the replies. It seems the way to go is to import a text file of the file names from a directory listing into Excel. Next question. The text file from the directory listing gives info I don't need: date, time, file size then the file name. I need to quickly delete all the stuff before the file name in each row of the text file. I use Notepad++ but it will only select horizontally for deleting. I need to be able to select vertically. Does anyone know of a quick way to select vertically? I know I can do it in Word by dragging the mouse while holding the Alt key but what about text files and text editors?

isofa

You won't need to, open the directory listing text file in Excel, and it'll bring up a Text Import dialog, set it to fixed width (not delimited), and go through the wizard, you'll find the data in different columns, the filenames should be in E. Just remove the columns you don't need.

rmg1

If you can write macros, you can use the DIR command to set a directory and then loop it to read each filename in turn. All you have to do is increase the row number each time you loop to move down a row.

tarden

Open a command window. Navigate to the directory you're interested in using the cd command. When you are in there, enter the following:
dir /b > tempfile.txt
That puts a list of the files in the textfile tempfile.txt.
Open that file in Excel and you're done.

Pauls

Open a command window. Navigate to the directory you're interested in using the cd command. When you are in there, enter the following:
dir /b > tempfile.txt
That puts a list of the files in the textfile tempfile.txt.
Open that file in Excel and you're done.

This'll work perfectly, just make sure you open excel and select 'file/open' otherwise the wizard won't start. You can define which columns you want to keep in this wizard so this solves all of your problems

isofa

Is this post in Groundhog day?!

f1charlie

How about this:

http://www.webmasterworld.com/forum10/1154.htm