Book rating display in the catalog printout

The way each books rating is displayed in the catalog print option is very difficult to use for my purposes as the attempt at showing stars and half stars is not easily managed when I copy and paste the report into excel. I have resorted to using my Goodreads copy of the library to export a listing in excel format that has a field for the average rating as well as my rating, if I have done so.

What format would you like for this purpose?

>1 JFB87: Tim has said in the past that the average site wide rating is not exportable, as it is a proprietary data set of Librarything.

Also, why are you copy and pasting into excel when you can just export to excel where the star comes through as a number?

>2 conceptDawg: I would be happy if there wasn't any attempt to publish the stars. Instead, I would make it a field just like title, author, etc..
That is certainly what Goodreads does in their exports.

>3 gilroy: It hasn't ever come through in any of my dozens of exports. I see my rating, which I rarely make. If you add it to the Your Books display it is a mix of stars and numbers which you can decode for any book, but doing so for the whole library leads to a lot of machinations in Excel. It can be made a lot easier by not display stars at all and just giving the numerical average.

By the way, I am doing a review of my 40 years of reading and writing a report meant for my family and friends. If I use those numbers must I get permission from tim?

>5 JFB87: If you rarely make a star rating, I can see why you'd never see it in your export.

Not sure how to answer the last question. Though I do wonder if you are taking that star rating from Amazon, Goodreads, Barnes and Noble, and all the other book sales sites, so you have a true average.

>6 gilroy: I don't really need that information from every book site. I just want it in a useable format from this incredible site