Export Song List -itunes- to Excel (with BPM)

Question

Export Song List -itunes- to Excel (with BPM)

Hi, trying to export my Itunes library song list to excel. When I do it, it exports most of the info but not the column BPM (Beats per minute). I need this one more than any as a DJ. Why is it not exporting? Any ideas? Everything else looks fine.

Thanks

Matthew

IMAC SE 600 graphite, Mac OS X (10.3.9)

Posted on Sep 3, 2006 12:48 PM

Reply

Answer 1

Sep 4, 2006 1:16 PM in response to Matthew Jackson

Really appreciate any thoughts. Thanks

Reply

Answer 2

MacMuse

Level 7

20,796 points

Sep 5, 2006 12:05 PM in response to Matthew Jackson

I tried a couple experiments and was unable to get BPM dumped to the file, looks like a bug.

Reply

Answer 3

Sep 5, 2006 1:11 PM in response to MacMuse

Thanks fo trying, any ideas on how to fix this or what the problem could be?

Reply

Answer 4

Sep 6, 2006 8:54 AM in response to Matthew Jackson

Hi, any other ideas anyone? Thanks

Reply

Answer 5

MacMuse

Level 7

20,796 points

Sep 6, 2006 9:38 PM in response to Matthew Jackson

OK, let's try the hard way.

iTunes keeps an XML copy of your Library data in Music:iTunes:iTunes Music Library.xml. iTunes only writes to this file as a quasi-backup of the real database at the heart of iTunes - "iTunes Music Library".

The XML file does contain the BPM data. Depending on your familiarity with XML you may be able to easily parse out the data yourself rather than relying on iTunes' Export command.

Reply

Answer 6

Chris CA

Level 10

82,506 points

Sep 6, 2006 10:21 PM in response to Matthew Jackson

(Just found this on another post)

Select the library.
Show all the columns you want (Edit -> View options).
Select all the songs (Ctrl A), then Copy (Ctrl C).
Paste it into Excel.

Reply

Answer 7

Sep 7, 2006 1:15 AM in response to MacMuse

Hi, and thanks. Can I just import this xml list into excel?
Cheers.

Reply

Answer 8

Sep 7, 2006 1:18 AM in response to Chris CA

Hi, this does give me the BPM info, although the headers ( artist, time, BPM, etc.) do not show up like when we export song list under file. I guess i can just add that myself. Many thanks for the insight.

Reply

Answer 9

Sep 7, 2006 1:40 AM in response to MacMuse

Hi again. i tried this but received an error message. When i did get it to open, data was garbled. Thanks again.

Reply