Excel2GED is an Excel spreadsheet with a macro for converting genealogy data into a GEDCOM-formatted text file with a '.ged' file extension. A GEDCOM file is generated by clicking the VBA-coded macro buttons 'Export' or 'Export to GEDCOM' after creating & selecting a recipient folder. That file can then be imported into a genealogy program, with family relationships already defined, BMD data included, and source notes attached.

Output has been validated to conform to GEDCOM 5.5.1 by software from https://chronoplexsoftware.com/gedcomvalidator and
ShowMeGEDCOM from http://www.familienbande-genealogie.de.

Some improved features in version 3:
Multiple marriages and adopted children are handled correctly.
Same-sex marriages/partnerships and children are accommodated.
View the 'ReleaseNotes' worksheet for additional details.

If needed, the spreadsheet protection password is 'x2g'.

Excel2GED 1.0 was first commissioned in 2008 by Paul D. Pruitt.

Features

  • Preserves family relationships
  • Converts Excel genealogy info into a GEDCOM file
  • Same sex couples and children are supported
  • Adopted children handled correctly
  • Source notes preserved in GEDCOM output
  • Output is GEDCOM 5.5.1 verified
  • VBA password is available for free, allowing modification of the source

Project Samples

Project Activity

See All Activity >

Follow Excel2GED

Excel2GED Web Site

Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
5
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

  • One of a kind!
  • Hello, This is a great project thanks for it. could be great if I was able to manage this kind of data : gw.geneanet.org/bwautier?lang=fr&pz=alicia+sixtine+angele+christine&nz=wautier&ocz=0&m=A&p=emile+joseph&n=dupont&sosab=10&color=&t=Z&birth=on&birth_place=on&marr=on&marr_date=on&marr_place=on&child=on&death=on&death_place=on&death_age=on&occu=on&gen=on&repeat=on&v=8 copy-paste of data * translate SOSA to be a number * Sex : si peer = F and odd =M * father Sosa = Sosa*2 *mother Sosa =sosa*2+1 * spouse sosa= sosa+1 if date is dd/mm/yyyy ok but can be yyyy or mm/yyyy thanks a lot Why the last release is so heavy? save it under .xlsb :-) i' ready to help
  • Excel2GED is an essential utility, and Brian Smith is a great and knowledgeable person who obviously loves genealogy. We had to convert a 80 000 individuals home made database to a GED file in order to upload the result to Brother's Keeper. At first Excel2GED was not setup to process so many rows but Brian made the needed modifications and made it work. Now Excel2GED is even more robust and has a lot of features to help tracking errors.
  • Fast gedcom creator. Herman, to answer your second question, I expanded the cells to the full size excel allows by using the Kutools program. Once installed, go to each sheet you want to expand, Go to Kutools, Show/Hide, Unhide All Ranges. Repeat for other sheets.
  • Excellent program, an update was long overdue. It is so much easier to enter data into excel than in any genealogical program (I use Rootsmagic and Legacy). Can you please assist me to add a date and place for christening (baptising) columns? Regards Herman du Plooy Witbank, South Africa How do I increase the line from 65536 to the over a million? REgards Herman
    1 user found this review helpful.
Read more reviews >

Additional Project Details

Registered

2009-04-02