Findagrave Hacks

I recently exported the 380+ photo requests for Fernwood Cemetery in Lansdowne, PA and exported them to an Excel spreadsheet so that I could edit and manipulate the data. My goal was to lookup and enter section and lot information for the requests and then sort the spreadsheet to group the requests by section.

There are two tools I came across to assist with this. Both require entering the cemetery ID number, found at the tail end of the cemetery page on Findagrave.com. For instance, Fernwood Cemetery’s url is http://www.findagrave.com/cgi-bin/fg.cgi?page=cr&GRid=128518735&CRid=153990 and the ID # is 153990.

http://www.ajandj.com/fagparse/fgparse.php

http://sents.net/fg/gps

The first site spits out the photo request data that you can copy and paste into excel.

The second site—which is the one I used—gives you access to a bit more data:

Screen shot 2014-10-20 at 8.02.25 PM

Selecting one of the blue numbers for no photo, has photo, or photo requests gives you data that you can copy and paste to excel. Selecting “More Info” brings you to a page with more data about the cemetery’s findagrave statistics and gives you a way to search for a particular name—as well as the very handy date range search (in case you don’t know the name or the name might be misspelled).

Happy hunting!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s