Hi, I would like to export playlist info to Excel:
Thanks for your help!
Windows, Windows 10
tt2
ExportCSV should export data for the current selection of tracks, or the current playlist if no tracks are selected. I'm limited to the amount of interaction I build into the scripts so any options generally involve making a little tweak in a text editor. The current version has a line that starts:
IncLists=False
So that would need changing to
IncLists=True
to change the behavior.
tt2
Perhaps you missed the post where I said you should make a minor edit to the script:
ExportCSV should export data for the current selection of tracks, or the current playlist if no tracks are selected. I'm limited to the amount of interaction I build into the scripts so any options generally involve making a little tweak in a text editor. The current version has a line that starts:
IncLists=False
So that would need changing to
IncLists=True
to change the behavior.
tt2
The PlaylistsToFile script is an exception to the rule. Just run it and it will will do the job.
You can follow the usual instructions for the other script. Test on an small sample first so you see how it behaves and if the output works for you. You can tweak the script to leave out data that you don't need in the export. The are plenty of comments to guide you if you want to do that.
tt2
Yes, you just double-click the first script to run it. iTunes will launch if it isn't already running. The output looks a bit like this:
iTunes playlists - 01/08/2012 09:49:47
Music
Movies
TV Shows
Podcasts
iTunes U
Books
Purchased
Purchased on Steve’s iPad
Purchased on Steve’s iPhone
Genius
iTunes DJ
Audiobooks
Agatha Christie
The Mysterious Affair At Styles
Anthologies
World Book Day 2003
Arthur Conan Doyle
1: A Study In Scarlet
2: The Sign Of Four
3: The Adventures Of Sherlock Homes
4: The Memoirs Of Sherlock Homes
5: The Return Of Sherlock Homes
6: The Hound Of The Baskervilles
7: The Valley Of Fear
8: His Last Bow
9: The Case-Book Of Sherlock Holmes
.
.
.
Test
There are 294 playlists in 39 folders.
Copied from a somewhat older post!
tt2
Well that is somewhat embarrassing. Some old code there from the days when the XML file was always present, but now it may no longer be so it can cause a problem. Originally the script would place the output in the iTunes folder, but I've fixed the bug in a new build that now places the output file in the same place as the script. Please download a fresh copy of PlaylistsToFile and try it out.
I'd forgotten that I'd added track counts and lead lines at someone else's request so the current output looks like this:
I've made the lead lines and counts optional, but there is probably some vertical padding around folders and indentation that you don't want if this is going to end up in Excel so I could add some more options to turn those off. I could also make a PlaylistsToCSV alternative that creates a two column sheet with the playlist names and track counts.
tt2
Outta sight! It works perfect! Added bonus you included the number of songs in each list, very cool! It's easy to extract the count into a separate column.
I'm so stoked on your kindness to do all those scripts! I'll have to cruise them to see which others would be fun.
Thanks, and stay safe!
Thanks! I've never used a VB script before, I'll give it a try.
Your directions say:
-not to include iCloud downloaded songs, however, since this is just for the names of the playlists, should I disregard that instruction?
-"Select a playlist ... in iTunes and then double-click on the script to execute it." If the script was saved-as to a folder on my laptop, how do I access it while in iTunes? Also, how do you select all or multiple playlists in iTunes - it only lets me highlight one-at-a-time.
Thanks!
Um, I did some research on how to run a vb script and understand I just find it in windows explorer and double-click... will it then somehow see the list of all my iTunes playlists and give me an option to just select the few playlists that I want to run a test on? I suppose iTunes should be open...?
No problem, the output will just be a long list. I thought I was bad at 300! 🙂
You've got the nicely organized bit at the top in my example but there are a bunch of lists created to test this or that aspect of iTunes that I routinely fail to clear up once I'm no longer interested in them.
tt2
Gotta stay on top of that cleanup! So, I opened the vb file, it launched iTunes by itself. Then this error message popped up:
Also, will the resulting text file open once it's created? Where will it be located?
When you say you've made the lead lines optional, do you mean I can opt not to have them? I wasn't presented with any screens to makes choices. Just thinking of the next time I'll be running it, no biggy.
I ran the ExportCSV for the feature of "A new addition exports a field that lists each of the playlists a track is in":
-It only output 25 songs, no duplicates. (The 25 songs it somehow selected presents an interesting perspective of my song tastes!)
-I don't see data reflecting the names of the different playlists a track is a member of
So, I opened iTunes and selected all my songs. Then I double-clicked the vbs file. At the Warning box, I confirmed I wanted to process 3,510 records.
However, the resulting csv file has only 388 records, and I don't see any dupes or a column referencing the name(s) of any playlists.
What should the output look like, one line per song per playlist, in which case over 10,000 records?
There should be a column called Playlists. You may need to double-tap the row dividers or column dividers to expand to show contents. Here are some details for a couple of tracks in my library after adding a window split so I can show the first few columns alongside column Z:
tt2
How To Export Playlist Data (not nusic files) to Excel including names of Playlists