MP3 Listing Software for Win7?

[FONT=&quot]Hi...[/FONT]
[FONT=&quot]I'm a newbie on Win7 64-bit.[/FONT]
[FONT=&quot]I've a number of DVD/CD's containing many MP3 tracks.[/FONT]
[FONT=&quot]I want to create a list of MP3's within Excel(I have Office 2007) but can't seem to export the info I need from the DVD/CD's to create a list I can add to at will.[/FONT]
[FONT=&quot]The list only needs to hold the following info:
[/FONT]
[FONT=&quot]Artist - Track Name/Time[/FONT]
[FONT=&quot]Source - DVD 1/2/3/etc[/FONT]
[FONT=&quot]Can anyone suggest any software (preferably free) that can read/export to XL with ease?
[/FONT]
[FONT=&quot]I've used 'MP3Listmaker de Luhe' with XP for a good while, but the version I have won't run on Win7. It does a basic job and there's a paid-for version but frankly with such an amateurish interface it's not worth paying for.[/FONT]
[FONT=&quot]I've also tried 'Karen' software - not doing what I need.[/FONT]
[FONT=&quot]So, any suggestions or recommendations would be welcome.[/FONT]
[FONT=&quot]Many thanks[/FONT]

What are you using to listen to your mp3s? Reason I ask is, you could probably export the meta-data from your listening software and transfer it to excel. If not directly, at least via copy/pasting of text.

AxiomX MasterLister

or this is a good one but you have to pay for it but it's worth every nickel:

Advanced File Organizer: disk catalog software, organizer for disks of all types

You can do it with command prompt:

Run > cmd

For example, if your DVD drive is E:, type: dir E:\*.mp3 /b >list.txt
Press Enter.

The file "list.txt" file (you can name it whatever you like) will appear in the directory cmd started from.
Then copy and paste the list into an excel document.

You might want to create the "list.txt" file in a more convenient place. To do that, before you type the "dir..." line, change directories in cmd: For example, to change to the F: drive type F: then press Enter, then type cd F:\Media and press Enter to change to the "Media" directory.

In case anyone wants to make a list from a directory that doesn't have such an easy address to type, Windows 7 has given cmd a drag & drop ability, so after you type dir, you can just drag the folder whose contents you want to list to cmd and the address will be filled in for you - nice!

Hi...many thanks to all for taking time to reply.
Just one question, Seth: Axiom webpage doesn't show compatibility for Win7 64-bit...So, is it compatible and can you link up easily with XL?
Would rather find out before I install...
Debugged: that's a useful way of doing it...thanks! (I'll keep it up my sleeve!)
Regards

Hi kwil it is compatible it installed on my system 64bit no problem but it creates a text file of the contents of your directories. Also I know the second link is a pay for link but I'm sure when I used to use it it has excel export already built into that and also html.

kwil said:

[FONT=&quot]Hi...[/FONT]
[FONT=&quot]I'm a newbie on Win7 64-bit.[/FONT]
[FONT=&quot]I've a number of DVD/CD's containing many MP3 tracks.[/FONT]
[FONT=&quot]I want to create a list of MP3's within Excel(I have Office 2007) but can't seem to export the info I need from the DVD/CD's to create a list I can add to at will.[/FONT]
[FONT=&quot]The list only needs to hold the following info:
[/FONT]
[FONT=&quot]Artist - Track Name/Time[/FONT]
[FONT=&quot]Source - DVD 1/2/3/etc[/FONT]
[FONT=&quot]Can anyone suggest any software (preferably free) that can read/export to XL with ease?
[/FONT]
[FONT=&quot]I've used 'MP3Listmaker de Luhe' with XP for a good while, but the version I have won't run on Win7. It does a basic job and there's a paid-for version but frankly with such an amateurish interface it's not worth paying for.[/FONT]
[FONT=&quot]I've also tried 'Karen' software - not doing what I need.[/FONT]
[FONT=&quot]So, any suggestions or recommendations would be welcome.[/FONT]
[FONT=&quot]Many thanks[/FONT]

