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?

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

| 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
  • @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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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