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
kwil

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
Boozad

W7 Pro x64 SP1 / W10 Tech Preview x64 VM / Linux Mint
 
 

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
trendy

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
kwil

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
jimbo45

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.

Cheers
jimbo
My System SpecsSystem Spec
29 Jul 2013   #6
kwil

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
Thread Forum
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
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
List Files in Folder With Ignore List
Edit: Sorry I made the topic an forgot to change the title. Should be: "List Files in Folder With Ignore List" or something along those lines. I'm a game server admin. What I want to do is generate a text file which will be used when I launch the server. An example of the text file I want to...
General Discussion
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 06:17.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App