How to Export Spotify Playlist to Excel and Import Back

Grace's user avatar
Grace
December 25, 2023

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.

Using Exportify to export Spotify playlists to Excel

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.

get started

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.

authorize exportify

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.

export single playlist

Step 4. If you wish to download all your playlists to Excel, click the Export All button.

export all

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.

settings

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.

How to import CSV files as Spotify playlists

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.

Method 1. Copy-and-paste track URIs to the playlist

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.

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.

copy uri

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.

paste uri to playlist

Step 4. The tracks with the pasted URIs now appear in the new playlist. The playlist has been successfully re-imported to Spotify.

playlist created

Method 2. Use a playlist transfer tool

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“.

tunemymusic

Step 2. Choose “Upload file” as the source that you want to transfer playlists from.

select the source

Step 3. Choose a CSV file created by Exportify on your device, or directly drag the file to the box.

upload file

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.

playlist settings

Step 5. TuneMyMusic will show the songs in your playlist. Click Choose Destination and select Spotify.

choose destination

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.

start transfer

How to export Spotify songs to MP3 files?

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:

  • Download Spotify songs, albums, playlists, and podcasts with either Spotify’s free or premium account.
  • Built-in Spotify web player, no Spotify app needed.
  • Download Spotify to MP3 in 320kbps.
  • Multiple output formats: MP3, M4A, AAC, FLAC, WAV, and AIFF.
  • Keep all ID3 tags.
  • Rename Spotify songs with titles, albums, artists, etc.
  • Archive downloaded songs by album or artist.
  • Multilingual interface.

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.

1. Run Pazu Spotify Converter

Download, install, and run Pazu Spotify Converter on your Mac or Windows. Log in to your Spotify account with the built-in web player.

spotify converter

2. Choose the output format

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.

spotify song format

3. Select Spotify music

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.

select songs

4. Download and Convert Spotify Songs to Local

Click the Convert button to start downloading the Spotify songs to your local computer.

download spotify songs

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.