Keeping a book list: spreadsheet or app?

A spreadsheet is the obvious way to start a book list: it costs nothing and you decide every column yourself. Whether it is enough depends mainly on how many books you have and how often new ones arrive.

Illustration: two index cards with a book cover and data fields, one filled in automatically, one by hand

What a spreadsheet is good for

  • Small collections of up to about a hundred books
  • When you need custom columns no app offers
  • For analysis and printable lists
  • When you work with Excel or Google Sheets every day anyway

Where a spreadsheet reaches its limits

SpreadsheetDreamShelf
Adding a bookType every field by handScan the barcode, details are loaded
CoversOnly awkwardly as inserted imagesAutomatic, shown as a shelf
Looking things up on the goTedious on a phoneMade for the phone, offline too
Search and filterWith spreadsheet filtersBy author, publisher, genre or reading status
Custom columnsAnything you likeFixed fields
CostFreeFree with limits, Pro from €39.90 per year

Combining both

You do not have to choose. DreamShelf exports your collection as a CSV file you can open in Excel, Numbers or Google Sheets. The file includes shelf, title, author, year, publisher, ISBN, page count, binding, genre, language, location, reading status and rating, among others. So you add books by scanning and analyse them in the spreadsheet.

DreamShelf currently has no import from an existing spreadsheet. If your list contains the ISBNs, the fastest way is still to scan the books again.

When switching pays off

At the latest when you are standing in a bookshop not knowing whether you already own a volume, or when adding new books keeps getting put off, the spreadsheet has become a burden. That is when a scanner saves the most work.

Frequently asked questions

Is there a spreadsheet template for book lists?

You do not really need one: columns for title, author, ISBN, location and reading status are enough to start. Or export your collection from DreamShelf as CSV and the spreadsheet is ready.

Can I import my spreadsheet into DreamShelf?

Not at the moment. Only a backup from DreamShelf itself can be imported.

Can I get my data out of DreamShelf again?

Yes, at any time as CSV and as a full backup, on the free plan too.

What does DreamShelf cost?

On the free plan you can add up to 10 new books per day and 50 per month and create one shelf. DreamShelf Pro (€5.99 per month or €39.90 per year) removes these limits.

Try the scanner instead of the keyboard

Add ten books by barcode and compare how long the same ten take in a spreadsheet.