Use the left and right arrows to go back and forth across the rows.
1 Used Outwit Hub to search 1901 census for Spierin variants and scraped data by using Page, Data, Tables and copying output into Excel spreadsheet
2 Searches included: Spear* 239, Speer* 756 (no Speeri or Speern, so none included here), Speir* 57, Sper* 31, Spier* 245, Spir* 72
3 numbered rows 1-658 in Column A (to allow order of rows to be returned to original after sorting)
4 copied & pasted Raw data into new worksheet, tidied data up to only include those obvious Spearin variants = Master worksheet
5 copied & pasted Master data into new worksheet, deleted non-essential rows & columns (C), moved URL (D) to end, and added extra columns for Family ID, Personal ID, Fathers ID, and Notes = Working worksheet
6 sorted data by County, then Townland Street, then Age (largest to smallest) so that family groups are easily identified
7 renumbered Column B (ID no.)
8 searched Raw for any possible Spearin deviants (transcription errors) based on locations - not done yet
9 formatted table with banded rows in green - highlighted text and changed to black
10 turned off Filter function (icon looks like funnel, under Data) to remove dropdown arrows from each column
11 copied & pasted Working (B2 to V72) into Google spreadsheet at https://docs.google.com/spreadsheets/d/1AGvvOrKHL6c9exRRDU9TVfkDTa2GgEusNK7jjxSEF34/edit#gid=0VE/edit#gid=0
12 named it Ireland Census 1901 - named worksheet: Spearin variants
13 Justified all columns
14 on Google, clicked File, Publish to the Web, Embed, Publish ... and the following code comes up: <iframe src="https://docs.google.com/spreadsheets/d/1AGvvOrKHL6c9exRRDU9TVfkDTa2GgEusNK7jjxSEF34/pubhtml?widget=true&headers=false"></iframe>
15 launched SSP editor and created new page for these records under the Records subdirectory
16 specified table dimensions as per html text to suit height & width (1 row = 22.06 pixels)
