Spotify is a widely used music streaming service that offers a diverse collection of playlists curated by both users and the platform itself. Additionally, Spotify allows you to create collaborative playlists with your friends. If you wish to perform some data analysis or safeguard your playlists by creating a backup, you might consider exporting your Spotify playlists to Excel files.
Although Spotify doesn’t provide a direct feature for playlist export, there are third-party tools available to assist you in this task. In the following guide, we will show you how to efficiently export your Spotify playlists to Excel CSV files with Exportify and how to re-import them back into Spotify, all with just a few simple steps.
Exportify is an open-source application on GitHub that can export your Spotify playlists to CSV format. This online tool offers a user-friendly interface and employs the Spotify official API to carry out the task. Below, we provide a step-by-step guide on how to transfer your Spotify playlists into Excel CSV files with Exportify.
Step 1. Visit the Exportify website on your browser and click the Get Started button.
Exportify website: https://watsonbox.github.io/exportify/
Step 2. Log in to your Spotify account. By clicking on the AGREE button, you grant Exportify permission to access your Spotify account data and activities.
Step 3. Once connected to your Spotify account, Exportify will present all your playlists, including collaborative ones, from your Library. Select the desired playlist and click the Export button to download it in Excel CSV format.
Step 4. If you wish to download all your playlists to Excel, click the Export All button.
You can adjust the Excel file content of your playlists using the Settings button (gear icon). To log out from Exportify, click the Log Out button (exit icon) in the top-right corner.
After the download is complete, you can open the CVS files of your playlists with Excel. These files provide detailed information about each track within the playlist, including the Track URI, Track Name, Artist Name, Album Name, Album Release Date, and more.
You can also import CSV files to Spotify as playlists. Spotify supports copy-and-paste track URI in the playlists, and there are three-party tools that can help you transfer CSV files to playlists on Spotify.
Once your playlists are saved as CSV files using Exportify, it is straightforward to re-import them into Spotify. Just follow the steps below. Keep in mind that this method only works on the Spotify desktop app.
Step 1. Launch your Spotify desktop app on your Mac or Windows computer. Navigate to Your Library, and tap the + button to create a new playlist.
Step 2. Open the CVS file in Excel of the playlist you want to re-import. Select and copy the spotify:track:xxx URIs.
Step 3. Go to Spotify and paste the URIs into the new playlist you created. Remember to use the keyboard shortcut Ctrl+V on your PC, or Command+V on your Mac.
Step 4. The tracks with the pasted URIs now appear in the new playlist. The playlist has been successfully re-imported to Spotify.
A playlist transfer tool can help you convert playlists or music libraries from one music streaming platform to another. Usually, they also support transferring your uploaded CSV and TXT files into playlists on various platforms. TuneMyMusic is an online tool that offers such functionality, and its free version allows you to transfer up to 500 tracks. Here is a guide on how to import CSV files as Spotify playlists using TuneMyMusic:
Step 1. Visit TuneMyMusic.com and click “Let’s start“.
Step 2. Choose “Upload file” as the source that you want to transfer playlists from.
Step 3. Choose a CSV file created by Exportify on your device, or directly drag the file to the box.
Step 4. Set the song name and artist name as the corresponding column title in the CSV file, and select “Put all songs in one big playlist” for “Separate playlists by”. Then click Continue.
Step 5. TuneMyMusic will show the songs in your playlist. Click Choose Destination and select Spotify.
Step 6. Click the pencil icon to edit the playlist name. Then click Start Transfer and wait for TuneMyMusic to transfer the songs into a Spotify playlist. After done, you can find the playlist in your Spotify Library.
In addition to exporting Spotify playlists to Excel, you can also safeguard your music by downloading Spotify songs as MP3 files. Spotify Premium subscribers can download the entire playlist for offline listening. However, downloaded content is accessible only through the Spotify app, reinstalling the app or canceling your subscription may lead to losing these downloads.
To ensure your Spotify downloads are permanent, consider using a smart Spotify music downloader — Pazu Spotify Converter. This software caters to both Spotify Free and Premium users, allowing you to download various types of Spotify songs, playlists, and albums for offline enjoyment. Pazu Spotify Converter can extract Spotify music and convert it into multiple formats, including MP3, M4A, AIFF, WAV, FLAC, and AAC. With this converter, you can preserve your favorite Spotify tracks and transfer them to any MP3-compatible device for uninterrupted listening.
Key features of Pazu Spotify Converter:
Now, let’s learn how to use Pazu Spotify Music Converter to download and convert Spotify songs with a free subscription from the following tutorial.
Download, install, and run Pazu Spotify Converter on your Mac or Windows. Log in to your Spotify account with the built-in web player.
Click the gear icon on the top right corner. Here you can select the output format (AUTO(M4A)/MP3/AAC/FLAC/WAV/AIFF), choose output audio quality, customize the output path, organize the output files in various ways, rename output files, and more.
Use the integrated Spotify web player to search the songs, albums, playlists,s or podcasts you want to download. Click the Add to List button to load all songs in the album or playlist, and uncheck the songs you don’t want to download if there are any.
Click the Convert button to start downloading the Spotify songs to your local computer.
Once the conversion is done, you can find your Spotify songs downloaded as local files by clicking the below folder button or directly going to the output folder you customized in the previous step.
Note: The free trial version of Pazu Spotify Converter enables you to convert the first three minutes of each song. You can remove the trial limitation by purchasing the full version.
Download and convert any Spotify songs, albums, playlists to MP3/M4A etc.