It was a chance remark that it was easy to use Excel to transcribe marriage certificate data by someone at the monthly meeting of our family history group that gave me the idea.
Family history is largely built on birth marriage and death data, and in the process of building family trees you inevitably end up with a large pile of scanned documents all of which tend to have similar incomprehensible machine generated names.
But, if you look at England and Wales marriage certificates they are all structured similarly - for example here's the one for George Wardle and Madeleine Smith
and Ethel Voynich's marriage certificate 40 years later has the same structure
and J and I got married in York in England, the header on our marriage certificate is essentially the same as that of Madeleine Smith's a 141 years earlier
which is quite an amazing example of format longevity!
In fact the basic format of an England and Wales marriage certificate looks like this
And from this we can extract the following information
- When they got married
- Where they got married
- What they did for a living
- How old they were
- Where they were living prior to being married
- Who their father was
- What their father did for a living
It's not quite perfect of course - on Madeleine Smith's marriage certificate, the ages of both parties were given as full age, which probably meant that both were over 21 and did not require parental consent.
Likewise, on Ethel Voynich's marriage certificate her profession is left blank, despite being listed as a novelist/author in the census the year before.
However, it's fairly easy to see how this could be transcribed to a spreadsheet
Because I do a lot of my family history work on a pair of Linux computers, I used Libre Office Calc to create the spreadsheet.
Rather than have one line per person, I decided to have one line per event which makes it slightly unwieldy, but means that we have the data captured on a single line including the source filename.
Scotland, of course, does things slightly differently.
Technically there are no marriage certificates, only extracts from the register, which you can request to have printed and certified by the government as a true copy.
When you search Scotland's People, the government genealogy website, what you get is a scanned page from the register as in this copy of the registration information for the marriage of James Mathieson, my grandfather on my mother's side to his first wife Catherine Gracie, who later died of tuberculosis
However the data is basically the same as you get from the England and Wales marriage certificate, even if it is structured a little differently
The major difference being that the Scottish register also records the mother's maiden name
This gives me a spreadsheet with the following columns
- date
- where they were married
- party 1 name
- party 1 age
- party 1 condition - ie had they been previously married
- party 1 profession
- party 1 address
- party 1 father's name
- party 1 father's profession
- party 1 mother's maiden name
- party 2 name
- party 2 age
- party 2 condition - ie had they been previously married
- party 2 profession
- party 2 address
- party 2 father's name
- party 2 father's profession
- party 2 mother's maiden name
- witness 1 name
- witness 2 name
- source document
and of course because this is a reference document rather than a word for word transcription, it's perfectly possible to add in extra information from other sources, as I have done to add in Ethel Voynich's mother's name from her birth certificate.
I've opted for the more neutral 'party 1' and 'party 2' rather than 'husband' and 'wife' as you get cases of
marriage by declaration in Scotland where people never actually formally married but conducted themselves as if they were - one of the most dramatic examples being the
Yelverton case - and of course various other informal unions from which it's possible to create a pseudo marriage record from death certificates and children's birth certificates.
There are two major advantages to creating a master spreadsheet like this - firstly it's searchable. Given the lack of imagination of my forebears as regards names, my ancestry is stuffed full of James, Johns, Catherines, Madeleines and Isobels, it forms an aid to working out who is who. The north east Scottish tradition of giving the first born child the mother's maiden name as a middle name can be incredibly useful for separating out which James was which.
Secondly it's relatively easy to separate out information to create little index card like files. As a proponent of self documenting file structures I like to keep the information for each person in a directory named for them. Adding in a little 'about' file and an index file helps improve manageability.
If you'd like to take a look at my
draft master index file, please do so. It's in Libre Office ODS format, but if you prefer to use Excel you should be able to open directly especially as there's no clever formatting or macros.