Organizing

How to Catalog a Postcard Collection: A Spreadsheet System That Lasts

Every collection reaches a point where memory stops working. You buy a card you already have, you cannot find the view a historian asked about, or you realize nobody else in the family could make sense of the boxes. A catalog fixes all three, and it does not need special software. A plain spreadsheet, a consistent numbering scheme and a few good habits will carry a collection of a few hundred cards or many thousands.

This guide gives you a system you can start this weekend: an ID scheme, the columns worth recording, how to tie scans to records, and how to file the physical cards so the catalog and the boxes always agree.

Why catalog at all

Stop buying duplicates. Check your list on your phone before you bid.
Find cards fast. A location column turns "somewhere in the blue boxes" into "Box 3, Courthouses."
Research better. Sorting by publisher or era shows patterns you would never notice by flipping through.
Protect the collection's meaning. Notes about where a card came from or what you learned are easy to lose and hard to reconstruct.
Help your heirs or a buyer. A clear list is far more useful than boxes of unlabelled cards. If you are the heir, see inherited a postcard collection?

Choose an ID scheme

The ID is the link between the physical card, its row in the spreadsheet, and its scan files. Keep it simple and permanent.

Scheme	Example	Good for
Running number	0001, 0002, 0003	Any collection; simplest and most robust
Prefix + number	OH-0001, RPPC-0001	Collections split into clear sections
Acquisition + number	A12-007 (lot 12, card 7)	Collectors who buy many lots and want provenance

Whatever you choose, never reuse an ID, even if you sell the card. Mark it "sold" in a status column instead. Write the ID in soft pencil on the outside of the sleeve or on an archival slip behind the card. Do not write on the card itself, and do not use stickers or ink on the card.

The columns that matter

Resist the temptation to record everything. A catalog with too many columns is a catalog you stop updating. Start with the core set and add only what you will actually use.

Core columns

ID: your unique number.
Place: town, county, state, country. Use separate columns so you can sort.
Subject: courthouse, depot, main street, Halloween, ship, and so on. Use a consistent word list.
Caption: exactly as printed or written on the card.
Type: RPPC, litho, collotype, white border, linen, chrome, and so on.
Era range: earliest and latest likely years in two columns, plus a short note on the evidence.
Publisher / number: publisher name and any series or production number.
Postal use: unused, or postmark town and date.
Condition: a short grade plus notes, using consistent words. See our condition guide.
Location: box and section, or album and page.

Useful extras

Stamp box (for RPPCs), stamp present or removed, artist signature.
Acquisition: date, source, and what you paid (private to you).
Research notes and sources.
Status: in collection, sold, traded, donated.
Scan filenames, if you do not use the ID-based naming below.

Recording dates honestly

Use two columns for the era: earliest and latest. A golden-age divided back with a 1911 postmark might read "1907 / 1911" with the note "DB back; PM 1911." A linen with no postmark might read "1930 / 1945" with the note "linen texture; commonly cited range." This keeps you honest about uncertainty and lets you sort by date without pretending to precision. Our guides to postcard eras and mailing vs printing dates explain the reasoning.

Keep a controlled word list

The fastest way to wreck a catalog is inconsistent wording. "RR depot," "train station," "railroad station" and "depot" will scatter one subject across four groups. Pick one term for each idea and write your list on a second sheet in the same file. Spreadsheet programs let you turn that list into a drop-down menu for the subject and type columns, which keeps entries consistent.

Subjects

Depot, Courthouse, Main Street, School, Church, Hotel, Bridge, Park, Industry, Disaster, Holiday.

Types

PMC, UDB, DB litho, RPPC, White border, Linen, Chrome, Continental chrome.

Condition

NM, EX, VG, G, F, P, plus notes like "crease thru image," "album marks."

Status

Collection, For trade, Sold, Donated.

Scanning and file naming

Scans make the catalog visual and let you share cards without handling them. Scan both sides. Use the ID as the start of every filename:

0001_front.jpg and 0001_back.jpg
Keep a high-resolution master (for example TIFF or high-quality JPEG) and make smaller copies for sharing.
Keep all scans in one folder, or folders that mirror your boxes.
Back up to at least two places, such as an external drive and a cloud service.

For scanner settings and handling, see our full guide on how to scan vintage postcards.

Filing the physical cards

Your catalog and your boxes should follow the same logic. Most collectors file by their main focus: by place (state, county, town), then by subject, then by ID or date. Use archival dividers labelled to match the spreadsheet's location column.

Sleeve the card.
Write the ID on the sleeve in pencil.
Enter the row in the spreadsheet.
Scan front and back with ID-based filenames.
File it in the box and section written in the location column.

Filing supplies:

Postcard boxes and dividers on Amazon Archival dividers on Amazon

A sustainable workflow

Most catalogs fail because they start as a huge project. Make it a habit instead.

Catalog every new purchase on the day it arrives, before filing it.
Work through the backlog in batches of twenty or so cards.
Start the backlog with your best or most researched cards, not the commons.
For big lots of commons, catalog at the group level ("Box 7: 200 unsorted chrome views, various states") and refine later.
Review your word list every few months and merge near-duplicates.

Using the catalog to buy smarter

Sort your spreadsheet by place and subject to see your gaps: the courthouse you lack, the era your town is missing, the publisher number between two you own. That becomes your want list. Turn it into saved searches and check completed sales before you bid, as described in our guide to eBay sold listings.

Fill the gaps:

Courthouse RPPCs Real photo depot cards Sold linen courthouse cards

The bottom line

Verdict: A permanent ID, about ten consistent columns, ID-based scan filenames and boxes that match the location column are all most collectors need. Start with new purchases, chip away at the backlog in small batches, and the catalog will quietly become the most useful tool in your collection.

FAQ: What is the best software to catalog postcards? :: A general spreadsheet program works well for most collectors and keeps your data portable. Dedicated collection software exists, but a spreadsheet with consistent columns and an ID system is enough for most collections. FAQ: Should I write a number on my postcards? :: Not on the card itself. Write the ID in soft pencil on the sleeve or on an archival slip stored with the card. Avoid ink and stickers on the card. FAQ: What information should a postcard inventory include? :: At minimum: a unique ID, place, subject, caption, card type, an era range, publisher, postal use, condition and storage location. Add acquisition and research notes if you will use them. FAQ: How do I catalog a very large postcard collection? :: Catalog new purchases immediately, then work through the backlog in small batches. Large groups of common cards can be recorded at the box level first and itemized later. FAQ: Should I scan every postcard? :: Scanning both sides is very useful for research, sharing and insurance records, and it reduces handling. Name each file with the card's ID so scans and records always match.