Last week, Excel2GED v3 was updated to build 2023-11-11. Excel2GED is an open-source project that provides a Microsoft Excel spreadsheet (with macro) that converts genealogy data stored in a spreadsheet into a GEDCOM text file with the proper .ged extension.
There are Visual Basic for Applications (VBA) macro buttons for exporting the GEDCOM file, which can then be imported into most, if not all, genealogy programs, complete with defined family relationships, BMD information, and source notes attached.
Some of the features besides maintaining family relationships include adopted children being handled correctly, support for same-sex couples, and proper GEDCOM 5.5.1 support.
Excel2GED was first made available in 2008.
It is available for download at: Excel2GED download | SourceForge.net
Output GEDCOM files are validated through GEDCOM Validator (chronoplexsoftware.com) and ShowMeGedcom (Familienbande Home (familienbande-genealogie.de))
| Changes in Excel2GED v3 2023-11-11 |
| Sources/Citations (primitive, but) now exported correctly. |
| Separate columns: Notes, Source, Citation, Media details. |
| Six new columns for additional user-selected data types. |
| Template popup implemented for option to view/edit data. |
| Data entry in ‘ListPrep’ sheet; auto-copy to ‘Individuals’. |
| Workbook saved as a binary (.xlsb) file to reduce its size. |