This is how I keep track of what I've read.
I make a table (to which I can add rows) using the LibreOffice (word processing) program. The file is called Books Read 2015-2016, for example. The file is located on my desktop for quick access. If I borrow a Kindle book, of course I have to update the Books Read file before I return it. Otherwise, I put all the books I've read in a category called "Done" on my Kindle, and update it periodically.
I have the table set up with columns for title, author, and rating. Since rows can be easily added, the books are listed in alphabetical order by author. The ratings are by stars, except for DNR which means never read a book by this author again. The books are divided by nonfiction and fiction, so I have two tables per file, and I start a new file every 2 years.
The tables are easier for me to read and the rows are easier to add when alphabetizing using a word processing file rather than a spreadsheet. I'm so used to doing this (it's been 4 years now), that it isn't as much of a pain in the neck as it sounds like.
My book wish list at Amazon is called Kindle Books, and that is where I stash all the books that sound interesting or that I want to read, so I can hopefully get them free at the library. I delete them as I read them. That way I don't forget about any books I want to read.