Excel Data Query to Plex Library Content XML Files

Server Version#:1.17.0 1841

I’m attempting to have some logging for my Plex library within an Excel file. Ideally, I’d like to build a data connection to whichever appropriate XML files that Plex generates.

In a perfect scenario, I’d be able to capture the data that we are able to see from the “Get Info” screen.

I have been fiddling around with the Plex Media Scanner console commands, however, that appears to be limited and more for a one-off generation of the data. It’s obvious this data is stored somewhere, I am an admin on the local computer where the server is installed so there are no limitations from that perspective.

Also, I know there is the “View XML” option when you are on the “Get Info” screen, so is there a folder structure where this is all stored? Even if it is broken into numerous XML files that would be OK.

Any suggestions?

P.s. I intend on using Microsoft Excel’s Get & Transform Data (aka Power Query) so I can dynamically compile one large XML file in the spreadsheet from numerous files and folders that part is easy, it’s just finding the data…

Maybe ExportTools. that will generate an xlsx file for you?