I’m afraid this is a shortcoming of Roon - you can’t export History to Excel, and you can’t search it or use Focus on it either.
In fact, this may be a UI bug, since you only get the Export option when the complete History is selected - selecting a subset of tracks, and the Export option is not available.
Some folks use scrobbling to last.fm as a substitute. See
I’m going to close this Support request (since Support can’t help in this case).
I suggest that you make a post in the Feature Suggestions category to request the “Export to Excel” feature.