I have a large iTunes library with about 3,000 audiobooks. The folder format is
Audiobooks > Author > Titles
Many of the Authors I have multiple tiles for
In short What I am hoping to do is create a Excel or CSV spreadsheet that has
I am sure there is a a simple way to do this but I can’t seem to put my finger on how to do it.
I did not find a simple way to do what you want. The reddit link below will tell you how to find your audio files and what the tag information looks like. It mentions a command line tool that looks like it could be used to extract the info that you want. But there would be more scripting involved than I would be willing to do at this point. I hope someone has done the hard work and made an app for you. 
This looks like a nice way to do what you want. Once you load up your tags, it can export to a CSV file which your spreadsheet can read.
Mp3tag - the universal Tag Editor (ID3v2, MP4, OGG, FLAC, …)
Yes, Mp3tag is the way to go for something like this. I’ve done it any number of times as my library of audio content has grown.
awesome!! Checking it out now thank you!