Transferring File names to Excel

John M Carter

I have a lot of Audio files in mp3 format and I want to transfer the file
names into a spreadsheet - not the files themselves. Is there a simple way
of doing this. Any help gratefully received.

Jim

"John M Carter" <.uk> wrote in message
news:%23D$.gbl...
>I have a lot of Audio files in mp3 format and I want to transfer the file
>names into a spreadsheet - not the files themselves. Is there a simple way
>of doing this. Any help gratefully received.
>
You first get a list of all the files.
Then you import that list into your spreadsheet.

One way to get the list is:

Start/Run Cmd
cd <folder>
dir > file.txt
exit

There are other ways to get a list of files...

It is up to you to know how to load file.txt into your spreadsheet program.

Jim

Umesh Thota

paste it using tab seperation that will paste each in different cells.

"Jim" <> wrote in message
news:I0ymi.27957$.prodigy.n et...
>
> "John M Carter" <.uk> wrote in message
> news:%23D$.gbl...
>>I have a lot of Audio files in mp3 format and I want to transfer the file
>>names into a spreadsheet - not the files themselves. Is there a simple way
>>of doing this. Any help gratefully received.
>>
> You first get a list of all the files.
> Then you import that list into your spreadsheet.
>
> One way to get the list is:
>
> Start/Run Cmd
> cd <folder>
> dir > file.txt
> exit
>
> There are other ways to get a list of files...
>
> It is up to you to know how to load file.txt into your spreadsheet
> program.
>
> Jim
>

satyanarayan_somani

just open all MP3 in Winamp.
then there is option "generate playlist" in MISC at MISC

Which will transfor all name in HTML file.

then copy the names and paste in Excel sheet


winamp->misc->misc->generate HTML playlist

please reply if help to u

satyanarayan_somani@yahoo.com