Leader badge

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

Main Tab Data Input Area & GEDCOM Creating Macro Button Help Tab with Schema Extension Information.

Project Activity

See All Activity >

Follow Excel2GED

Excel2GED Web Site

Rate This Project
Login To Rate This Project

User Ratings

5.0 out of 5 stars
★★★★★
★★★★
★★★
★★
★
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

Filter Reviews:
★★

There are no 2 star reviews.

Additional Project Details

Registered

2009-04-02
Report inappropriate content