Exporting your Rhapsody library to CSV

This is a tutorial on how to export the songs in your Rhapsody library to a CSV format for backup purposes or to possibly import to another music service.  This article assumes you are using the PC-based version of Rhapsody and not the web-based version.  You also need Firefox installed.

1. Rhapsody uses a SQLite file to store the library info. Now it is time to look for a file called local3.seb. On Windows XP, it goes under the C:\Documents and Settings\USERNAME\Application Data\Real\rhapsody\1.sqlite folder. Of course, replace USERNAME with your Windows logon username.
2. Copy this file to the desktop and rename it local3.sqlite
3. To export the Rhapsody library, install the SQLite Manager add-on for Firefox.
4. After Firefox restarts, go to the Tools menu -> SQLite Manager.
   
5. From the menu choose Database -> Connect Database and choose the local3.sqlite file that was copied to you desktop.
   
6. Click on the "Execute SQL" tab on the right side of the screen. Type in the text "SELECT ARTIST_NAME, ALBUM_NAME, TRACK_NAME FROM TRACK ORDER BY ARTIST_NAME, ALBUM_NAME, TRACK_NAME" and select "Run SQL"
7. To export this data as a CSV file, click on Actions -> Save Result (CSV) to File. The file will be called output.csv by default.
   
8. This csv file can be opened in Excel to add/remove new songs.  There can be problems exporting songs with characters not in the English alphabet.  These have to be fixed manually.
9. There are some sites that can take this file (or a slightly modified version) to create playlists on other music services like Spotify.
10. UPDATE 8/15/2011 - You can export your playlists by using the sql "SELECT PLAYLIST.PLAYLIST_NAME, TRACK.ARTIST_NAME, TRACK.ALBUM_NAME, TRACK.TRACK_NAME FROM TRACK, PLAYLIST, PLAYLIST_TRACK WHERE (PLAYLIST.PLAYLIST_ID = PLAYLIST_TRACK.PLAYLIST_ID AND PLAYLIST_TRACK.TRACK_ID = TRACK.TRACK_ID) ORDER BY PLAYLIST.PLAYLIST_NAME, PLAYLIST_TRACK.SEQUENCE"