Trying to export or get playlist information as Excel/ CSV file

Apologies if this is a stupid question or ask for help.

I've been searching around for a way to export, convert, or otherwise get my playlist information as essentially data for a spreadsheet.

My main goal is to be able to look at all of the videos/ music that are in said playlist as well as their respective locations, etc. via excel and sort them out for my own purposes (part of it is to find duplicate files, as I pretty much have everything across 15 to 20 years in some playlists and as a data hoarder I know that I have backups likely in my playlists, and having a spreadsheet i can format and do other things with, will help me in multiple ways).

I have looked into converters for the xspf playlist file that VLC can make, but the file that comes out winds up not being correct data wise (some of the data is there but rather than having titles, it just has file paths which doesnt help entirely). Ive also tried simply importing it as data into excel but excel doesn't get anything out of it when trying to import. Heck I even tried selecting everything in the VLC playlist window and trying to copy it 😅 (ctrl+c is keybound to a feature in VLC so it didnt work)

One thing I also came across was GitHub - drewkeller/vlc-playlist-creator but in addition to having very little in the way of info and instructions (aside from opening one of the LUA files in notepad) I couldn't figure out how to make it work (if it even did what I wanted it to do in the first place).

----------

I guess I am just seeing if anyone has any insights as to how to get all the info from my VLC playlists into excel in a way that at the very least displays the titles and the locations properly. Whether that be by some export, conversion, or other tricks or tips.

Let me know if there is anything I can clarify, as I had a hard time thinking of the right way to explain things.