I think you can achieve this thru the “subject bibliography” setting on Author. An example of the settings you can set are shown in the attachment where I sorted on term count. You might prefer by author-alphabetical. The output is into a word document (as an rtf), but you should be able to do search and replace to get rid of the parentheses and move it into an excel spread sheet with a minimum of fuss. You might ask that this feature be adapted with more output options. You might be able to generate a reference output style that is more flexible. I didn’t try that.