Many families do the hard part first. They gather the recordings, scan the papers, sort the pictures, and make the folders. Then a few months later someone asks a simple question: Where is the photo Grandma identified in that interview? or Which recording mentions the land document? That is the point where organization alone stops being enough.
A simple spreadsheet solves that next problem. It does not replace the archive. It becomes the map to the archive. That matters for families carrying Indigenous continuity, Afro-Indigenous identity, migration, displacement, and historical erasure, because the meaning often lives in the relationships between materials, not only in a single official document. A catalog helps keep those relationships visible.
Free Resource
Free: Start Your Oral History Project
Get our Quick-Start Checklist — 10 steps to your first recorded interview.
No spam. Unsubscribe anytime.
1. Treat the Spreadsheet as the Map, Not the Archive
The spreadsheet is not where you store the original item. It is where you record enough information to find the item, understand it, and connect it to related material later. Think of it as the first finding aid for your family archive.
If you already used a simple folder structure to organize the archive, this is the next step. Folders tell you roughly where something lives. A catalog row tells you what it is, who it involves, how it was identified, and what else belongs with it.
That distinction matters because families often inherit materials in uneven ways. A government record may be sparse or inaccurate. A photograph may only become meaningful after an elder names the people in it. A recording may carry the explanation that the paperwork never did. The catalog is where you keep those connections from disappearing again.
2. Start With One Sheet and a Small Set of Columns
Do not wait for perfect software. Google Sheets, Excel, Airtable, or Numbers can all work. One sheet is enough to begin if the column names are clear and consistent. Most families only need the following:
- Item ID: a unique ID for each row
- Format: photo, document, audio, transcript, video, note
- Title or short label: what the item is in plain language
- Date: exact, approximate, or unknown
- People involved: who appears, speaks, created it, or provided it
- Place: where it was made, found, or discussed
- File location: the folder path or storage location
- Related items: the IDs of connected photos, documents, or recordings
- Notes and access: context, restrictions, and who identified it
That is enough to build a workable catalog. You can always add more later. Starting small is better than building a complicated system nobody in the family will maintain.
3. Give Every Item a Stable ID So the Formats Can Talk to Each Other
The simplest trick in a good catalog is a stable ID. When each item gets a row number or code, you can connect materials without relying on memory. A recording might be AUD-014. A church program mentioned in that interview might be DOC-031. A portrait identified during that same conversation might be PH-052.
Once you have IDs, your spreadsheet can say Related items: AUD-014, DOC-031 on the photo row and Related items: PH-052 on the audio row. Now another relative does not have to guess which file goes with which story.
This works especially well after building one interview into one archive unit. The interview becomes one anchor item, and the catalog lets the related materials branch outward in a way that stays visible over time.
4. Capture the Minimum Context That Future Relatives Will Not Know
A row should do more than label a file. It should preserve the piece of knowledge most likely to disappear if the current keeper is not there to explain it. That may be the nickname attached to a formal name, the family branch a person belongs to, the fact that the date is approximate, or the note that a place has both a government name and a community name.
For example, instead of writing only Portrait of Sarah Carter, write something closer to Sarah "Sadie" Carter, probably 1940s, identified by Lillie Carter during interview AUD-014, taken near Albany, Georgia. That extra sentence is often the difference between a meaningful family record and an unlabeled image with a guessed name.
If you are using the Thronateeska evidence framework, this is also a good place to note whether something is Documented, Strongly Supported, or Oral Testimony. The point is not to make family memory smaller. It is to record what kind of knowledge you are holding so later researchers understand the strength and shape of the evidence.
5. Use the Spreadsheet to Track Relationships, Not Just Objects
The real value of one spreadsheet is that it lets you see the whole record around a story. A land paper is not just a document. It may relate to a recording about migration, a cemetery photo, a church membership list, and a family story about who left and who stayed.
Use the notes or related-items columns to track those links directly. Write down when a photo was identified during an interview. Note when a document contradicts a remembered date. Mark when a file should stay within the family or should not circulate beyond a tribal or community context. A catalog is also where access ethics become practical.
If your archive includes multiple formats already, pair this work with the guide to storing photos, documents, and recordings together. Storage keeps the files side by side. Cataloging makes their relationships legible.
6. Update the Catalog in Small Batches So It Stays Alive
A family catalog does not need to be finished before it becomes useful. Add rows in small batches: after one interview, after one box of scanned photos, after one afternoon of sorting documents. Progress compounds. Waiting for a perfect archive day usually means the spreadsheet never gets made.
Build one short maintenance habit: whenever you create a new file or identify an old one, update the row at the same time. Then review the sheet as if you were a younger relative opening it for the first time. Could they tell what an item is, why it matters, and where to find it? If not, the fix is usually one better note, one clearer ID, or one missing link to a related item.
Cataloging is how organized material becomes usable memory. It is a quiet form of ancestral continuity: not only keeping the record, but keeping the path back to it open for the people who come after you.
Build a catalog your family can actually keep using
The Oral History Documentation Guide ($19.99) helps you standardize item IDs, notes, permissions, evidence labeling, and retrieval habits so your archive is not just stored, but legible over time.
If you are still building the raw material, the Family Oral History Workbook ($14.99) gives you interview logs, prompts, and record sheets that make cataloging much easier once the files start to grow. Educators building student or community collections may also find the Ancestral Continuity Educator Kit useful once the family workflow is established.
The Thronateeska Historical Continuity Project is a public education initiative focused on Indigenous continuity, Afro-Indigenous identity, oral history traditions, historical erasure, and ancestral continuity. A family record becomes more durable when people can still find the story inside it.
More from this project
- How to Label Family History Sources So Future Relatives Can Trust the File
A practical guide to labeling family history sources with provenance, context, and certainty so future relatives know what is documented, inferred, or still unresolved.
- How to Build a Family Timeline From Photos, Documents, and Oral History
A practical guide to building a family timeline from photos, documents, and oral history so names, moves, and major events fall into sequence without false certainty.
- How to Identify People in Old Family Photos Before the Names Are Lost
A practical guide to identifying people in old family photos, asking elders better questions, and recording uncertainty without pretending a guess is a fact.
- How to Organize a Family Archive So It Stays Usable
A practical guide to organizing recordings, notes, photos, and documents so a family archive stays findable, understandable, and usable over time.
- How to Turn One Family Interview Into a Lasting Archive
A practical guide to turning one recorded family interview into a lasting archive with file structure, naming conventions, captions, backups, and connected photos and documents.
- How to Store Family Photos and Documents Alongside Your Oral History Recordings
A practical guide to storing family photos, documents, and oral history recordings together — physical and digital — so the stories stay connected across generations.