searching for books in library without reviews

Oh hi! I try to review everything I add to my library but I had like a backlog and I thought I'd reviewed all of them now but there's a four-item discrepancy between my books in library and number of reviews and I'm combing through them one by one and not finding the unreviewed ones and it's driving me nuts. Is there any alternative way of finding these? Any help appreciated, thanks in advance!

On Your Books, the last column includes a little speech icon bubble. If no one has reviewed the book, there is a zero next to it. That number changes if there are reviews. The icon is filled in with a blue/gray color if you have reviewed that particular book. I don't know how else to find non-reviewed books but maybe someone else knows an easier way.

>1 MeditationesMartini: Unfortunately, there's currently no way to sort your library by books you've reviewed (or not reviewed, as the case may be). You can make it easier to skim your library for books missing reviews by adding the Review field to your Your Books Display style here. That would show your reviews in Your Books, and you could skim through your library to look for empty columns.

Thanks guys! That helps :)

I use the TSV export for exactly this sort of nitpicking.

>5 bnielsen: There you go—that's a great suggestion. A spreadsheet export of your library (.TSV or Excel) would definitely allow you to sort on the 'Review' column.

>5 bnielsen:,>6 lorannen: oh! And also I had no idea that was possible in general! And it would be of great use for many reasons. Thanks!!

>7 MeditationesMartini: Yep! Realized I should have included a link to our export function: here you go!

You can actually do this without an export, but they don't make it obvious how. You can't sort by your Review column, but you can *search* it. And you can negate that search.

So what you want to do is this:

review: -*e*

Type exactly those characters, no additional punctuation including quotation marks, into the Search box in your catalog. What this will do is find all books where the Review field does not contain the letter "e". Unless you're Tim and prone to writing reviews consisting only of the word "No", this will be the same as finding books that have nothing at all in the review field.

Interesting approach. I believe searching for review: "" should also work here, finding reviews that are empty.

Thanks you all so much. I've concluded that there's actually no blank reviews but instead some lag in the number of reviews as shown on my home page--the "" search gives no results and the *e* doesn't come up with any missing reviews--though it did give me the chance to revisit reviews like "Boring," "But why?" and "This Clifford book also sucks," so that was a nice trip down memory lane. But thanks again!

>9 lorax: and >10 kristilabrie: very useful, thanks.

And here 5 years later, glad I found your help. Huzzah!