General Chat

Top tip - using the Genes Reunited community

Welcome to the Genes Reunited community boards!

  • The Genes Reunited community is made up of millions of people with similar interests. Discover your family history and make life long friends along the way.
  • You will find a close knit but welcoming group of keen genealogists all prepared to offer advice and help to new members.
  • And it's not all serious business. The boards are often a place to relax and be entertained by all kinds of subjects.
  • The Genes community will go out of their way to help you, so don’t be shy about asking for help.

Boards

Quick Search

Single word search

Tools

Findmypast DNA Banner

Icons

  • New posts
  • No new posts
  • Thread closed
  • Stickied, new posts
  • Stickied, no new posts

Dumping family tree data to spreadsheet eg Excel?

Login to Add Reply Watch This
ProfilePosted byOptionsPost Date

George

George Report 29 Jul 2014 12:05

I am looking for a way to dump or extract the key data in my Genes Reunited tree, into a format where I can sort it in a file like Microsoft Excel.
Is this possible?
I don't seem to be able to print everything in the "List" view - instead only the visible records get printed (eg the first ~ 23 records).

The "Export GEDCOM" utility only seems to give me a file to import into another Family Tree program - which is not the intent.

I want to be able to look and sort all the records I have (and perhaps add columns in Excel) so I can be more selective when I do the graveyard visits.
Any help or advice appreciated.

Researching:
Allan, Bremner, Doull, Forbes, Mackenzie, Mackie, Geddes, Caithness & Sutherland

OneFootInTheGrave

OneFootInTheGrave Report 29 Jul 2014 13:11

George - have a look here, other members may also come up with suggestions.

http://www.bing.com/search?q=GEDCOM+to+Excel+Database&FORM=QSRE5

Researching:
I am researching the Wotherspoon family from the Old/New Monkland areas of Scotland, some moved to the Leslie and Kelty areas of Fife and I'm having problems linking the Wotherspoon's from Leslie and the Wotherspoon's from Kelty. I am also researching the Clusker family from Co. Meath in Ireland who moved to West Lothian and from there to Fife............"Vita non est vivere sed valere vita est"

RolloTheRed

RolloTheRed Report 29 Jul 2014 13:55

if you google on "import gedcom into excel" you will find lots of free programs. I use this one mostly

http://www.oxy-gen-soft.net/charger_en.php

The GEDCOM files exported from GRU do NOT included pictures, notes or the contents of any attached records. There are also bugs mostly related to dates. The current incarnation of the tree is such a tired and time consuming old bird I don't think many people use it any more. With GRU it is not possible to merge a GEDCOM file with the current file - on import everything current just vanishes. The import facility is buggy too.

By far the best format for storing family tree ( or any other hierarchical data ) is XML. Microsoft have a very nice ( free ) family tree program in their archive with super graphics which uses XML and integrates with XL & Access. It can import GEDCOM.

The FH industry is close to moving on from GEDCOM to XML. However 2 years ago at the Genes conference where GRU and Phil Moire were supposed to be star players FamilySearch got in a sulk and killed the move. It is now setting itself up as a rival to GRU, Genie and so on.

good luck

Researching:
The Man In the High Castle

George

George Report 29 Jul 2014 15:25

To: OneFootInTheGrave & RolloTheRed :
Appreciate the (very quick!) responses and can't think why I didn't Google or Bing myself. Bottom line is I pulled down the GEDxlate Lite software which does exactly as I wanted.
May also have a look in the Microsoft archive for the software mentioned but for now - your advice has got me where I need to be. THANKS !
George A

Researching:
Allan, Bremner, Doull, Forbes, Mackenzie, Mackie, Geddes, Caithness & Sutherland