Amazon Kindle discussion
Device Related
>
Where do you store all your ebooks?
date
newest »



I've JUST set calibre up. It took a while to get it the way I like it, since I was dealing with a backlog instead of just maintenance, but I like it so far too.

Since I can export my GoodReads list, I can always use EXCEL to manipulate and search the data.


Ummm. What good does that do? Those eBooks are only readable on that specific Kindle device. Unless you've removed the DRM of each book.

It does take a bit of work at first- there's a bit of a learning curve (not long- maybe an hour or so?), and I had to spend some time rounding out the metadata when I first loaded my books into it. But now it's pretty seamless- when I add a book to calibre the DRM is automatically stripped, so I pretty much just have to worry about what tags I'm going to put on it.

Ummm. What good does that do? Those eBooks are only readable on that s..."
Randy,
The "good" it does to have all your ebooks on your personal computer (instead of/in addition to) the device and/or "the Cloud" is that you have an immediate backup copy of everything. I don't trust the Cloud because it's someone else's servers and I have no idea who has access to that.
Also, if something happens to your Kindle (don't know about Nooks or other devices) so far as I know there's nothing to "click" and have AMZ download all your purchases automatically. Instead you have to do it one at a time. At roughly 1500 books from AMZ and even with managing an average of starting a new download every 30 seconds that's 750 minutes of download time.
As opposed to just using USB to copy everything (or selected things) quickly.
The other thing is that at least with Kindle, you can download the app. Using the app only allows you to read books from the Cloud, in theory, but if you go to a non-AMZ-purchased mobi (say, scifi/fantasy from Baen) you just double-click the file and that enables you to read on your computer.
Just a few thoughts based on my experience (particularly with having had to replace a Kindle).
Eric

I don't see any reason to make the Kindle the primary storage device. Especially with how cumbersome it is to add them to collections. How many of those 1500 books have you actually read? Or even opened?

Sorry if I wasn't clear. My PC is the primary storage device. Between AMZ purchases and elsewhere I have about 2000 ebooks. The only ones on my Kindle are the ones I haven't read yet...about 650.
As far as collections go, I don't have any. I have 18 years of data entry for the just-under 11,000 books in my library, into an Excel spreadsheet that lets me sort my books by author, title and category (SFK = Scifi Kindle, SFH = hardcover, etc.). I understand the value of collections to some/most ebook readers, but I don't have the time/inclination to start more data entry for ebooks, whether on the Kindle or in Calibre, in order to create collections, which I would then have to maintain.
With respect to "sending" books to the Kindle the only method I know of for doing so is via email, which requires me to go through AMZ and then download to the device. If there's an alternative that involves a WIFI connection, I don't have one. So...plugging the Kindle into the PC, and transferring is (so far) the most efficient for me.
Thanks for your advice, though. I appreciate the courtesy.
Eric

I would like to change that behavior so that books are kept at amazon but only delivered to my Kindle on request, when I choose to read that one next. Should I change my purchase option from "send to kindle" to "send to cloud reader"? What exactly is the cloud reader?

I send almost all of my purchases to the Cloud Reader. It's really a meaningless choice, since it just means the book remains in the Cloud. They really should have a "Send Nowhere" option, because occasionally there are books that are formatted in a way that the Cloud Reader can't handle them, and then "Send to Cloud Reader" isn't available.

When you're ready to read, just go back to AMZ, click on the book and the options and you can manually download to whatever device you choose, download to your computer, etc.
Once read, you can just delete it, since AMZ will still have it.
Though I highly encourage everyone to store a copy of all of your ebooks on your own computer/tablet. That way, if anything happens to AMZ and its servers, no matter how unlikely, you have the entire collection you've bought and paid for, or gathered "freely."
Just my USD .02.
Eric


Admittedly, the TBR group is tough to browse through, but I'm usually in the mood for a certain genre, and those are a lot easier to scroll through. It was a little bit of a pain to set up, but now it's easy enough to maintain.

I don’t keep that many books on the Kindle itself -- just the book I’m currently reading, and maybe the next half-dozen or so books that I plan to read. I don’t like clutter in real life, and I find that I’m much happier when even my electronic devices feel clutter-free!
As far as actual organization of my titles goes, I use a self-built Microsoft Access database. I like having the power to customize data entry forms and queries exactly the way I want. If I didn’t know (and didn’t want to learn) how to create my own database, I would probably go with Excel. It isn’t as fancy or powerful for this purpose, but it’s still a decent and customizable alternative. I like the idea of having my books organized offline in a single, consistent format of my choosing as opposed to being tied to the format and availability of an online site like Goodreads.
I use Goodreads mainly for the more social aspects – reading and writing reviews and occasionally participating in groups. I’ve only added books to my Goodreads shelves that I’ve read since joining late last year, plus I usually add the next few I plan to read. It wasn’t worth it to me to take the time to import all my books into Goodreads when I already have all the information organized elsewhere. And the thought of going back and trying to fill in past books I’ve read was just way too overwhelming.
Calibre. I use it to the point where I feel guilty every few months and make a donation. Critical APP.

I would use Calibre as an archive. But with investigation you can also convert the format of the books you own.
(DRM is a whole 'nother conversation)
(DRM is a whole 'nother conversation)

Which kind of Nook? A traditional nook or the newer Samsung Galaxy Nook tablet? If it's the newer tablet version, all you need to do is download the kindle app and you can read all of your kindle books on your new nook via the app. If it's the traditional one, you would have to convert the kindle books to the nook format. I haven't had to be bothered with it, but there are programs out there that can convert ebook formats. Calibre is a popular choice.




Hi, do you mind teaching me how you sort your ebooks using Excel? I want to make like a "library-list" in Excel but I'm a little clueless on how to start. My reason for wanting to do this is so that I can easily share to other people the books I have in my ebook library. :))

Hi, Phoebe!
Sit back and relax, as this may be kind of lengthy.
My spreadsheet has three columns for my books. The first is the Name (Title) column, which is "54" (of whatever Excel's measurements are) wide. The Author column is "23" wide, and the Type column is "7".
These widths were picked because when I have Excel in its less-than-full-screen mode,I can see all three columns.
I use three worksheets (I still call them spreadsheets). The first is Title, the second Author, the third Type. The master list is the one by title. Obviously it's sorted just by title. >Duh!<
The second is simply the master list copied and pasted so it's a duplicate, but then it's sorted by Author first and then Title.
The last is also a duplicate of the master list, but sorted by Type, then Author, then Title.
The "by-Title" master list is where I do all the initial data entry, and then "every so often" I'll do the copy-the-whole-thing-to-the-clipboard bit, highlight the second list, paste the revised version over it, sort and then repeat for the final list.
That's the background to answering your question. The "Type" column is a three-letter code that tells me what category of book it is, and what physical type it is (hardcover, paperback, Kindle, or trade).
In case you're not familiar with the term, a "trade" paperback is the one with the odd size that's between a hardcover and a regular (also known as "mass market") paperback.
So FAH, FAK, FAP, FAT = Fantasy hardover, Kindle, paperback, trade.
SFH, SFK, SFP, SFT = Science fiction ditto.
MYH, MYK, MYP, MYT = Mystery ditto.
DIH, DIK, DIP, DIT = Dictionary ditto.
While most of my books fall within certain categories, with the biggest ones being gay literature, science fiction, fantasy, romance and mysteries-thrillers, there's enough variety that over the years it turns out my list of codes is 5 pages long. (I haven't ever printed out the list before.)
Since this is just for your ebook library, then obviously you wouldn't need the codes for hardover, paperback or trade...which cuts the list by two-thirds!
If it would be helpful to you, I have a PDF of the book code list. It might give you something to build on when you do your own spreadsheet. If you want a copy, send me an email at:
ea westfall 43 @ gmail . com
Hope this helps.
Eric

I was just entering some recent purchases (your question inspired me to catch up), and I realized a couple of things.
First, I have the spreadsheets set so that each cell "word wraps." That's normally not an issue with authors, since there's usually only one and the column width is wide enough for virtually all names. Sometimes there are multiple authors listed, and I don't really have a policy for that. Sometimes I just put "Various" and sometimes: "Jones, John, etc."
With two collaborators (like the superb Sharon Lee and Steve Miller on their so-far 18+ novels in the Liaden universe they created) I just put Lee/Miller. With word wrap you could put both names. (It took me a while to find out, but you can artificially create multiple lines within a single cell by hitting CTRL-Enter at the point at which you want to start a new line.)
The other thing is: a series. The best example is J.D. Robb (a pseudonym for Nora Roberts), who has written an extraordinary series of murder mysteries set in the future, where interstellar travel is normal, but the scifi aspects are simply a background, like setting the story in Los Angeles. Each book has the words "in death" in the title and there are 49 of them so far.
So it's called (in my spreadsheet) "In Death Series." I do the data entry this way:
In Death Series 01: Naked in Death
In Death Series 02: Glory in Death
etc.
That way, all the books in a single series are sorted essentially by publication date (the 01, 02, etc.).
Okay, I'll try not to dump any more information on you.
Eric

Hi Phoebe, Just in case your question was a more literal question about how to sort data in Excel, here are some instructions. If you already know, just ignore this post. :)
My instructions are based on the more recent versions of Excel that have the “ribbon” at the top, I think since version 2007. The instructions seem long, but the steps are actually really easy. Once you’ve done it a couple of times, you’ll have no trouble with it.
1. Click on a single cell within your table of data. It doesn’t matter where, just make sure you haven’t selected more than one cell or it may get confused and sort only a subset of your data.
2. Click on the “Data” tab on the ribbon at the top of your screen.
3. Click the icon that has two columns of A’s and Z’s and says “Sort” under it.
4. Now you’re building your sort method. At the beginning, you’ll just see a single row that starts with “Sort by”. Use the drop-down arrow to select the first column you want to sort by. You’ll usually want to leave the second option as “Values”. You can change Order to “Largest to Smallest” if you want to sort in descending order.
5. If you want to sort by another field, click the “Add Level” button. You can then specify the next field you want to sort by. Repeat this step as many times as needed until you’re sorting by all the columns you want.
6. The columns will in the order you list them in your Sort list. So if you want to sort first by author, and then by title, you need to make sure Author is the first column you select and title is the second column you select.
If you only want to sort by a single column, you can save some steps by just clicking inside a single cell in the same column you want to sort and clicking one of the smaller sort icons next to the larger Sort icon. For example, the icon with an A above the Z and an arrow pointing down will automatically sort your selected column in ascending order.
If you’re creating a new spreadsheet from scratch, this is the best time to think ahead about how you might want to use your spreadsheet so that you can design it flexibly. Sorting is easy and fast, so you may want to sort on different things at different times, depending on what you’re trying to see at that moment. For example, is it possible you might sometimes want to sort by the author’s last name and sometimes sort by their first name? If so, put first and last name in two separate columns and you’ll have the flexibility to do that. Is it possible that you might, at some point, want to only look at the first book in each series? If so, put the series name and the series order in separate cells. Then you can sort or filter by the series # and just look at books with a 1 in the series order column.
Another advantage of breaking things up as much as possible is that it gives you more flexibility if you decide to play around with the filter function. The filter function lets you “hide” data that isn’t relevant for what you’re currently interested in so you can just focus on what you need to see. For example, you could only display books that aren’t part of a series which would be the books where the series column is blank. Or you could only display books where the series order is 1 as in my earlier example. Or you could only display books by a certain author. Or only display unread books that aren’t part of a series. You can do anything you can imagine, as long as you have the data entered to support it. If you’re interested, and if you don’t already know, here’s how to use the filter function:
1. Click on a single cell in your table of data.
2. Click on the “Data” tab on the ribbon at the top of your screen.
3. Click the “Filter” icon (with the funnel). You’ll see drop-down arrows appear in each of your column headings.
4. From here, it’s probably pretty self-explanatory. Click on the drop-down arrow for whichever column you want to filter on. For example, if you want to filter by only books that are the first in a series, click on your “Series Order” column, uncheck the “select all” checkbox to deselect everything, then put a checkmark next to the “1”. Then click OK and your goal is accomplished. You can filter on multiple things at a time by using the drop-down arrow on other columns. Your other data isn’t gone, it’s just hidden.
5. If you want to undo your filters and get things back the way they were, just click on the “Clear” option next to the Filter icon you clicked on in step 3. If you want to completely remove the filter functionality altogether, just repeat step 3 and the drop-down arrows will go away.
One thing you could do is create a small spreadsheet with just a few sample titles and play around with sorting and filtering to get a feel for how you can use it, and what you might want to do in the long run. Even though you can undo your changes, sometimes people are more comfortable experimenting with a spreadsheet they aren’t worried about breaking. Speaking of which, the curved arrow that’s pointing left, up at the top of your Excel window, is the “undo” button. It will undo your last change and you can keep pressing it to keep undoing a series of changes. (It does have a limit, but it takes a while to get there.) Ctrl+Z is the keyboard shortcut for “undo”.
Sorry to write a novel! I love spreadsheets and databases so I can get carried away…

Same.
I recently noticed that Kobo e-readers also accept Mobi now (I don't know when they started, but they used to accept only ePub). So I could replace my old Keyboard Kindle for a Kobo and store my epubs and mobi files on the same device.


I have decided on using Excel, which will allow for a number of search features; however, I need suggestions on directory architecture to store my books.
I am currently creating directories for each book and labeling them as the ISBN, and creating a link to the directory in Excel, yet I am not sure if this is the best solution.
What do you find works for you?
Thank you
JJ

All of my ebooks are safely stored on my computer. Part of that is because I don't trust someone else's servers (a/k/a "the Cloud") to do so. Part of is because, while I have just under 4000 ebooks (out of 11700ish in my library), a good amount of my books are bought from other sources...regular monthly bundles from Baen, for example, or sales at Dreamspinner and other publishers.
All my ebooks are stored in a folder with a simple name: KIndle All. >s<
I have an Excel workbook that I've used for the last 15 years (long before I started buying ebooks) to keep track of what I own.
It has a wide column for titles, a not-so-wide column for author names, and a narrow column for the book categories.
"Categories" are a three-character code that tells me not only the book category (genre? perhaps) but what type it is.
For example, MYH, MYK, MYP, MYT = Mystery in Hardover, Kindle (i.e. any ebook format), mass market paperback, and trade paperback. Ditto thrillers (TH), Science Fiction (SF), Fantasy (FA), and quite a few more, with categories involving horror, non-fiction, "literary" fiction, etc., etc.
The main spreadsheet is the "Title" one. That's where I enter everything as the books are bought. The second is "Author" and the third is "Category". When I've entered a bunch of new books in Title (and the sort is just by that), then I copy and paste the whole spreadsheet "over" Author, which is sorted by Author/Title. Ditto Category, which is then sorted by Category/Author Title.
Respectfully, I suggest if you're starting from scratch with data entry of all you own, it's a lot easier to go with simple, easy-to-find information like title/author, than having to look inside your physical books, or scroll through your ebooks, to find ISBNs. The latter are far easier to mis-type and not notice it, and no spellchecker to catch it. However, if you goof on typing Stephen Kngi, you'll either notice it yourself or the spellchecker will. Also, it seems unlikely you're going to remember a 10 or 13 digit code when you want to find a book, whereas it's more likely you're going to remember all or part of a title, which can be searched in the spreadsheet.
Just my USD .02.
Eric
p.s. If you're interested in the category list, I'd be happy to send a PDF of it.

If you try to read them away from wifi, they are unavailable unless you've downloaded them to your device. I have 3000 books in the Kindle carousel, but only a dozen or so are residing on the device; only the covers show. As soon as I finish reading them I just delete from device with a right click.
I organize them by making collections and putting them into one or more, like 'for review,' 'epic fantasy,' 'political thriller,' or 'series.' The About This Book has made this easier to do, but it entails downloading the book, which is pretty lame, so I go by cover text on the older books. (Amazon really needs to add a mouse-over description to the book covers in Kindle.) If you then 'remove from device,' the cover remains in the collection to download when you're ready, until you delete it.

In my opinion, the only advantage of storing your e-books on the computer is as a backup in case Amazon’s servers (and their backup servers) somehow get wiped. I can definitely understand wanting to do that but, if you’re only storing them as a backup for a fairly unlikely scenario, it probably isn’t worth your time to create a complex directory structure for them.
So I might be missing the point. What’s the purpose of the hyperlink from your spreadsheet to your e-book directories? What will you do once the hyperlink takes you there? Do you intend to use your spreadsheet to access the e-book and read it on your computer? If you’re reading on your Kindle, it’s faster to download it onto your device directly from the cloud. If you have e-books from places other than Amazon, you can store those on Amazon’s cloud so all your Amazon and non-Amazon e-books are in one place and easily downloadable from your Kindle.
Even if you keep a backup on your computer, accessing them from the cloud is easier. It also gives you the opportunity to sync between devices. If you have unexpected downtime when you're out and about, you can open the book on your smart phone and it will quickly sync up to the same position you were last at on your Kindle at home.
As far as the data about the books, such as which books I own, what I’ve read, my reviews, etc., I do store that offline. I prefer to maintain my data in a safe and consistent format on my computer and then input whatever info I want to store on sites like Goodreads for the social aspects. I use an Access database, because I’m geeky like that, but Excel would work fine too and is powerful enough for most needs. Each book record in my database includes a hyperlink to the Goodreads page for that book, and I get a lot of use out of that. I often use my database to narrow down my next read, and then I use the hyperlinks to quickly access other information such as ratings and reviews.

I do too.

In addition, I have a number of paper bound books that I would like to catalog and record, which is why I am looking for a database or Excel based solution. The solution I hope for - will allow me to aggregate all my formats into one location - giving me the capability to review and search my entire collection despite the format.
My main problem - is long file names and duplicate publications titles that are written by different authors. Currently - I am saving books in the following format "Title-author.epub"; however, the file name is really long and cumbersome at times.
As a community and personal experience - how do you name/label your books stored on your computer? Have you run into any problems with long file names?
Thank you
JJ

Personally, I would use software like Calibre to convert my epubs into mobi and then send them to Amazon’s cloud. This not only puts everything in one place, but ensures that it’s available from any device with access to WiFi so you can find and read it from anywhere. I’ve done this with several non-Amazon books that I own in incompatible formats. In my database I have a field that indicates the general location of my books – in the cloud, on a physical shelf, or not owned at all.
Calibre can also be used as a cataloging tool for your books. Even if you choose not to convert them or use the cloud, Calibre can be used to search your books on your computer, and open and read them. I don’t use Calibre for cataloging, so I’m not as well-versed in its functionality as others on this site probably are. I think it creates its own file structure on your hard drive with any books you import into it, and it automatically links to those files.
Since I only store books on my hard-drive as a “last resort backup”, I don’t worry about file nomenclature so I don’t have any good advice for you. Hopefully somebody else will. It would be cumbersome to keep that much info within the file name. Maybe you could have separate folders by author and then drop the author out of the file name. But I realize this would be a problematic solution for multi-author documents, unless you put the book under one author’s folder and then created shortcuts to that file in the other authors’ folders.



I use the Kindle app on my computer to download my ebooks, but you have to download them one by one. After the ebooks are downloaded to your computer, you can add them to calibre and you can add several at a time. If you want Calibre to remove the drm from them, you have to install the plugins from Apprentice Alf before adding any ebooks to Calibre.
I first tried using GoogleDrive and Dropbox (www.dropbox.com). Then I started using Evernote (www.evernote.com), but none of them gave me the visual catalogue that I was looking for. I’ve recently came across an Amazon purchase tool called Unioncy (www.unioncy.com) that automatically creates a catalogue of all my belongings (including books) from the information of my Amazon receipts in my email.
I’m curious to hear if anyone else has tried and can share their experience? Seems to be quite useful to me.