![]() To convert your current Sonos que to another platform play list, in Excel go to 'File' and export to a CSV (Comma delimited) file and save the name of the file as the description of your playlistĩ. ![]() Save your new workbook for future use (you can use this to refresh with your current Sonos que at anytime)Ĩ. In the Excel 'Home' Ribbon, click 'Close & Load'ħ. In the Converted to Table step, click on the left/right arrows icon in the 'Column1' header and leave all columns checked, however uncheck the 'Use original column name as prefix' option and Click 'OK'Ħ. Once the Excel Power Query Editor opens, right click on the 'List' column header and select 'To Table' and Click 'Ok' (No options should be selected)ĥ. In Excel, go to the 'Data' click on the 'From Web' option and put in the Sonos API query string Name/queueĤ. Create a new Excel workbook on the same network that both your Raspberry Pi and Sonos are connected toģ. Ensure you have a Raspberry PI running with the Sonos API installed Ģ. ![]() Instructions below for an alternative way before finding this post that I had come up with to extract the playlist from Sonos to move to another service:ġ. App! I was able to then go to and transfer my playlist. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |