Article
Preserving or importing playlists into Excel
By Jerrod H.
Contributing Editor
Published: Thursday, August 18, 2005
Articles Categories: Ask iLounge, iTunes
Ask iLounge offers readers the opportunity to get answers to their iPod-, iPhone-, iPad-, iTunes-, or Apple TV-related questions from a member of the iLounge editorial team. We'll answer several questions here each week, and of course, you can always get help with more immediate concerns from the iLounge Discussion Forums. Submit your questions for consideration using our Ask iLounge Submit Form. We reserve the right to edit questions for grammar, spelling, and length.
Q: I like to keep everything backed up on an external hard drive, but I haven’t seen a way to do this for playlists. I want to keep the playlists themselves (some are of sentimental value, e.g. from our wedding) but don’t want the actual tunes - they can stay in the library. Does iTunes store playlists in a file format anywhere on the hard disk, so I can back them up?
Alternatively, is there a simple way to export a playlist, for example to an Excel spreadsheet or database format? This may also help greatly in clearing up the clutter in my iTunes “Source” column, which is currently full of old playlists that I want to keep for future reference.
- Paul
A: There are several ways to do what you want. Take your pick:
- As long as you’re backing up the iTunes Music Library files (in the “iTunes” folder you have selected), you’re backing up all playlists as well. Keep this intact, and you can restore this file along with your music in the event of library loss. Check out our Complete Guide to Backing up iPod & iTunes Music
- To export a simple tab-separated text file of a playlist containing all the metadata you could ever want (track name, artist, album, filename, rating, playcount, etc.), simply right click (PC) or control-click (Mac) on the playlist name and select “Export Song List…”. This will write the file to the location of your choosing. Because this is a tab-separated file, you can easily import it into Excel.
- Want to go straight to Excel without the intermediate file? Simply open a playlist in iTunes, select Edit—> Select All from the menu, and select Edit—> Copy. Then open Excel and “Paste” your data in. This is often more convenient, as you’ll only be copying the columns shown in iTunes, which are likely the ones you’d like to archive.
Enjoy!
|
The most asked question at iLounge.com:
|
Converting DVDs, web video, TV shows and more:
The Complete Guide to iPod, Apple TV and iPhone Video Formats |
Converting DVDs, web video, TV shows and more:
The Complete Guide to iPod, iPhone and Apple TV Video Conversion (Mac) |
Converting DVDs, web video, TV shows and more:
The Complete Guide to iPod, iPhone and Apple TV Video Conversion (Win) |
|
|
|
|
|
Find more answers in the latest publications in our Library. Free downloads developed by the editors of iLounge!
Ask iLounge Archives:
5-17-13: Calendar info disappears after iCloud restore
5-16-13: Remove old iCloud backup after restoring to a new iPhone
5-15-13: Setting up a ringtone in iTunes
5-14-13: Using a Wi-Fi hard drive with an iPad
5-13-13: Backing up and restoring an iPod classic
Related Stories
- Calendar info disappears after iCloud restore
- Remove old iCloud backup after restoring to a new iPhone
- Setting up a ringtone in iTunes
- Using a Wi-Fi hard drive with an iPad
- Backing up and restoring an iPod classic
- Can’t restore iPod touch without passcode
Comments
If you have a comment, news tip, advertising inquiry, or coverage request, a question about iPods/iPhones/iPad or accessories, or if you sell or market iPod/iPhone/iPad products or services, read iLounge's Comments + Questions policies before posting, and fully identify yourself if you do. We will delete comments containing advertising, astroturfing, trolling, personal attacks, offensive language, or other objectionable content, then ban and/or publicly identify violators.
Recent News
- AT&T: All video chat apps will work over cellular in 2013
- Apple releases testimony before CEO’s Senate appearance
- New Apple offers in India can reduce iPhone price
- Report: Apple testing 1.5” OLED displays for iWatch
- Song skipping terms slowing iRadio negotiations
- iLounge Weekly arriving Monday, giveaway reminder
- Report: BBM iOS app won’t support iPad at launch
- Report: iRadio might miss WWDC debut
- Fair Labor Assoc.: Foxconn, Apple still exceed work hours
- CW to bring content to Apple TV
Recent Reviews
- Trü Protection Trü-Fit Anti-Glare Film Set
- New Trent iCarrier IMP120D Dual USB Power Pack
- BlueFlame 2M Charge and Sync Cable with Lightning Connector
- HMDX Jam Party Bluetooth Wireless Stereo Speaker
- Logitech Harmony Ultimate Universal Remote Control
- MyCharge Freedom 2000 Battery Case for iPhone 5
- Nike Nike+ FuelBand
- OCDesk OCDock for iPhone 5
- Bluelounge MiniDock (With Lightning Connector)
- Mophie Juice Pack Powerstation Pro
Recent Articles
- Calendar info disappears after iCloud restore
- Remove old iCloud backup after restoring to a new iPhone
- Setting up a ringtone in iTunes
- Using a Wi-Fi hard drive with an iPad
- Backing up and restoring an iPod classic
- Can’t restore iPod touch without passcode
- Retaining older versions of Apps during an iOS Restore
- Can’t eject iPod nano without closing Firefox
- Can’t change iTunes Apple ID to iCloud e-mail address
- Effect of erasing an iPhone on the Find My iPhone feature