Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

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

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.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .