I want to do something you haven’t considered before, but a trick genealogists use, to glean clues for their research.
I want to do a select all on a census index, copy, and then do a paste special into LibreCalc while keeping the original column format including fields that weren’t filled in.
I’ve seen them do it on YT videos using Google Sheets (I couldn’t get it to work on Google Sheets and I already have this suite). All they had to do is copy from the census page, paste special - keep formatting into the spreadsheet. Then you delete a few extraneous lines and you’re are on to the next page. The question is, how to paste it properly in LibreCalc?
sample census: https://www.ancestry.com/imageviewer/collections/8054/images/4204703_00405?pId=19599562
It should be able to be viewed without an account.
The index is on a horizontal bar along the bottom of the page. Just click inside that, select all and copy.
I am entering the data cell by cell right now. There has got to be a better way. All I get is one column of text, instead of 8-16.