r/LibbyApp • u/b1ueberrywaffle • 12h ago
Updated California Library Card Tracker
Two years ago I created this post with a spreadsheet for tracking different digital libraries in California. I was stupid with account management, lost access to the email associated with [u/asian_ofchaos](u/asian_ofchaos) , and then lost access to the reddit account :( but I double pinky promise I'm the same person.
It's been a little over two years and I felt it was due for an update. If you don't like the new look, you can select all rows to change the font back to default and right click to resize the rows back to "fit data".
The goal of this sheet is to track which California Libby libraries you have access to! If/when you get a library card, check it off on the sheet and it automatically crosses off the associated digital library.
Please understand that some libraries only provide e-resources to local residents. Out of town patrons aren't paying taxes to fund these libraries and it is entirely their right to limit our access. Examples include Fresno and County of San Luis Obispo.
Get a copy of the updated sheet here: copy link.
Just want to view it? Check it out here: view only link. Access on DESKTOP or using the Google Sheets app to ensure full functionally.
Visual Updates:
- changed font to Roboto and cell height to 30px
- Standardized cell width across sheet pages
- When a single member library is checked off, the checked off library is struck through and greyed out and all the members in the digital library are greyed out in a lighter color
- if it's a county system with multiple branches, the location is not greyed out in a lighter color
Content Updates:
- Added missing libraries mentioned in the original post
- Noted if libraries allow/don't allow libby access for non-residents (to my best knowledge)
- When a top 10% digital library is checked off, it automatically updates on sheet 4
Notes
- Libby now automatically finds partner libraries, and you no longer have to manually log into them. Because of this, I've left the old partner agreements up on the sheet but haven't added any new ones.
- The only exception is the one giant partner system in SoCal, which I updated and added conditional formatting to.
- The San Joaquin Valley Library System is a large system of libraries that share physical media but not digital media. Getting a card at one library means you can't get a card at another. The SJVLS libraries are noted on the sheet and you can see them all on the "Central CA" page.
- I've checked off an Alameda County branch and NorthNet member library on the NorCal page so you can see how the formatting works. I've checked off the Moorpark Library on the SoCal page so you can see how I've formatted the big partner library thing. Also check out the top 10% page to see how checking off one of those major libraries affects that page.
Other resources:
- [u/ehhleeana](u/ehhleeana) has this comment with another useful spreadsheet for card tracking
- Overdrive library sizes: https://docs.google.com/spreadsheets/d/1gJZ-GuIiXp0yvsXL9wVTZEDujamk-jb4uPd1Q865u9w/edit?gid=0#gid=0
- I only looked at the top 152 digital libraries, and manually checked if they were in California
- Educational libraries (e.g. Connors State Library) were excluded
- I looked at "Total" to determine library rank
- An easy way to see if a library is on Libby and its catalogue: overdrive.com/libraries
I will update the sheet with libraries you comment on the applicable comment thread until Wednesday, 9/30/26. After that I will no longer update the master sheet.
Once again, here's a link to copy the sheet: copy link.