Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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