Importing&linking music files to an excel sheet

[erikice]

Allright, so after a lot of googling and not being able to find out quite how i should do this i have come here.. hopefully someone knows how to solve my problem (and from the looks of these fora you most certainly are able to do just that)

I am just a humble med student so i know about nothing of excel, apart from some basic functions to import my calendar to outlook.

This is what i want to achieve:
I have a map of mp3 files which i want listed in a spreadsheet.
it should look like the following:

Artist | songtitle | album | length of track | hyperlink to file

the musicfiles will all be in a map called MP3 (or something like that) and the excel file will be in the same directory as said MP3 map.

I know all the songproperties are available in the metataginfo of the files or available in text by simply making a playlist in itunes and exporting it as text.

The trick should be to import the properties of the song(artist, title) and place a correct hyperlink in the same row...

How solve this? i hope you have some answers for me!

[martindwilson]

start by getting your track list into excel you may need to separate it out a bit to get distinct elements in seperate cells
you can link like this
=HYPERLINK("c:\documents and settings\My Documents\My Music\"&D1&".mp3")
where d1 contains track title and every thing is an mp3
or
=HYPERLINK("c:\documents and settings\My Documents\My Music\1812.mp3")
link direct to file