Videos
How to export Spotify playlists to EXCEL CSV?
How to export Spotify tracks list to EXCEL CSV?
How to export Spotify albums list to EXCEL CSV?
Spotify blocks you from copying playlist text via web browser. I couldn't find any methods to get a Spotify playlist into Excel without requiring a download or special tools. I didn't want to use my credentials via Exportify. So I figured out these steps that work for a reasonably short playlist. There's probably room for improvement.
Instructions for Windows and Chrome. Have these already open: Chrome and Notepad and Excel
In Chrome, browse to the playlist page on Spotify. Ensure that the first song on the playlist is visible.
Press F12 to open Developer Tools
Press CTRL+SHIFT+C to select element to inspect
Move mouse around so that the list of songs is highlighted and not much else. I recommend starting with your mouse by the number "1" and moving left. On mine, it highlights "div.contentSpacing"
Click when the "div.contentSpacing" is highlighted. The Developer Tools should then show "Element" tab and a line with "<div class="contentSpacing"> should be highlighted.
Right-click on the highlighted line > Copy > Copy element.
Open Notepad.
CTRL+V (Paste) into Notepad.
CTRL+SHIFT+S (Save As)
Change "Save as type" to "All files (.)"
Enter "File name" as playlist1.html (or another filename ending in .html)
Note the location/directory/folder that you are saving the file into (adjust as preferred). Then press Save.
Go back to Chrome. CTRL+T to open a new tab. Press CTRL+O (Open). Navigate to the file that you just saved. Open it.
Press F12 to open Developer Tools
Click on the "Elements" tab of the developer tools. It should start with "<html>"
Right-click on the "<html>" line > Copy > Copy element
Go to Excel.
In cell A1, CTRL+V (Paste) into Excel. It should paste the words: "#", "Title", "Album", "Date added" into column A, followed by the playlist in column A.
Note the last playlist entry that was successfully copied -- it is probably not the last item in the playlist.
Go back to Chrome's Spotify playlist tab (the original), scroll down so that the last copied entry is visible at the top of the page.
Repeat steps 3-18 to extract the next set of playlist entries and copy into Excel column A below the existing entries. Make sure that the pattern matches the existing entries (there is a Title every 8 rows).
Once you have copied all of the playlist entries into Excel column A you can proceed.
Copy and paste the following table and formulas into cell B1 in Excel. The headers should be in row 1 (B1:D1) and the formulas in row 2 (B2:D2) -- sometimes copying improperly adds a row in between. The resulting row 2 should show the first entry in the playlist!
| Title (col B) | Artist (col C) | Album (col D) |
|---|---|---|
| =INDEX($A:$A,(ROW()-2)*8+8,1) | =INDEX($A:$A,(ROW()-2)*8+9,1) | =INDEX($A:$A,(ROW()-2)*8+10,1) |
24. Copy and paste cells B2:D2 into B3:D3 and the resulting row should show the second entry in the playlist.
25. Copy and paste downwards, until the cells start to show "0" which is the end of the list.