- 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.
- Copy this file to the desktop and rename it local3.sqlite
- To export the Rhapsody library, install the SQLite Manager add-on for Firefox.
- After Firefox restarts, go to the Tools menu -> SQLite Manager.
- From the menu choose Database -> Connect Database and choose the local3.sqlite file that was copied to you desktop.
- 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"
- 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.
- 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.
- There are some sites that can take this file (or a slightly modified version) to create playlists on other music services like Spotify.
- 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
- UPDATE 4/18/2013 -This SQL statement displays some different columns if you need them (courtesy D. Hudson)
SELECT PLAYLIST_NAME, SEQUENCE, ARTIST_NAME, ALBUM_NAME, TRACK_NAME, TRACK_NUMBER
FROM PLAYLIST, PLAYLIST_TRACK, TRACK
WHERE PLAYLIST.PLAYLIST_ID = PLAYLIST_TRACK.PLAYLIST_ID
AND PLAYLIST_TRACK.TRACK_ID = TRACK.TRACK_ID
UPDATE Feb 2014: @jsfeutz created a python script to import your playlists to Google Music (run at your own risk) https://github.com/jsfeutz/Rhapsody-to-Google-Music