--- title: How to move your small library off a spreadsheet Metadescription: A spreadsheet runs a small library until returns and who-has-what break it. Here is when to switch and how to move your books across. Display description: A spreadsheet is a fine way to start a small library, right up until people borrow books. The point it stops coping is predictable, and moving off it is a smaller job than most librarians expect. author: Dan Edwards author_role: Founder author_url: https://danedwardsdeveloper.com author_linkedin: https://www.linkedin.com/in/dan-edwards-developer published: 2026-06-22 --- Token estimate: ~1,200 # How to move your small library off a spreadsheet By **[Dan Edwards](https://yourbooknest.com/contact)**, Founder. A spreadsheet is a perfectly good catalogue. One row per book, columns for title and author, and you can search it in seconds. Plenty of small libraries start exactly there, and they are right to. It stops coping the moment books start moving. The job of a library is not listing books, it is lending them and getting them back, and that is the part a spreadsheet handles badly. ## When a spreadsheet stops working The spreadsheet has outgrown itself when you recognise any of these. - You cannot tell at a glance who has a particular book right now. - You own two copies of something and one row cannot say one is out and one is in. - Nobody knows when a book was due back, so nothing is ever chased. - Two volunteers edit the file and overwrite each other, or work from different copies. - You have started keeping a second list, on paper, of what is currently lent out. That last one is the clearest signal. The moment lending lives on a separate sheet of paper next to the spreadsheet, the spreadsheet has stopped being your system. ## What a lending system does that a spreadsheet cannot The gap is not cosmetic, it is structural. A spreadsheet gives each book a single row. A lending library needs three connected things instead. - The book itself, recorded once. - Each physical copy of it, tracked separately, so two copies of the same title are two things. - Each loan, linking a copy to a borrower with a due date, so the copy goes back to available when it returns. You can fake the first one in a spreadsheet. The second and third are where it falls apart, because a flat grid cannot model "this copy is out, that copy is in, this one is due Tuesday" without a tangle of extra columns that someone has to maintain by hand. ## How to make the move The migration itself is small, because the spreadsheet already holds the hard-won part, your catalogue. 1. Tidy the spreadsheet first. One book per row, a column each for title and author. Delete duplicate rows for extra copies, you will record copy counts properly on the other side. 2. Import it. A good small-library tool takes a spreadsheet or CSV directly, so your existing list becomes the catalogue rather than being retyped. 3. Set copy counts. For any title you hold more than one of, say how many. This is the thing the spreadsheet could not do, and it is a one-time pass. 4. Record what is currently out. Whatever was on your paper "lent out" list becomes a loan against the right copy, with a due date. That is the whole job. Most small libraries do it in an afternoon, because the catalogue already exists. ## Moving off a spreadsheet with Your Book Nest Your Book Nest is built for exactly this cutover. You import your spreadsheet, set copy counts for anything you hold more than one of, and you have a working lending system: loans, due dates, returns, and a clear view of who has what. It stays simple on purpose. No MARC, no fines, no forced patron accounts, and any volunteer can open it in the browser from their own device. It is free for up to 100 books, and the home page is a live demo you can try with no sign-up before you move anything across. ## Q&A **Q: When should a small library stop using a spreadsheet?** A: When books are being lent. A spreadsheet is a good catalogue but a poor lending record, so the trigger is usually the first time you cannot say who has a book, or you start keeping a separate paper list of what is out. **Q: Will I have to retype my whole catalogue?** A: No. The catalogue is the part worth keeping, and a good small-library tool imports a spreadsheet or CSV directly. The only new work is setting copy counts and recording the loans that are currently out. **Q: Why can a spreadsheet not track lending properly?** A: It gives each book one row, and lending needs three connected things: the title, each physical copy, and each loan. A flat grid cannot model "one copy out, one copy in, due Tuesday" without manual columns that quickly drift out of date. **Q: How long does the move take?** A: Usually an afternoon for a small collection, because your spreadsheet already holds the catalogue. The migration is mostly an import, a pass to set copy counts, and recording anything currently on loan.