1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. If you're looking for the LostCousins site please click the logo in the top left corner - these forums are for existing LostCousins members only.
  3. This is the LostCousins Forum. If you were looking for the LostCousins website simply click the logo at the top left.
  4. Coronavirus Corner - a place to share your hopes, dreams, and frustrations.
  5. Only registered members can see all the forums - if you've received an invitation to join (it'll be on your My Summary page) please register NOW!

Copying your ancestors to a spreadsheet

Discussion in 'Useful features you may have missed.....' started by peter, May 17, 2015.

  1. Bob Spiers

    Bob Spiers LostCousins Superstar

    I presume you mean as displayed in Ancestry format...Icon/User Name/cousin relationship/Tree information/view match ...in which case I would think copying as such would not allow for isolating the user name to allow an Excel Custom Sort. (But could be wrong of course).

    If you do not mind a little more work you can achieve a CHEAT form of searching within a Spreadsheet by using the 'web capture' facility in Ancestry. (Make sure you have an Excel blank page open with at least one column wide enough to paste the captured item). Then FOR EACH item you wish to transfer to the spreadsheet, do the following:

    In Ancestry: right click to the left of the selected outline box and from the list select 'web capture'. Then 'Free Select' (which will require you to drag the mouse to 'white out' the item) then 'Copy'.
    In Excel: Select 'Paste'. (You can use the tried and trusted Ctrl C and Ctrl V if you prefer). The single item will now show in Excel as it does in Ancestry.

    NOW DO THE SAME FOR EACH ITEM YOU WISH TO TRANSFER TO THE SPREADSHEET. YOU CAN CAN CHANGE THE ORDER AT WHICH THEY APPEAR IN THE SPREADSHEET EACH TIME IF YOU WISH, OR JUST LAYER THEN AS IN ANCESTRY, AND SORT WHEN YOU HAVE TRANSFERRED ALL THE ITEMS.

    To MANUALLY REPOSITION left click in a blank area and holding the mouse button, move to its chosen USER NAME position.

    Simples!

    (Mind you it may not be what you seek, but it is the only way I can think of for allowing Ancestry DNA matches to be sorted, unless Phil or he/she of similar genius, (meant sincerely) can come up with a better solution)
     
  2. Tim

    Tim Moderator Staff Member

    Web Capture? Is that an Edge only feature?
     
  3. peter

    peter Administrator Staff Member

    My brain hurts.....
     
  4. canadianbeth

    canadianbeth LostCousins Member

    Mine too. I did the right click and did not see "web capture"
     
  5. At home in NZ

    At home in NZ LostCousins Star

    So would mine, I bet you're sorry you asked.
     
  6. Bob Spiers

    Bob Spiers LostCousins Superstar

    I admit to using Edge on most of my devices, and yes, on the one I used to check out my Ancestry DNA. I use Opera on two, and have Chrome in the reserve on another. It is certainly a feature of Edge and just before this post checked in Opera, and the 'web capture' DOES NOT show. I have yet to check Chrome, but given the responses of a 'no show' by others; then by deduction it must be a feature of Edge. (Thereby boosting my claim in the recent past that Edge is the superior browser and not just in this one instance).

    Sorry about that folks and it makes a change to hear Peter and others saying their brain hurts, which is my usual reaction to a post by you know who. Why not use Edge (it is there in the wings for all) and discover one of its many useful features?
     
    Last edited: Mar 31, 2021
  7. Bob Spiers

    Bob Spiers LostCousins Superstar

    Tried to show the 'web capture' as it appears in Edge, but as it only appears with a right click and disappears the moment I try to use the snipping tool, I decided to photo it and show it that way. So here it is:
    web capture.JPG
    and before you try to use the Ctrl+Shift+S other than in Edge, sorry that will not work either.
     
  8. Bob Spiers

    Bob Spiers LostCousins Superstar

    Just followed through with your own solution Tim, and yes it does work as you describe and does allow a more proprietary Excel filter sort, providing you can endure the effort to copy each item manually. But no reward without effort hey?
     
  9. Bob Spiers

    Bob Spiers LostCousins Superstar

    For those who could not fathom what I meant in using 'web capture' here is a simple 3 line example. Above an exact copy as it appeared in Ancestry DNA Matches (ABC added by me). Below, when manually 'moved' (BAC) to correspond with the User's first name. It could, of course be moved to correspond with surname or any other criteria to suit.
    upload_2021-3-31_11-19-17.png

    Of course to provide an example showing both before and after events, I actualy copied and pasted, rather than simply moving.
     
  10. Alexander Bisset

    Alexander Bisset Administrator Staff Member

    It only shows you that text in the tooltip so you just need to know the icon. This is the menu you get when you right click on an Excel cell having copied data from a website - eg: My Ancestors page.

    upload_2021-3-31_17-45-1.png
     
    Last edited: Apr 3, 2021
  11. peter

    peter Administrator Staff Member

    Thanks, Alexander - something I can understand at last!
     
  12. Tim

    Tim Moderator Staff Member

    Hi Peter, I found this and it does exactly what you want.

    Download Ancestry DNA There is a video here that explains it all and it looks like it works. It's an automated way of doing what I did manually. Let me know it it works for you.
     
  13. Bob Spiers

    Bob Spiers LostCousins Superstar

    Looks interesting Tim and I too will check it out when I have time. Not sure about introducing a Google Spreadsheet into my own Office orientated setup, but looks as though the programming and macros are tied to Google. I could only take a minute of the Video mind, to American brash (and a little more diluted Canadian) for me but seems to be well explained and I take my hat off to the Canadian who masterminded it all.
     
  14. Tim

    Tim Moderator Staff Member

    I haven't tried it, but he did demonstrate a way to save it as an .xlsx file.
     
  15. Bob Spiers

    Bob Spiers LostCousins Superstar

    Had a quick try out and transferring to an Excel spreadsheet by simple Copy/Paste is covered in the instructions and works fine as a copy of the DNA sheet. You need to revert back to the Google Spreadsheet of course for additional actions, but can save those again in in a different tab. Still work in progress at the moment until I get the hang of things.
     
    • Thanks! Thanks! x 1

Share This Page