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 Win7 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 | W10 Pro IP x64 | W8.1 Pro x64 VM | Linux Mint VM

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

Linux CENTOS 7 / various Windows OS'es and servers

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.

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 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 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...

My System SpecsSystem Spec

 Compiling an MP3 list in MS Excel or other

Thread Tools

Similar help and support threads
Thread Forum
Delete Excel MRU List in Start Menu
Does anyone know how to delete the MRU list for Excel in the start menu? (See screen capture.) I think the list on my machine is corrupted because I cannot delete/unpin anything on it. Reinstalling Office did not help. I'm running Windows 7 Pro and Office 2016.
compiling two clips
I have been putting clips on face book via you-tube. I have hit a snag trying to combine two clips in windows movie maker. the video stops and the music continues. It stops at about 47 seconds. I can play both segments separately but they will not play when combined. the intro clip is 17 seconds...
Music, Pictures & Video
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office
Compiling an Iso
Hi all, I have a question concerning disc iso's which I hope that you could help me with; I have some design and modelling software on two DVD's. One is for the application and one is for all the online documentation. I'd like to do the following: Put the contents of both DVD's onto a...
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 22:40.
Twitter Facebook Google+