What does it mean to digitize a guest book?
Two separate jobs, and it helps to treat them that way. First, a photograph of every page, so the record survives even if the book doesn't. Second, the entries typed into a spreadsheet, so you can count them. The photos are worth taking even if the typing has to wait.
How do you photograph guest book pages so they are readable?
- Lay the book flat on a table near a window. Daylight is kinder to handwriting than a flash.
- Hold the phone straight above the page, not at an angle, and fill the frame with one page.
- Keep all four edges of the page in the shot, so nothing in the margins is cut off.
- Photograph the cover first, then the pages in order, so the photos keep the book's sequence.
- Check a few photos on a computer screen before you put the book away. If you can't read a line there, take it again.
Loose sign-in sheets are easier: stack them in date order and photograph them one at a time. A copier that scans to PDF works too.
What columns should a guest book spreadsheet have?
One row for each line in the book. You don't need to type names: reports use counts, dates and hometowns, and leaving names out saves time and keeps visitors' privacy.
| Column | What to write | Example |
|---|---|---|
| Book | A short label for the book | 2019 desk book |
| Page | The page number, or the photo number | 41 |
| Date | The date written, as year-month-day | 2019-07-04 |
| Hometown | Exactly as written | Bend, Oregon |
| State or country | One standard spelling | OR |
| Party size | How many people the line stands for | 3 |
| Notes | Anything odd | Illegible; class trip |
The Book and Page columns matter more than they look. They let anyone check a number against the original page later.
How do you handle messy handwriting, missing dates and families?
- Families and groups: count people, not signatures. "Mom, Dad and 3 kids" is five. If no number is given, count one, and write that rule down.
- Missing dates: many books only date the first line of each day. Carry that date down to the next one, and note that you did.
- Unreadable lines: type what you can and mark the rest "illegible." Don't guess a hometown. Unknown is more honest than the wrong state.
- Not a visitor: leave out crossed-out lines, staff tests and doodles, and note how many you skipped.
How do you keep a big archive project going?
Plan by the book, not by the year. Finish one book before starting the next, and keep a list of which books are photographed and which are typed. Volunteers can photograph while someone else types. Typing is the slow part, so photograph every book first: then the record is safe, and the typing can happen whenever someone has an hour.
What should you do with the original books?
Keep them. Photos are a copy, not a replacement. Store the books flat, somewhere dry and out of the sun, and keep the photos in two places, such as a shared drive and an external drive. Guest books hold names and hometowns, so treat the photos and the spreadsheet as private records and share only counts.
Once the books are typed, they can answer a grant question. See how to get visitor numbers for a grant application.
Or let Public Lands Log do it
Photographing is the quick part; typing is the slow one. Public Lands Log turns guest books, QR check-in signs, kiosk sign-ins and trail counter files into visitor numbers by month, where visitors came from, a live map and funder-ready reports.
- Photograph or scan the pages. Phone photos are fine, and so are PDFs. We read each page, and your staff check the sign-ins against the photo before anything counts.
- Old books are welcome. Pages more than a year old are archive pages, and plans include some in your first paid year.
- Public maps show counts by area, never names.
30 days, 150 pages, no card. After the trial, Standard is $490 a year or $49 a month. Start by January 31, 2027 and it is $390 a year for as long as you stay subscribed. See pricing
See it working first: here's a live map from a visitor center in Omaha, Nebraska, counts only and never names.
Questions about digitizing guest books
Do I need a scanner to digitize a guest book?
No. A phone in good daylight takes photos that are easy to read. A scanner or a copier that scans to PDF is handy for loose sheets, but you don't need one.
Should we type visitors' names?
Usually not. Reports use counts, dates and hometowns. Leaving names out saves time and keeps less personal information in the spreadsheet. The names stay in the book and in the photos.
How do we count a family that signed once?
By the number of people, if it is written ("Smith family, 4"). If it isn't, count one, and say in your method note that lines with no number count as one.
Is it worth digitizing books from decades ago?
Yes, if you want to show a long trend or mark an anniversary. Even a count by year, with a clear method, tells a story a single year can't.