selecting all albums, then choosing “export to excel” creates an xlsx file of album level metadata. useful as far as it goes, but many of my albums are “various artist” collections. i don’t see an option for exporting at the track level.
Use the Track browser - select the tracks in the albums you want and then Export those tracks to Excel…