Research & Correspondence Log Template
Research & Correspondence Log Template
Organize genealogy research tasks, sources checked, search results, cousin correspondence, research hypotheses, and next steps in one structured research log.
Preview of the Research & Correspondence Log spreadsheet.
Genealogy research can easily become repetitive. Without a record of what you already searched, which sources you checked, and what you found, it is easy to revisit the same database or repeat the same research months later.
A research log creates a searchable record of your work. It helps you remember what has already been investigated while making it easier to decide what to try next.
What Is the Research & Correspondence Log?
This spreadsheet is a central research workspace for documenting genealogy investigations over time. Instead of keeping research notes scattered across notebooks, browser bookmarks, emails, and individual family-tree profiles, you can record important research activity in one consistent format.
The template combines traditional genealogy research with DNA-related correspondence, making it useful for both documentary research and genetic genealogy projects.
Who Is This Template For?
This template is useful for beginners who want to develop good research habits, experienced genealogists managing multiple research questions, DNA researchers communicating with matches, and anyone working on long-running or complex family-history projects.
Why Document Both Positive and Negative Searches?
Positive Findings
Record documents, database entries, family trees, DNA information, photographs, or other evidence that may contribute to your research question. Include enough detail to help you locate and evaluate the source again later.
Negative Searches
Record searches that did not produce the expected result, including the database, search terms, date range, location, and other parameters used. A documented negative search helps you avoid repeating the same search without remembering what was already checked.
How a Research Log Can Improve Your Genealogy Workflow
- Reduce duplicated research by recording which databases, archives, parish registers, and other sources you have already checked.
- Preserve research context by recording the exact search terms, dates, locations, and filters used.
- Track unresolved questions so brick walls become defined research problems rather than vague notes.
- Manage correspondence with DNA matches, cousins, researchers, archives, and other contacts.
- Maintain continuity when you return to a project weeks, months, or even years later.
- Make your reasoning visible by connecting observations, hypotheses, evidence, and planned next steps.
Pre-Formatted Columns Included
The spreadsheet is organized around the information that is most useful when documenting an ongoing genealogy investigation.
- Date of Task / Contact — Record when the research activity or correspondence took place.
- Ancestor / Line Under Investigation — Identify the person, couple, family line, or research question involved.
- Source / Repository Checked — Record the archive, database, website, parish register, census, collection, or other source consulted.
- Search Parameters Used — Document names, dates, locations, spelling variations, filters, and other search criteria.
- Results Found — Summarize the relevant information discovered or note that the search produced no useful result.
- Contact Person / Cousin Match Name — Record the person involved in correspondence or DNA-match research.
- Correspondence Status & Follow-Up Date — Track unanswered messages, replies received, and planned follow-ups.
- Research Hypothesis & Next Action Steps — Record what you currently think may be happening and what you plan to investigate next.
Best Use Cases for This Template
- Logging searches across online genealogy databases and digital archives.
- Documenting parish, census, civil-registration, probate, land, and other traditional genealogy research.
- Recording searches that produced no useful result so they are not unnecessarily repeated.
- Tracking messages and replies from DNA matches and extended relatives.
- Managing brick-wall research with defined questions and next steps.
- Keeping research organized when several ancestral lines are being investigated simultaneously.
- Creating a research history that can be reviewed when new evidence changes your working hypothesis.
Important: A Research Log Is a Record of Your Research, Not Proof
Recording a source, search result, or research hypothesis does not make the underlying conclusion correct. The log is designed to preserve the research process so that evidence can be reviewed and evaluated later.
When possible, record the original source, citation or URL, repository, collection, and enough search information for another researcher — or your future self — to understand what was checked.
For negative searches, document the exact search conditions rather than treating the absence of a result as proof that a person or record does not exist.
Step-by-Step Research Workflow
Start by identifying the ancestor, family line, DNA match, or historical question you are investigating.
Note the database or repository, search terms, dates, locations, spelling variations, and other relevant filters.
Record the useful findings as well as searches that did not produce the expected result.
Add source details, document references, URLs, notes, or other information that will help you revisit the finding.
Add DNA matches, cousins, researchers, archives, or other contacts and record when messages were sent or received.
Turn the research result into a specific next step, such as checking another collection, contacting a relative, or testing a different hypothesis.
Check previous searches and correspondence first so that you build on existing work instead of unintentionally repeating it.
Use the Log to Turn a Brick Wall Into a Research Plan
A brick wall often feels difficult because the research question is too broad. A research log can help break the problem into smaller, trackable questions.
- What is the last documented record for this ancestor?
- Which repositories and record collections have already been searched?
- Which name variations or geographic locations have been tested?
- Which relatives or DNA matches could provide additional evidence?
- Which assumptions in the current working hypothesis still need to be tested?
Recording these questions alongside your research activity makes it easier to see gaps in the investigation and choose a logical next step.
Keep DNA Match Correspondence Organized
DNA genealogy often involves contacting people who may have information about shared ancestors, family branches, surnames, locations, or photographs. Important conversations can quickly become difficult to track when they are spread across several testing companies or email accounts.
Use the correspondence fields to record who you contacted, when you contacted them, the purpose of the message, whether they responded, and what follow-up is needed.
A research log becomes much more useful when it includes future actions. Instead of writing only "contacted cousin," record what you are waiting for and when you want to review the conversation again.
There is no universal follow-up period. Choose a reasonable interval for the type of contact and situation, and record it in the spreadsheet so the task does not disappear from your research workflow.
Frequently Asked Questions
What is a genealogy research log?
A genealogy research log is a record of the searches, sources, findings, questions, and next steps associated with a family history investigation.
Why should I record negative genealogy searches?
Negative searches help you remember which sources and search conditions have already been checked. They can prevent repeated work and may also reveal which research strategies should be changed.
Does a negative search prove that a record does not exist?
No. A negative search only documents that the expected result was not found under the conditions used. Records may be incomplete, indexed differently, unavailable online, or held in another collection.
Can I use this template for DNA genealogy?
Yes. You can use it to document DNA-match correspondence, research hypotheses, shared-family questions, follow-ups, and the traditional genealogy research connected to DNA evidence.
Can I track correspondence with DNA matches?
Yes. The template includes fields for contact names, correspondence status, dates, and follow-up actions.
How often should I update my research log?
Ideally, update it during or immediately after each significant research session. Consistent recording makes the log much more useful when you return to a project later.
Can I use the template for multiple family lines?
Yes. The ancestor or line field allows you to distinguish different research projects and ancestral branches within the same workbook.
Is this template suitable for beginners?
Yes. A research log is useful from the beginning of your genealogy journey because it encourages reproducible, organized research habits before projects become difficult to manage.
Ready to Organize Your Genealogy Research?
Download the free Research & Correspondence Log and keep your searches, sources, correspondence, hypotheses, and next steps organized in one place.
📥 Download the Free TemplateDNA Academy - Quick Answers
What formats are your free templates available in?
Our templates are available as downloadable Excel/Google Sheets files (for digital tracking).
How do I use a research log effectively?
A research log helps you track which records you’ve searched, what you found, and what’s still missing. We recommend filling it out as you go, it prevents duplicate searches and helps you identify patterns. Our template includes columns for date, source, location, and findings.
Are the templates available in languages other than English?
Currently, our templates are in English only. We are exploring translations into Swedish, Spanish, and German based on user requests. If you need a specific language, contact us and we’ll prioritize it.