Dear Shelf

How to export your Goodreads library

Goodreads lets you download everything you've shelved as one CSV file: titles, ratings, shelves, dates and reviews. It takes about a minute and only works from the website.

Export in 5 steps

  1. Open goodreads.com in a browser and sign in. The Goodreads phone app can't export, so on a phone use the browser and switch to the desktop site if the menu is missing.
  2. Go to My Books. In the left sidebar, under Tools, click Import and export. Or open the export page directly: Open the Goodreads export page
  3. Click Export Library at the top of the page.
  4. Wait while Goodreads builds the file. A link like Your export from (date) appears under the button. Small libraries take a few seconds, big ones can take a few minutes.
  5. Click that link to download goodreads_library_export.csv.

What's in the file

One row per book. The columns you'll care about:

Title, Author, ISBN, ISBN13 · which book it is
My Rating · your stars, 0 means not rated
Exclusive Shelf · read, currently-reading or to-read
Bookshelves · your custom shelves, comma separated
Date Read, Date Added · when you finished it and when you added it
My Review, Private Notes · your review text and notes
Read Count, Number of Pages, Year Published · the rest of the details

If something goes wrong

The export link never shows up

Refresh the page after a minute or two. If it still isn't there, click Export Library again. Very large libraries sometimes need a second try.

I can't find Import and export on my phone

It isn't in the app. Open goodreads.com in your phone's browser, request the desktop site, then go to My Books.

The ISBN column looks like ="9780..."

That's normal. Goodreads wraps ISBNs so spreadsheets don't turn them into numbers. Apps that import Goodreads files expect it.

Some books have no ISBN

Usually ebooks or editions Goodreads doesn't have an ISBN for. Most importers fall back to title and author for those.

Does exporting change my Goodreads account?

No. It only makes a copy. Everything stays on Goodreads as it was.

What to do with the file

Keep it as a backup, open it in a spreadsheet, or move your shelf somewhere new. In Dear Shelf you pick the file once and every book lands on a little 3D bookshelf, with read, reading and want-to-read kept apart and your ratings and finish dates carried over. It's free, with no ads.

A Dear Shelf 3D bookshelfHow the Goodreads import works →