Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Compiling an MP3 list in MS Excel or other


19 Jul 2013   #1

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 
Compiling an MP3 list in MS Excel or other

Hi there...

I'm running Windows 7 Home Premium (64-bit) and MS Office 2007.

I have a number of DVD's containing around 400 MP3 tracks each.

What I'd like to do is create one simple list so I can find which DVD holds a particular artist & track without having to trawl through each DVD!

All I'd have to do is open the document and search alphabetically...not much to ask, huh?

I figured I could do this via an Excel spreadsheet but can't see how that could be achieved.

All I want is a quick reference list for easy access...

Can anyone suggest a solution via Excel or some other wonderful, simple and preferably free program?

Many thanks

My System SpecsSystem Spec
.

20 Jul 2013   #2

W7 Pro x64 SP1 / W8.1 Pro x64
 
 

It's be easy enough in Excel. Just have a page for each disc, enter track number in one column and title in another, artist in another etc. Then add filters to the header row and you can filter any column you like to appear in whatever order you like. You can even filter down to songs by certain artists, albums etc.
My System SpecsSystem Spec
20 Jul 2013   #3

Summary Operating System Windows 7 Home Premium 64-bit SP1 CPU AMD Athlon II X2 250 23 °C
 
 

Hi This is your question from another forum.
Have a read here,It's excellent

Directory List & Print
My System SpecsSystem Spec
.


20 Jul 2013   #4

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Hi...many thanks to you both for taking time to reply...
Boozad: you don't mention how, after inserting a DVD, Excel recognises its contents. Or am I missing something?
Trendy: The Directory List/Print looks interesting and clearly would fit the bill...
My System SpecsSystem Spec
26 Jul 2013   #5

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Hi there

With MP3 tracks -- OK you need to set it up ONCE first -- but why not use a program (Free) like mp3tag

Mp3tag - Download

(Click on English to get the English version of the site)

Then you can export fields etc to your EXCEL --- Job done.

OK you need a one time shot to build the Database or collect the data but I think you'll find this worthwhile as it's very flexible and easy to update.

Cheers
jimbo
My System SpecsSystem Spec
29 Jul 2013   #6

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Hi jimbo...thanks for the link etc
I've used 'MP3Tag' for a couple of years now and it's a very useful program.
However, getting things over to Excel is not quite as easy as you make out.
There's plenty of stuff online to indicate that...as I've found out myself after giving it another shot.
Directory List & Print I've found has limitations sadly.
'Media Monkey' (not free) does it superbly with no fuss...as does MP3 Tag Clinic (some versions now free)...which is how I've managed to sidestep MP3Tag and solve the problem!!
Thanks again for the input though...hopefully this'll help anyone else in the same position...

Regards
My System SpecsSystem Spec
Reply

 Compiling an MP3 list in MS Excel or other




Thread Tools



Similar help and support threads for2: Compiling an MP3 list in MS Excel or other
Thread Forum
Solved compiling two clips Music, Pictures & Video
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel help Microsoft Office
List Files in Folder With Ignore List General Discussion
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office
Compiling an Iso General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 05:30 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33