Excel2GED Files

Release Notes for Excel2GED_v2.1.xls


Description

Excel genealogy spreadsheet with macro for converting data to gedcom format. Unlike other similar Excel2gedcom converters, family relationships are preserved .GEDCOM generation is initiated with a push of a VBA coded macro button. Spreadsheet protection password = "x2g"

Version 1:

Current bug shows all children under last spouse. If you find this to be the case, for now, enter only one partner and fix the problem in your genealogy software. For a man with multiple wives having children with each, enter the first wife as attached to the husband and the second as being initially single until you get into your genealogy program then attach them to the husband. You can also have multiple instances of the same man or woman and merge them later on with the program where you import the gedcom. My apologies for the inconvenience.

There is another Excel file based program which may be superior in this regard (and others as it is a more substantial item), which is also free. It's called cvbFT.

Version 2.0:

Multiple spouses and their children are correctly represented.  A person with more than one spouse is given multiple adjacent rows, one per spouse.
*  Same-sex marriages are legal.  Some genealogy programs support this and some do not, but the exported gedcom can have two spouses of the same sex.
*  Major bug:  the worksheet is password protected by default, password "x2g", but fails to create family relationships correctly until password protection is inactivated.
*  Minor bug: even with password protection turned off, it sometimes fails to update family relationships correctly.

Version 2.1:

*  Same new features as version 2.0: multiple spouses and same-sex marriages are handled correctly.
*  Spreadsheet protection is inactivated by default.
*  Family relationships are updated correctly.
*  No known bugs at this time.  We'll see how long that remains true.