1901 Census Extractor (Download)
This program is a Microsoft Excel spreadsheet which contains a macro
to extract the Page number from the page image and Person ID from
the hyperlinked name. Once this information has been obtained the
data can be sorted on the Page column and Person ID column to establish
families. This can be very useful in identifying family groups. It
can also save on unecessary expense when purchasing the images online
from the GRO. I know from personal experience having located two family
members at the bottom of a page, when I purchased the next page -
I found that the other family members where not there. Extracting
the information in this manner is also useful for One-Name studies.
PC Running Windows 9x, NT, XP. Microsoft Excel
(Version 2000 or above) and a Browser (i.e. Microsoft IE).
the file is a spreadsheet - so no installation
is required. Open the spreadsheet and ensure that Macros are enabled.
Basics - The basic approach is pasting data from
the search results screen of the PRO Census Site onto the 'DATA'
table of the spreadsheet. Once all the data has been pasted press
the extract button on the 'MAIN' sheet. The program should then
extract the relevant information.
Important Note: Some Browsers do not allow
for the pasting of the images into the spreadsheet - so page numbers
will not be extracted. You will still be able to sort on the Person
ID to establish families.
- Open the spreadsheet (ensure macros are enabled)
and click on the 'DATA' sheet to make it visible.
- Enter your search details and press the search
- Once you have the data displayed that you wish
to copy place your mouse over the bottom right hand box (the occupation
field of the last person on the list) hold the left mouse button
down and drag it to the top left hand corner of the data including
the page icons on the left hand side - but not including the title.
Copy the data by pressing [CTRL] & C or selecting copy from
the edit menu.(See
- Select the Spreadsheet and select the 1st free
cell on the 'DATA' sheet.(See
- Paste the data into the spreadsheet by pressing
[CTRL] & V or selecting Paste from the edit menu. (See
Fig.3) (You can also use 'Paste Special' from the Edit
Menu - it must be pasted as HTML.
- If you are going to paste any more data onto
the 'DATA' Sheet - remember to select the 1st cell of the next
- Continue copying and pasting the data onto the
'DATA' Sheet as required.
- When you have all the data you require. On the
spreadsheet select the 'MAIN' sheet and press the Extract Button.
- The data on the 'DATA' sheet will be updated
to include Page and Person ID number.
- The next process is to sort the data. Click
on an entry in the Page Number and Select Sort from the Menu (See
- (Version 2.1 and above) now includes the GuessTimator
Button. After performing the above steps - hitting this button
will guessTimate the Piece and Folio Numbers.
Thats all there is to it. Hope you manage to extract
the data you want and find those missing families. Good Luck.
1901 Census Extractor v2_1c.zip 144 KB (147,456 bytes)
This program is supplied as freeware
please feel free to distribute it. There are no warranties and we
cannot be held responsible for loss of data, malfunction etc. It
is supplied on an as is basis. It may not function correctly with
some Internet Browsers and does not function correctly with Earlier
Version 2_c (04-Sep-2002)
- Fixed problem with folio generation - formula corrected.
- End Numbers set on DATA to high values - correcting overflow