Organizing Your Genealogy Contacts

I was chatting with a friend and fellow genealogist when I typed, “I really should make a spreadsheet of all my contacts with people for the different families.” Her response, “That’s a great idea!!” Then she encouraged me to write an article about that, so here it is, and the spreadsheet has begun. I doubt this is a novel topic, but this is my idea.

If you’re like me, you have kept every single genealogy contact email, 23andMe message, MyHeritage message, and Ancestry message you’ve ever received, as well as written letters of yore. Sometimes when I go back and look for something, I’m reminded of a ball I dropped. Oops!

Don’t worry if you don’t have a spreadsheet program. I use Libre Office. It’s stable and free, available for several platforms, including Mac and Windows, and can import from as well as export to other spreadsheet formats such as MS Word.

This spreadsheet can be as simple or as complicated as you wish to make it. I’m better at starting out simple. Initially, I am including the family name(s), contact name, email address or other method of contact, where I received the contact (23andMe, which of my email addresses, a blog comment, etc.), and possibly the first and most recent times we communicated. I also may want to (and probably should) specify where paper contact documents are stored in my files.

Here is a screenshot showing some fake examples.

Copyright Notice: You do not have permission to download or copy this image without obtaining it from me. Thank you.

I hope this idea can help you to keep track of your genealogy contacts. It is helping me to get organized with them!



This entry was posted in General and tagged . Bookmark the permalink.

1 Response to Organizing Your Genealogy Contacts

  1. This is a good idea and something I should definitely consider. I have started a message to someone “new” only to realise we’ve communicated in the past.

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.