Click to expand...

I can do Excel reports of my library with Mediamonkey. I have the paid version, but I believe the free version will do it as well....MediaMonkey » Information » Free

kwil said:

[FONT=&quot]Hi...[/FONT]
[FONT=&quot]I'm a newbie on Win7 64-bit.[/FONT]
[FONT=&quot]I've a number of DVD/CD's containing many MP3 tracks.[/FONT]
[FONT=&quot]I want to create a list of MP3's within Excel(I have Office 2007) but can't seem to export the info I need from the DVD/CD's to create a list I can add to at will.[/FONT]
[FONT=&quot]The list only needs to hold the following info:
[/FONT]
[FONT=&quot]Artist - Track Name/Time[/FONT]
[FONT=&quot]Source - DVD 1/2/3/etc[/FONT]
[FONT=&quot]Can anyone suggest any software (preferably free) that can read/export to XL with ease?[/FONT]

Click to expand...

[FONT=&quot]I believe you can do what you want using Exact Audio Copy (EAC), which is free.

I just tested it out on a CD, which is Janis Joplin's "18 Essential Songs" which I inserted into my CD tray with EAC running. EAC then went up to FreeDB to get the information (I selected the proper one from the two "hits" that were offered to me), and EAC then [/FONT]populated its tracklist presentation, which looks like the following:



Then from the EAC menu bar, I did Database -> Export CD information to -> DB text file. This appears to be a character-delimited (with ";") TXT file, suitable for import into Excel.



I think this is the exact information you're looking for, to build your spreadsheet "list" for your collection, assuming that's how you want to go.

If you're unfamiliar with EAC, you can use this excellent tutorial/guide to installation and optimization. I myself have somewhat different tweaks, but for a newcomer this is a fine getting-started "how to" explanation.



If I might recommend a more sophisticated way to develop a CD Database for your music collection, you might look at a non-free ($39.99) program named "Musifind Pro Internet Edition" (which is what I've been using for over 12 years, to keep track of my 1100 CD collection). There is no spreadsheet involved, as the program IS itself a CD-database music collection product. All kinds of powerful capabilities (also including automatic access to FreeDB when you want to add a CD to your collection). Supports album art, linkage to default music player for playing tracks you've pointed to MP3/FLAC, export database to CSV with customizable/arrangeable columns, etc.

If you're interested I can give you more details on setup, use, tips and techniques.

For example, that same Janis Joplin CD in my Musifind Pro database looks as follows (showing just the "albums" view, for an example):



And when I open that CD and go to the "songs" tab to see the tracks, it looks as follows:

Just noticed that you'd stated:This must mean you have a set of "homemade" mix CDs/DVDs, rather than a collection of commercial retail CDs. So you're probably NOT going to be able to use FreeDB automatically invoked from any program product to find track information for your discs, since your discs are your own invention. FreeDB is worthless here.

However if I understand you correctly, you may have the track information already imbedded in the file names themselves, from the directory of your discs.

I haven't tried it myself, but I suspect EAC may be able to import THAT track information directly from the CD filenames, instead of using FreeDB. I've never done that myself, but it's a pretty sophisticated program. It might be "edit extended track information", but I'm not sure since I've never done it.

You can certainly experiment with it yourself, reading one of your homemade MP3 mix-CDs, and see if you can get exactly or close to what you want populated into the EAC tracklist presentation. That's the goal, because if you can get the tracklist presentation to look correct then you can export it to DB Txt format and you're home free.

If you can get the tracklist display to look right, you can do the export to DB text format as I described earlier, and produce that same character-delimited TXT file suitable for import into Excel... except starting from the filename directory on your discs, instead of getting the track names from FreeDB as would be possible with commercial CDs.

On the other hand, EAC may only usable for CDs with WAV tracks, not with MP3 tracks. Again, never tried it before for this kind of task.

Still just kind of thinking out loud here... but my posts may actually not be of much help to you after all. But it's worth a try for you to just install EAC and see if it can read your MP3 discs and populate the track list directly from the disc directory and filenames itself.