Cataloguing · 5 min read
How to catalogue your home library: spreadsheet or app?
The surest way to catalogue a home library is to scan each book’s barcode instead of typing titles and authors, then record where it’s shelved, one shelf at a time. A spreadsheet is fine for a few dozen books; beyond that, an app that fills in the details goes the distance.
The gist in 30 seconds
- Scan, don’t type: one gesture per book instead of a form to fill in.
- Add first, shelve later: give the location to a whole batch, not book by book.
- One shelf per session: finish what you start.
- Books without a barcode go in a pile and are added by title and author.
- Keep a copy: a CSV export opens in Excel, Numbers or Google Sheets.
Contents
- Why most home library catalogues never get finished
- Spreadsheet or app: which should you use?
- How to catalogue your books, step by step
- What about books with no barcode, or that can’t be found?
- Already have a catalogue in Excel or another app?
- Then: keeping your catalogue up to date
- Frequently asked questions
Cataloguing a home library answers two questions: what do I own, and where is it? The first stops you buying the same book twice; the second saves you an hour of searching. You can answer both at once, as long as you don’t go book by book.
Why most home library catalogues never get finished
Because they start with the slowest gesture there is: opening a spreadsheet and typing, for every book, the title, the author, the publisher, the year. Each row means picking up the book, finding the title page, looking up the date, putting it back. A few shelves in, the motivation is gone and the file stays half done.
And a library never stops growing. A catalogue made once and for all is out of date a few months later unless it’s easy to keep up.
Spreadsheet or app: which should you use?
A spreadsheet suits a small collection; an app that reads barcodes suits anything beyond a few dozen books. The table compares what each method asks of you, not how long it takes: that depends too much on the library.
| Method | For each book | Where is it? | In a bookshop |
|---|---|---|---|
| Spreadsheet (Excel, Google Sheets) | type title, author, publisher | one more column, kept by hand | the file is on your computer |
| App, one book at a time | a scan, then a form to confirm | often noted book by book | in your pocket |
| App, scan a batch then shelve it | a scan, nothing to fill in | given to the whole shelf at once | in your pocket, with the location |
The spreadsheet keeps one advantage: it’s your file, and you can open it anywhere. An app shouldn’t take that away. In Aldus, Settings › Export my library gives you a CSV file with all your books, where they’re shelved and who you’ve lent them to; it opens in Excel, Numbers or Google Sheets.
How to catalogue your books, step by step
The method has five steps, and it works as well for 50 books as for 2,000.
Pick a single shelf.
Not “the library”: one shelf, which you’ll finish in the session.
Scan the barcodes one after another.
The barcode is on the back of the book, usually at the bottom. In Aldus the camera stays open: one barcode is enough, the “This batch” counter goes up, and the details fill themselves in (title, author, publisher, cover) from bibliographic sources such as the French National Library, Google Books and Open Library. A book you already have is flagged (“Already at home”) and isn’t added twice. Don’t correct anything while you scan.
Set aside books without a barcode.
Some books don’t have one, older ones especially. Make a pile of them, or look them up straight away with No barcode? Search for a title, under the viewfinder.
Shelve the batch in one go.
Tap Done: Aldus offers Shelve these books, and you choose the room, the bookcase and the shelf. One action for the whole shelf, not one per book.
Add the pile.
Look each book up by title and author; if no source has it, adding it by hand only needs those two fields.
If you’d rather shelve as you go: open the shelf in Aldus, use Shelve here, and scan each book as you put it down. It’s added and shelved in the same place.
What about books with no barcode, or that can’t be found?
They don’t hold the catalogue up: they wait in a pile, then get added by title. When the ISBN is printed in the book but no source knows it, Aldus keeps the book with its ISBN and puts it in To review, the list of books that need a decision from you. Nothing is made up: a field nobody knows stays empty.
Already have a catalogue in Excel or another app?
You don’t have to start again. Save your spreadsheet as CSV (Excel: Save As › CSV; Google Sheets: File › Download › CSV), then in Aldus open Settings › Import a list. Aldus reads CSV files that contain ISBNs, and exports from Goodreads, Babelio, Gleeph and BookBuddy. When it’s done, it tells you how many books were added, how many were already at home, and which ones, with no ISBN, need checking. Then it offers to shelve them.
Then: keeping your catalogue up to date
A useful catalogue is an accurate one. The simplest habit is to scan every new book when you get home, new or second-hand, and shelve it there and then. That’s also when the catalogue pays off: in a bookshop or at a car boot sale, the Aldus search (title, author or ISBN) answers “do I already have it?”, and tells you where it’s shelved.
To get started, download Aldus: it’s free on iPhone and Android. Questions about the app are answered in the help pages, and the home page shows the rest: lending between friends, checking in a bookshop.
Frequently asked questions
Is a spreadsheet good enough to catalogue my books?
For a few dozen books, yes. Beyond that, every row is typed by hand, the file lives on your computer, and it isn’t in your pocket when you’re in a bookshop wondering whether you already own a book.
What about books with no barcode?
Set them aside while you scan, then add them by title and author. In Aldus, the “Title, author or ISBN” search finds most editions; failing that, adding a book by hand only needs the title and the author.
Can I bring in a catalogue I already keep in a spreadsheet?
Yes, if you save it as CSV. Aldus imports any CSV file that contains ISBNs, as well as exports from Goodreads, Babelio, Gleeph and BookBuddy. Books you already have are flagged, and those without an ISBN are set aside for review.
Do I need to record where every book is?
Yes, it’s what lets you find it again. But not while you’re adding: give the same address (room, bookcase, shelf) to every book on a shelf, in one go.
Is Aldus free?
Yes. Every feature is free, with no limit on books, on iPhone and Android. You sign in with Apple, Google or email the first time, so your library isn’t lost with your phone.
