I used the capitals like that for a reason! I recently met someone who kept an electronic reading list, using Excel. He had a huge list of books and highlighted them according to whether he’d read them, was reading them or if they were yet to read. I really liked this idea of keeping a reading list, as I’m always getting book recommendations, but never seem to keep them all in one place – some of them are on my Amazon wish list, but seeing the prices sometimes makes me shed a tear.
So I used my friend’s method of keeping a rEading list (or a E-reading list), but have modified it slightly according to my own preferences. I use the spreadsheet to write down the
- name of the book
- what country it’s set in
Firstly, I have three main sheets: Read, Bookshelf and Wish List.
The ‘Read’ sheet lists the books I’ve read, and I added two extra columns to show when I finished reading it and my star rating, out of 5.
The ‘Bookshelf’ is a list of the books I have on my bookshelf, I also added an extra column to remind myself if the copy I have is paperback, hardback or Kindle. This way, I won’t go searching in my room for a book that I’ve downloaded.
Then there’s my ‘Wishlist’, a list of all the books people have recommended to me, or ones that I’ve read reviews of. If I like an author, I may also add some of their other works to my wishlist, which is definitely the case with Anchee Min and Michael Palin.
Now I feel that my reading list is very organised, and I have everything all in one place. When I buy or receive a new book (last week the university gave international students lots of free books), I can enter it into my mini database and keep a record of all I’ve read.
Currently, I have read four books this year (excluding text books), I have 53 books on my bookshelf and 70 books on my wishlist*. I doubt I will get through all of them any time soon, but it’s nice having them there.
It’s also useful for when friends ask for recommendations, have you ever finished a book last year let’s say, then forgotten how much you liked it and if you would recommend it? This way helps me to remember if it was good or not. What historical fictions have I read recently? I can check that too, very quickly. Finally, if anyone asks me for an idea for a birthday/xmas gift, by the time December comes, I’ll have lots of suggestions for people.
Are any of these books on your wishlist too?
*The books in my bookshelf and on my wishlist are different, if it’s on my wishlist it means I don’t have a copy
For links to other posts about books and reading, check out the link below, this post was part of a Link-Up hosted by Jenna, a fellow member of the InfluenceHer Collective.