Kindle tip:
I have nearly 700 books on my Kindle, and am adding 40 to 50 per month. I'm starting to forget which books I've read, which ones I really want to read, and which authors I loved or hated. In short, it's an organizational mess.
The tools provided by Amazon - namely, "Manage Your Content and Devices" and amazon.com/yml - become cumbersome to use after 100 titles. Unfortunately, Amazon doesn't offer a way to download a file of titles and authors.
Here's my solution:
1. register an account at
Shelfari. (it's owned by Amazon).
2. click the "Import Amazon Purchases" link on the home page. That will bring over all of your Amazon book purchases - Kindle and hard copies. It took less than a minute for my books.
3. complete your Shelfari profile. The site makes you go through annoying steps to complete your profile before exporting a list of your titles.
Here are the steps. Note that I was able to proceed after completing 65% of my profile (it took 10 minutes). ymmv
4. visit the home page and find the drop-down menu titled "Your Shelf." Click the last entry on the list. It's titled "Export your books."
Shelfari creates a tsv file. It's annoying because Google Sheets doesn't recognize it.
5. Import the tsv file into Excel. Save it as a workbook. Upload it into Sheets if you want it in the cloud.
6. The file comes with a bunch of unnecessary columns. Purge the ones you don't want. Add others as needed or desired. My file now has 6 columns: Author, Title, Binding*, Publication Year, Rating, and Notes. Good enough for me.
* Binding reflects whether the book is a Kindle purchase, paperback, hard cover, etc.
7. I manually add new titles that I purchase to the file. It's a pain-in-the-ass process that some of you will be able to write scripts to automate and streamline.
Having my Kindle books listed in a spreadsheet allows me to manage them more easily. I can quickly find the books I want to read or remind myself of the ones I've already read. I can sort the data, highlight entries, etc. When I buy a Paperwhite (I have a Fire), I won't have a problem knowing which books to download from Amazon.
Yes, there's effort involved. But it's a solution to a problem I've been dealing with for the last several months - a problem that worsens with every purchase.
No more.
I hope someone gets some use out of this.