Microsoft Groove RIP – Export your Playlist

OK… I’m using Groove. Don’t know why I paid the annual subscription, perhaps I had grand plans to sync up my music lists to a single platform and decided to give it a chance. Oh well… Microsoft just killed it.

Anyways, I’ve been collecting some songs over the past couple of years, and before I forget what they are, I thought I would export the list, only to find out that Groove only supports exporting to Spotify, well I don’t know what music service I’m planning on moving to, but it *might* not be Spotify, so I need to figure out how to export my list now.

I tried getting an Groove Music API, key, but Microsoft shutdown the service, I also tried another online service, but they wanted to charge a monthly fee. I did figure out that I can download my playlist locally to my machine. The files will be DRM protected, but I can use the file names to generate a playlist. How? Powershell to the rescue!

IF you would like to create a list, open up a powershell.exe command prompt and run the following command (Single line):

iwr https://gist.githubusercontent.com/keithga/8c3631beb2064cc33844505d97a76eb7/raw/e8f138929fdc54a9edf4b6ab58c0962f3c0d5a96/Export-GroovePlaylist.ps1 | % Content | IEX | export-csv -NoTypeInformation -path $env:USERPROFILE\desktop\myGrooveList.csv

This command will download the powershell script from GitHub, execute, and export to a file called MyGrooveList.csv on your desktop. ( or replace desktop with downloads, whatever).

Then you can open the MyGrooveList.csv file in Excel and import later.

Here is the full script:

	<#
	.SYNOPSIS
	Export Groove Playlist
	.DESCRIPTION
	Export Groove Music playlist (tested on Groove Music version 9/25/2017)
	Steps:
	* Open Groove Music
	* Click on "My Music"
	* Select all tracks ( Ctrl-A )
	* Click on "Download"
	This should download encrypted (protected) music files locally.
	You won't be able to downlaod these tracks, but you can now get a manifest of the tracks with this script.
	.PARAMETER Name
	Specifies the file name.
	.PARAMETER Extension
	Specifies the extension. "Txt" is the default.
	.EXAMPLE
	C:\PS> .\Export-GroovePlaylist.ps1
	Will export your groove playlist to a formatted text file
	.EXAMPLE
	C:\PS> .\Export-GroovePlaylist.ps1 | export-csv -NoTypeInformation -Path $env:USERPROFILE\Desktop\myGrooveList.csv
	Will export your groove playlist to a CSV (comma Seperated Value) file that can be opened in excel
	.link
	https://wordpress.com/post/keithga.wordpress.com/1456
	#>
	[cmdletbinding()]
	param()
	$path = "$env:userprofile\Music\Music Cache\Subscription Cache"
	get-childitem –recurse $path –file |
	foreach-object {
	$Song = $_.FullName.replace("$path\",'').replace('.wma','') -split '\\'
	if ( $Song[2] -match '^[0-9][0-9] ' ) {
	[pscustomobject] @{ Artist = $Song[0]; Album = $Song[1]; Track = $song[2].Substring(0,2) -as [int]; Song = $Song[2].Substring(3) } | Write-Output
	}
	else {
	[pscustomobject] @{ Artist = $Song[0]; Album = $Song[1]; Song = $Song[2] } | Write-Output
	}
	}

view raw

Export-GroovePlaylist.ps1

hosted with ❤ by GitHub