HELP - EXTRACT - ANCESTRY

*Use CHROME or EDGE internet browsers for best results.

This workbook allows you to extract the data from any Ancestry.com record that allows you to view the image and has an index pane.

To extract the index data from a record you should do the following:

1. Set the source option to "ANCESTRY".

To change the source you can click on the green SOURCE button (A). The paste option should automatically update to the source selected as well.

*Any existing data is erased when you change the source.

2. Open the Ancestry.com image view for the record you want to extract.

*Use Chrome or Edge internet browsers.

3. Make sure the collection details (A) and index pane (B) are visible on the page(s) you want to extract.

The collection details appearance depends on the window size. Click on the index icon (C) to display/hide the index panel. 

*If the index option is not available then this record can not be extracted.

4. Select the entire page using the keyboard shortcut "CTRL+A" (Windows) or "COMMAND+A" (Mac).

5. With the entire page selected then use the keyboard shortcut "CTRL+C" (Windows) or "COMMAND+C" (Mac) to copy the data.

6. In the Extract Excel workbook then click on PASTE (A). 

The summary cells (B) should update automatically to reflect the information added. Do NOT edit these cells manually.

The description cells (C) will populate when the first image is added. This is not an exact science so you CAN edit these cells as you wish.

A quick popup window (D) will display to let you know the image was added. This window should go away on it's own after a few seconds.

All the data from the index pane will be added to the table (E).

7. On Ancestry, navigate to the next image page you want to extract using the arrows (A) or by entering a page number (B).

*You can add image pages in any order.

8. Repeat steps 3-7 for as many image pages as you wish.

*Usually the data remains highlighted when going to the next page so you can skip the select all step when that happens.