[size=10]Description[/size]
If you're like me, you love the lore and books in ES games. This time around I decided to try to collect and read them all. This is the spreadsheet I've developed for helping me keep track.

It is simply a list of all the books from http://www.uesp.net/wiki/Skyrim:Books, minus any journals and notes that were listed. It just contains 3 columns: Title, Collected, and Read.

I removed the journals and notes because I use Headbomb's awesome Better Sorting mod, so most of the journals are already renamed to e.g. "Journal - XXXXX", and the notes are easy to identify based on their single-page appearance and don't really go well on bookshelves, which is where I keep all my regular books. Also this list does not include spell tomes, which are also nicely renamed by the Better Sorting mod.

This spreadsheet is provided as-is, because I thought it may be useful to a few of you. I do not plan on updating it or making other versions which include journals and notes. However if you find a legitimate book missing or mis-labeled I may consider fixing that. Keep in mind this all came from http://www.uesp.net/wiki/Skyrim:Books which means any problems you find are most likely a problem there as well, so consider editing the wiki page in addition to commenting here.

[size=10]Main Version[/size]
Information
The main version of the spreadsheet is hosted online as a Google Spreadsheet Document. This is the version I use.
- Auto formats the background color of the Collected and Read columns based on whether a cell's contents are "0" or "1".
- Auto-calculates the number of books in the list
- Auto-calculates the collected count and percentage
- Auto-calculates the remaining count and percentage
- Auto-calculates the read count and percentage
- Sortable by all three visible columns
- There are several hidden columns on the right side of the spreadsheet used for the calculations. Don't mess with these if you want the calculations to work. Make sure they are hidden before sorting the spreadsheet (highlight columns, right click, hide).

Instructions
I could not find a lazy way to export all of this to a more portable file, so I will be sharing a read-only copy on Google Docs (i.e. Google Drive) for anyone to copy for their own use. Here is how to grab your own copy:
- Log into your Google account
- Make sure your account is signed up for the Google Drive product
----- If not, just go to http://www.google.com/drive and sign up for free
----- There's no strings attached and you don't have to install the Google Drive desktop client
- Browse to this read-only copy of the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AoUgI4M55OqudGF2VmJwVFlnSUo2X3RDZ25BNkt0N1E
- Between the spreadsheet title and toolbar, select File -> Make a Copy...
- Give the spreadsheet a name and click OK
- You should now be looking at your own editable copy of the spreadsheet.

[size=10]Other Versions[/size]
Information
I've also exported the spreadsheet to these other formats which you can download directly from Nexus on the downloads tab of this mod page. These versions do not include any auto-formatting or calculating, just the three main columns.
- ODS format (for OpenOffice/LibreOffice)
- XLS format (for Microsoft Excel)
- CSV format

Instructions
- Simply download the archive,
- extract a file in the format you want (ODS, XLS, or CSV) to anywhere on your system,
- and open/import it into your favorite spreadsheet application
Note: the archive is in 7z format (usable by 7-Zip), because ZIP and RAR are dead (get over it).

Also
Here is another Google Drive version that does not include the auto-formatting/calculating. Follow the instructions for the main Google Drive version above, using this link instead: https://docs.google.com/spreadsheet/ccc?key=0AoUgI4M55OqudFNzam9ROE9mQ1Mwa3FrU3BHdG5SN0E

[size=10]Recommended Related Mods[/size]
- Headbomb's Better Sorting (for better organizing most journals, and basically everything else in the game)
- Shawkab's Dovahkiin Hideout (besides being awesome and the best custom player home evar, it includes more than enough interactive bookshelves to hold/display every book in the game!)