Announcement

Collapse
No announcement yet.

Transcribing FMP census data - a lockdown gift.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Transcribing FMP census data - a lockdown gift.

    Scottish census images are expensive on ScotlandsPeople, but FMP have transcribed 1841-1901. That's great, but it's tiresome to re-type their efforts.

    I've constructed a spreadsheet into which you can paste UK census data from FMP, and it converts it into text which can be quickly copied and pasted into your FH software, rather than having to laboriously re-transcribe it.
    If anyone's interested then I've added it to my website (see the link below - go into Genealogical Articles), and I can give guidance if you need it.

    The basic way to use it is:
    1) highlight and copy the text from FMP
    2) select cell B7 and paste.
    3) change the order of the columns to the desired order by changing the order of 1-7 in the green cells.
    4) change the acknowledgement to what you wish in cell J1
    5) standardise placenames from cell J24 downwards
    6) select and copy the yellow cells as far down as you need
    7) paste the result into your FH software.

    Hopefully it's helpful to someone when most of us have more time on our hands.

    William
    Kind regards,
    William
    Current focus of research: The Macleods of Lewis, especially those of the Point district.
    Of particular interest are Macleod families with men by the name of Torquil.
    Please see my user page for more detail...and pm me if we might share research!

    #2
    Bear with me while I sort the link!
    Now done!
    Kind regards,
    William
    Current focus of research: The Macleods of Lewis, especially those of the Point district.
    Of particular interest are Macleod families with men by the name of Torquil.
    Please see my user page for more detail...and pm me if we might share research!

    Comment

    Working...
    X