Listing Mp3's

[andy-hughes]

I want to list all the MP3's on my laptop.

I know they won't cut and paste, can someone explain how I can get them onto a Word Doc or an Excel spreadsheet please? Thanks!

[brainiac]

Get Chris round :)

[andy-hughes]

Indeed, I'm hoping he'll be along in a min.
..

[brainiac]

I'm sure he will, particularly jolly from all those unbirthday drinks...

[TheChair]

Use directory lister:
https://www.microsoft.com/en-gb/p/directory-lister/9nblggh6ckjl?activetab=pivot:overviewtab

[JimF]

Your obsession with Chris is, frankly, bizarre! Like he's the only person on AB who knows anything about IT.

TheChair has given a perfectly good answer, but how can this be possible? He's not Chris! Best wait till Chris comes along, does a Google search, and copies and pastes the "real" answer.

[Buenchico]

^^^ Chris has been trying to remember how to use DOS (which pre-dates Windows) to do it!

It's actually very easy:
https://www.pcworld.com/article/2045298/print-all-the-files-or-a-list-of-all-the-files-in-a-folder.html

There are various programs you can use to do the same job too. This one's been around since Fred Fintstone was using a pedal-powered PC but it still works with Windows 10:
https://www.karenware.com/powertools/karens-directory-printer

[brainiac]

Who peed in your cornflakes, Jim?

[Buenchico]

Due to my browser throwing a wobbly (meaning that I got locked out of posting for a while), TC's post wasn't there when I started typing.

I'm happy to agree that Directory Lister should do the job as well as the software I've suggested. (The only reason I didn't mention it myself was that I wasn't sure whether it still works under Windows 10 but, since it's there on Microsoft's own website, I must assume that it does).

I'm not worried about anyone here have an 'obsession' with me. It's those guys squatting outside my house and chanting all night long that really worry me ;-)

[douglas9401]

Given the length of time this project has been in development, I wonder if it might be simpler to write the info out longhand and leave a few spaces for later.

[jno]

you can't get the quill pens, douglas, the geese are all sick.

[Haggisdj]

You could always move them into iTunes, you can do anything that you want then...

[andy-hughes]

Good morning all -

Use directory lister:
https://www.microsoft.com/en-gb/p/directory-lister/9nblggh6ckjl?activetab=pivot:overviewtab

I assume I can cut and paste that into a Word Doc and from there into an Excel sheet?

[andy-hughes]

TheChair - // Use directory lister:
https://www.microsoft.com/en-gb/p/directory-lister/9nblggh6ckjl?activetab=pivot:overviewtab //

Thanks for your answer.

I have downloaded the software, and it has accepted my list - but I'm unsure where I go from there - I want to put it into an Excel sheet - can anyone explain how I do that please?

[JimF]

Copying and pasting straight from the above link:

"You can save listing in CSV format, Excel file "

"Another set of columns you can print is for Microsoft Office files (DOC, DOCX, XLS, XLSX, PPT, PPTX) so "

So:

1) Select the folder(s) and file type(s) you want.

2) Save the data in Excel format.

3) Open in Excel.

[andy-hughes]

Thanks!

The term RTFM applies here I think!

[andy-hughes]

OK, hands up, I am too stupid to own a computer!!!

I have forgotten how to turn my list of MP3's into an Excel spreadsheet.

I have Directory Lister ready, but I am stuck - can anyone assist please?