up vote 2 down vote favorite
share [g+] share [fb]

Although iTunes produces a very good comprehensive listing of all music which can be copied and pasted into excel to give a database of music, unfortunately it does not include"where" information as shown on the "Get Info" summary. As, in my own case, music files are in a number of different locations(drives and folders) I would like to be able to identify, quickly and simply,duplicate tracks as the last column in the excel listing. Is there a way to do this?

link|improve this question
As per this question, it doesn't seem to be possible using only iTunes. It might be possible to use PowerTunes (see my reply there) for your problem. – Daniel Beck Dec 26 '10 at 13:47
Daniel thanks for this unfortunately Power Tunes is a Mac only program and I use a pc with windows 7 (problem has now been solved) – Hugh Dec 28 '10 at 11:27
feedback

1 Answer

up vote 2 down vote

Here is how you can see you entire iTunes library in MS Excel

  1. Export the iTunes library as a TEXT file. This will give you the WHERE information as well. Lets say you call this MyMusic.TXT
  2. This file is actually a CSV file, so let's change the file's extension from .TXT to .CSV
  3. Simply open it in EXCEL, and you will be able to use it like a spreadsheet in EXCEL.

Note: If you want to, you can now save this file as an XLS file.

link|improve this answer
OK and how do I read an xml file and transfer the data to an excel sheet – Hugh Dec 27 '10 at 0:20
@Hugh - answer changed. – Raj More Dec 27 '10 at 0:42
Thanks Raj That has fully solved my problem – Hugh Dec 28 '10 at 11:24
@Hugh : If the answer has fully answered the question, then consider marking it as an Accepted Answer by clicking on the outline of a checkmark to the left of the answer. This lets other people know that it has been answered. – Kevin M Dec 29 '10 at 13:15
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.