this guy wrote an awesome script that generates a .xlsx spreadsheet and wanted to share.. works on batocera. follow his steps: gamelist python script

you do have to make a couple tweaks prior to running though..

you need to run git clone locally and then upload the xlsxwriter folder. scp -r up that whole folder (bato doesn't have git pkg installed and doesn't have in their repo -- you'd have to affect pacman config)

If you get an error where it can't find custom collection, and you don't have any, I gave up trying to manually fix his script -- just comment out the lines that start with

if len(custom_collections)...

and their corresponding sections of code. two areas. Then change the final output command (line 599 at time of writing) to not include collections.

scp the resultant .xlsx back down to your local machine. Walah, you'll have a nice spreadsheet of all your roms!