What are you trying to do?
Type it in plain words — like "scan my records" or "what is my coin worth."
Hello, and welcome. Maybe you have coffee cans of coins from your father, a closet full of vinyl records, shoeboxes of baseball cards, or shelves of books you've gathered over a lifetime. Maybe you've thought, "I really ought to write all this down someday." This guide is for you. And if you're helping a parent or grandparent get their collection organized, this guide is for you too.
I'm Bill. I've spent more than 30 years working with technology, and these days I help folks here in Portage County, Ohio, feel at home with theirs. I wrote this guide the way I'd explain it at your kitchen table: slowly, in plain English, and without trying to sell you anything. When I use a word like "spreadsheet" or "barcode," I'll stop and explain it right then.
Cataloging is one of the gentlest tech projects there is. You type a few words, take a photo, and save. If you make a mistake, you fix the line. Nothing in this guide touches your bank account or changes your computer in a way you can't undo. You can do ten items tonight and ten more next week. There's no deadline and no wrong way to start.
If anything in this guide leaves you unsure, call me at (330) 200-8042. There's no such thing as a silly question.
Let's begin with the simplest question: why bother?
— Bill
Call Bill and he'll walk you through it — or come do it for you.
A catalog is more than a list. These three small setups take a few minutes and make your records safer and far easier to use. A family member can help with any of them.
Checked against Google Drive Help on November 15, 2026.
Checked against Apple Support on November 15, 2026.
Checked against Google Drive Help on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A catalog is simply a list of what you own, with enough detail that someone else could tell one item from another. It can live in a notebook, a spreadsheet on your computer, or an app on your phone. The tool matters far less than the habit.
| Reason | What it does |
|---|---|
| Insurance | If there's a fire, a flood or a break-in, a list with photos makes it far easier to show what you had. A Home Inventory for Insurance and Talking with Your Insurance Agent cover this. |
| Family | Your children or grandchildren may not know a rare coin from pocket change. A catalog tells them what matters, and why (Passing a Collection On). |
| Selling | When you decide to sell, you'll already have photos, descriptions and condition notes ready (Selling Safely). |
| Shopping | No more buying a second copy of the same record or book because you forgot you had it. |
| Enjoyment | Many collectors find that cataloging is a pleasant way to revisit their collection and remember where each piece came from. |
Call Bill and he'll walk you through it — or come do it for you.
There are two main ways to catalog with technology: a collection app made for one kind of item, or a spreadsheet you design yourself. Each has real strengths. Many people end up using both.
| Collection app | Spreadsheet | |
|---|---|---|
| Best for | Records, books, coins or cards with barcodes or a big online database | Anything at all, including mixed or unusual collections |
| Speed | Fast: scan a barcode or snap a photo and the details fill in | Slower: you type each line |
| Value estimates | Often built in | Only what you type in yourself |
| Cost | Often free to start; some features need a subscription | Free with Google Sheets; Excel comes with Microsoft 365 |
| Who controls it | The app company keeps the data on its servers | You do; the file is yours |
| If the company closes | You may lose access unless you exported a copy | Nothing changes |
Call Bill and he'll walk you through it — or come do it for you.
The secret to a useful catalog is recording the same few things for every item. Here's a list that works for almost any collection. You don't need every field on day one.
| Field | What to put in it |
|---|---|
| Item number | Your own number: 1, 2, 3 or C-001 for coins, R-001 for records. Write it on the sleeve, holder or a slip of paper with the item, so the list and the object match. |
| What it is | "1921 Morgan silver dollar," "Beatles, Abbey Road LP," "1952 Topps Mickey Mantle." |
| Identifying details | Year, mint mark, edition, label, catalog number, card number, ISBN, printing. |
| Condition | Your honest words ("light scratches, no warp") or a grade if it's been professionally graded. |
| Certification number | For graded coins and cards, the number printed on the plastic holder's label. |
| Where it's kept | "Blue album, sleeve 4," "Basement shelf B," "Safe deposit box." |
| How you got it | Bought, gift, inherited — and from whom, if you know. |
| Date and price paid | Even rough is helpful: "about 1985, around $20." |
| Estimated value | With the source and date: "App estimate $150, March 2026." |
| Photos | File names or a note that photos are saved (Taking Good Photos with Your Phone). |
| Notes and story | Why it matters to you. Families treasure this column. |
Call Bill and he'll walk you through it — or come do it for you.
You don't need a fancy camera. The phone in your pocket takes photos that are more than good enough for a catalog, an insurance file or a sale listing. A few simple habits make the difference between a blurry snapshot and a photo that really shows what you own.
Call Bill and he'll walk you through it — or come do it for you.
Each kind of collection has its own little tricks. Here are the ones that matter most.
Call Bill and he'll walk you through it — or come do it for you.
Paper proof matters: receipts, appraisals, certificates of authenticity, auction records and letters describing where something came from (collectors call this provenance). Your phone can turn each one into a clean digital copy in seconds.
Checked against Apple Support on November 15, 2026.
Checked against Google Drive Help on November 15, 2026.
Use the item number and what the paper is: "C-014 receipt 1998," "R-102 appraisal 2024." Keep all of them in one folder named "Collection paperwork." Backing Up Your Catalog and Photos shows how to keep a second copy somewhere safe.
Call Bill and he'll walk you through it — or come do it for you.
A spreadsheet is a grid of boxes, called cells, arranged in rows and columns, like a ledger book. Each row is one item in your collection, and each column is one kind of detail: name, year, condition and so on. Two programs are the most common: Google Sheets, which is free with a Google account and works in a web browser, and Microsoft Excel, which comes with Microsoft 365.
| Program | In plain words |
|---|---|
| Google Sheets | Free. Saves automatically to your Google account, so it's backed up as you type. Easy to share with a family member. Works on a computer at sheets.google.com and in the Google Sheets phone app. |
| Microsoft Excel | Included with a Microsoft 365 subscription, and often already on Windows computers that came with Office. Saves to your computer or to OneDrive. Familiar to many people from work. |
| Apple Numbers | Free on Mac, iPhone and iPad. Works the same way, if that's what you already use. |
In Excel, choose Blank workbook, type the same headings in row 1, and use View > Freeze Panes > Freeze Top Row. Remember to save with File > Save As and a clear name. Excel's AutoSave only works when the file is stored in OneDrive.
Call Bill and he'll walk you through it — or come do it for you.
Both Google Sheets and newer versions of Excel can place a small picture right inside a cell, so each row shows a thumbnail of the item. It makes a list much friendlier to browse.
Checked against Google Workspace Updates on November 15, 2026.
A cell holds one picture. If you want front and back, add a second photo column, or keep the full-size photos in a folder and use the picture in the sheet as a reminder.
Checked against Microsoft Support on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Once you have a few dozen rows, the spreadsheet starts to pay you back. You can put items in order, find one in a second, and add up what you've spent or what things might be worth.
Press Ctrl and F together (on a Mac, Command and F) and type a word: "Mantle," "1964," "Blue Note." The spreadsheet jumps to each match.
Call Bill and he'll walk you through it — or come do it for you.
Discogs is a huge online database of recorded music on vinyl, CD, cassette and more, built by collectors, along with a marketplace where people buy and sell. Its official app for iPhone and Android lets you build a list of what you own (your Collection) and a list of what you're hunting for (your Wantlist).
Checked against Discogs Support on November 15, 2026.
The Android app is similar: tap the magnifying glass at the top right, then the small barcode icon. If there's no barcode — most records made before the 1980s don't have one — search by artist and title, or by the catalog number printed on the spine or label.
Checked against Discogs Support on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Books are one of the easiest things to catalog, because most books printed in recent decades carry an ISBN barcode — a unique book number — on the end of the guide. Scan it, and the app fills in the title, author and cover.
| App | In plain words |
|---|---|
| Libib | Made for cataloging a home library (it also handles movies, music and games). Its Basic plan for personal collections is free, and lets you export your list any time. Libib Pro, aimed at schools and organizations, costs $9.00 a month or $99.00 a year. |
| Goodreads | Free. Best known as a place to track what you've read and see reviews. Its app can scan a book's barcode or cover and add it to a shelf, such as Want to Read. |
| The StoryGraph | A reading tracker with a free version and a paid StoryGraph Plus ($4.99 a month as of November 2026, with a free trial). It can import a list exported from Goodreads. |
| CLZ Books | A dedicated book-collection app. US $1.99 a month or $19.99 a year, with a free 7-day trial, according to CLZ. |
Checked against Libib, Goodreads, The StoryGraph and CLZ on November 15, 2026.
Older books may have no barcode at all, and a scan can occasionally bring up the wrong edition. For those, type the ISBN printed on the copyright page if there is one, or enter the title and author by hand.
Call Bill and he'll walk you through it — or come do it for you.
Two of the best-known coin grading companies in the United States are PCGS (Professional Coin Grading Service) and NGC (Numismatic Guaranty Company). A graded coin is sealed in a hard plastic holder, often called a slab, with a label showing its grade and a certification number. Both companies offer free phone apps.
| App | What it does |
|---|---|
| PCGS Cert Verification | Free. Scan the barcode or QR code on the label, or type the certification number, to confirm the coin and grade match PCGS's records. It also shows a Price Guide value. |
| PCGS CoinFacts | PCGS's reference app with coin information, its Price Guide and Photograde (photos that show what each grade looks like). PCGS describes it as 100 percent free; check the store listing in case that changes. |
| NGC App | Free. Scan the barcode on an NGC label to verify the coin, and see population data and NGC Price Guide values for U.S. coins. |
Checked against PCGS and NGC on November 15, 2026.
Most coins in a family collection have never been graded, and that's fine. Record the country, denomination, year and mint mark, photograph both sides, and describe the condition in your own words. Many photo-identification apps exist for coins; treat their answers and values as a guess to double-check, not a fact.
Call Bill and he'll walk you through it — or come do it for you.
Card-scanning apps identify a sports or trading card from a photo and show an estimated market value. They're quick and fun, and most are free to download, with paid subscriptions for unlimited scanning and extra features.
| App | In plain words |
|---|---|
| Collectr | Aimed at trading card games such as Pokémon, plus other cards. Free download; Collectr PRO has been listed in the App Store at $7.99 a month or $59.99 a year in 2026. |
| CollX | Aimed at sports cards. Free download; identifies a card from a photo and shows an average market value. Paid Pro and Gold tiers are offered; CollX lists Gold at $24.99 a month. |
| Ludex | Sports and trading cards. Free download. The App Store lists paid Lite, Ludex and Pro plans, from $4.99 to $24.99 a month. |
| PSA Cert Verification | Free on iPhone and Android, from PSA, a major card-grading company. Scan the barcode or QR code on a PSA label, or type the cert number, to confirm a graded card is genuine. |
Checked against App Store listings, CollX, Ludex and PSA on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Not every collection has a barcode or a dedicated app. Stamps, dolls, quilts, die-cast cars, pocket knives, antique tools, figurines, comic books — they can all be cataloged beautifully with a spreadsheet and good photos.
Checked against NAIC Home Inventory app listing on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A collection app can hold years of your work. Before you put hundreds of items in one, a few questions protect you from surprises.
Every app is a little different, but the export option usually lives in the app's Settings or Account area, or on the company's website rather than in the phone app. Look for words like Export, Download or Backup. The file it gives you can be opened in Google Sheets or Excel.
Checked against Apple Support and Google Play Help on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Almost every collection app shows a dollar figure next to your items. It's exciting to see, and it's useful, but it helps to understand where that number comes from before you rely on it for insurance, a sale or a family conversation.
Checked against Discogs Support, PCGS and NGC on November 15, 2026.
| Factor | Why it matters |
|---|---|
| Condition | A crease, a scratch, a warp or a cleaned coin can cut the price sharply. A pristine copy can be worth far more than average. |
| Exact version | A first pressing, a first edition, a mint mark or a rare card variation can change everything. A scan may pick a more common version. |
| Demand changes | Prices for cards and records rise and fall with popularity. Today's estimate is a snapshot, not a promise. |
| Selling costs | What a buyer pays isn't what you keep. Marketplace fees, shipping and a dealer's margin all come out of it. |
Call Bill and he'll walk you through it — or come do it for you.
An appraisal is a written opinion of value from a trained professional, usually for a specific purpose such as insurance, an estate or a donation. Most family collections don't need one for every piece. A few situations make one well worth it.
In the United States, appraising personal property such as coins, cards, books and records isn't licensed by the government, so anyone can call themselves an appraiser. Three professional groups are the usual starting points: the International Society of Appraisers (ISA), the American Society of Appraisers (ASA) and the Appraisers Association of America. Each has a way to find members.
Checked against International Society of Appraisers on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A home inventory is a list of your belongings, with photos and receipts, that you'd use to file an insurance claim after a fire, a storm or a theft. Your collection catalog can be one part of it. The goal is simple: if the worst happens, you can show what you had without relying on memory.
The NAIC (National Association of Insurance Commissioners, the group of state insurance regulators) offers a free NAIC Home Inventory app for iPhone and Android. It lets you list belongings room by room, add photos, scan barcodes, and find tips on filing a claim. It's a handy place to hold your general household items alongside a separate collection catalog.
Checked against NAIC Home Inventory app listing on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Many people assume their homeowners or renters policy fully covers a collection. Sometimes it does; sometimes it doesn't. The only way to know is to ask. This chapter gives you the questions; your agent gives you the answers.
Checked against AAA Club Alliance and Insurance.com on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A catalog that exists in only one place can vanish in one moment: a phone dropped in the lake, a computer that won't start, an app that closes, or the same fire that damaged the collection. A backup is simply a second copy, kept somewhere else.
| Copy | Where it lives |
|---|---|
| Copy 1 | The working copy: your spreadsheet or app, where you add new items. |
| Copy 2 | A copy on something else at home, such as a USB flash drive or your computer. |
| Copy 3 | A copy away from home: in an online storage account such as Google Drive, iCloud Drive or OneDrive, or a flash drive with a trusted family member. |
Checked against Discogs Support on November 15, 2026.
Your photos and scanned paperwork matter as much as the list. If they're on your phone, make sure the phone's photo backup is turned on (iCloud Photos on iPhone, or Google Photos backup on Android), and copy the "Collection paperwork" folder to your backup too.
Call Bill and he'll walk you through it — or come do it for you.
Whether you're thinning out the shelves or selling a collection you inherited, your catalog makes it easier. You already know what you have, what condition it's in, and roughly what it's worth. Here's how to sell without getting hurt.
| Option | What to expect |
|---|---|
| Local dealer or shop | A coin shop, card shop, record store or used bookstore. Quick and in person. Expect an offer below retail, since the dealer has to resell it. |
| Online marketplace | Discogs for records, eBay and others for almost anything. Often the best price, but you handle photos, listings, fees, packing and shipping. |
| Auction house | Worth considering for valuable single pieces or whole collections. Ask about the commission and any other fees in writing. |
| Consignment | A dealer sells for you and keeps a share. Get the agreement, the share and the timeline in writing. |
Call Bill and he'll walk you through it — or come do it for you.
Collectors, and families who have just inherited a collection, attract scammers. The tricks change, but they rely on the same few things: hurry, excitement, and money moving the wrong way. Knowing the patterns is the best protection there is.
A "buyer" agrees to your price, then sends a check, a money order or a payment for more than you asked. They apologize and ask you to send back the difference, often by wire, gift card or a payment app, or to pay their "shipper." Weeks later the bank discovers the check was fake and takes the full amount back out of your account. The money you sent is gone.
Checked against FTC Consumer Advice on November 15, 2026.
Checked against International Society of Appraisers on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A catalog does the most good when the right people know it exists. Sharing a copy with a trusted family member means they can help keep it up to date, and they'll have it if they ever need it.
Checked against Google Drive Help on November 15, 2026.
If your catalog is in Excel and stored in OneDrive, the Share button works much the same way. You can also email a copy of the file, or save a version as a PDF (File > Save As or Export, then choose PDF) for someone who just wants to read it.
Call Bill and he'll walk you through it — or come do it for you.
Many collections outlive their collectors. A catalog is one of the kindest things you can leave, because it tells your family what matters, what doesn't, and what you'd like to happen.
Call Bill and he'll walk you through it — or come do it for you.
I've written this guide so you can catalog your collection on your own, at your own pace. But part of being helpful is being honest about when a hand saves time and frustration. Here's my straight advice, with no pressure.
I'm not an appraiser, an insurance agent or a lawyer, and I don't buy or sell collections. I'll help you with the technology and the records, and point you toward the right professional for values, coverage and estates.
I work at your pace — no rushing, no talking down, no jargon. I explain what I'm doing in plain words, and I'll always tell you honestly when something isn't worth the money. Home visits are here in Portage County, Ohio; remote help reaches you wherever you are. I've been doing this work for more than 30 years.
Thank you for taking the time to care for your collection, and for the people who'll one day inherit it. Ten items at a time is plenty.
— Bill
Call Bill and he'll walk you through it — or come do it for you.
Keep a copy of this with your catalog. The whole guide, boiled down.
| Remember | |
|---|---|
| Every item | Number, what it is, identifying details, condition, where kept, how acquired, price, value with source and date, photo, story. |
| Photos | Plain background, soft light, no flash, front and back, close-ups of marks and flaws. |
| Never | Clean a coin, write on an item, or trust an app value without a second look. |
| Records | Discogs: scan the barcode, then match label, catalog number and run-out. |
| Books | Libib, Goodreads, StoryGraph or CLZ Books: scan the ISBN barcode. |
| Coins | PCGS and NGC apps: check the certification number on graded coins. |
| Cards | Collectr, CollX or Ludex to scan; PSA Cert Verification for graded cards. |
| Values | A snapshot from recent sales. Appraise the few pieces that really matter. |
| Insurance | Ask your agent about special limits and listing valuable items separately. |
| Backups | Three copies, two places, one away from home. |
| Overpaid? | It's a scam. Return it, don't ship, never send the difference. |
| Keep handy | |
|---|---|
| Where my catalog is (file or app) | ____________________ |
| App account email | ____________________ |
| Where the backups are | ____________________ |
| Where the paperwork is kept | ____________________ |
| Most valuable items (numbers) | ____________________ |
| Insurance agent (name and phone) | ____________________ |
| Policy number | ____________________ |
| Appraiser or dealer I trust | ____________________ |
| Family member who has a copy | ____________________ |
| Date of last backup | ____________________ |
Call Bill and he'll walk you through it — or come do it for you.
We use cookies only to see which pages help people most. Learn more