2

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?

Renan
  • 8,062
Hugh
  • 21

1 Answers1

2

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.

Raj More
  • 951