Preserving or importing playlists into Excel
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.
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.
- Will removing a credit card from Safari also remove it from Apple Pay?
- Can I mute Handoff calls coming into my Mac from my iPhone?
- How do I keep my iPhone calls from ringing on my Mac?
- Why doesn’t Traffic show up on my Today Notifications Screen?
- Why doesn’t my iPhone reconnect to Wi-Fi after I turn it on?
- Why can’t I see the iPad-style landscape view on my iPhone 6 Plus?
- iPad Air 3, iPhone 5se expected to be available March 18
- Apple filming original ‘dark drama’ television series featuring Dr. Dre
- Apple under fire for patent infringement from haptic feedback company Immersion
- CBS CEO Moonves notes Apple talks have stopped
- Apple will source iPhone 7 ‘A10’ CPU solely from TSMC
- Federal bill aims to take regulatory power for phone encryption out of state hands
- Job post shows Apple emphasizing new complications, faces for Apple Watch
- New comments hint at forthcoming streaming TV service from Apple
- Apple Music available on Sonos starting today
- Screen protector installation now available at Apple Stores
- VRS Design Crystal Bumper, High Pro Shield + Verge Active for iPhone 6/6s
- Vicks SmartTemp Wireless Smartphone Thermometer
- Gumdrop Cases DropTech Case for iPad Pro
- Edifier MP700 Rave Portable Bluetooth Speaker
- Just Mobile HoverDock for Apple Watch + HoverDock for iPhone
- VRS Design Dandy Layered Case for iPad Pro
- Just Mobile TENC for iPad Pro
- Native Union DOCK Lightning
- Native Union DOCK for Apple Watch
- Hitcase Pro+ Action Pack and Snap for iPhone 6/6s
- Inside the betas: What’s new in iOS 9.3 and tvOS 9.2 (Updated)
- Life with HomeKit: Our experiences with Apple’s home automation system
- Under the Radar: 10 ‘hidden’ details about the new Apple TV
- Instant Expert: Secrets & Features of iOS 9.0
- Under the Radar: A closer look at smaller iPhone 6s and iPhone 6s Plus changes
- A First Look at iOS 9’s Transit in Apple Maps (Updated for watchOS 2)
- Instant Expert: Secrets & Features of iTunes 12.2
- Instant Expert: Secrets & Features of iOS 8.4 + Apple Music
- CE Week 2015: IK Multimedia, Monowear’s Apple Watch bands + More
- Live From CE Week 2015: Brand New iPad, iPhone + Mac Accessories!