Tweet
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
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
Comment