Menu
▾
▴
Main Tab Data Input Area & GEDCOM Creating Macro Button
Help Tab with Schema Extension Information.
Home
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.
Others have volunteered development effort since then.
Main Tab Data Input Area & GEDCOM Creating Macro Button
Help Tab with Schema Extension Information.
Can you increase the amount of cells to 250,000 or more? Ancestry has citations, photos, notes, etc and i want to capture this data.
I noticed that there are a large number of standard gedcom fields. Can these be added?
http://wiki-en.genealogy.net/GEDCOM-Tags
In my project, i have these tags used that i need: Adoption
AKA
Arrival
Baptism
Birth
Burial
Caste
CauseOfDeath
Census
Christening
Cremation
CustomEvent
Death
Departure
Description
Destination
Divorce
DivorceFiled
Education
EndowmentLDS
Gender
Graduation
Immigration
Marriage
MarriageContract
MarriageLicense
Medical
Military
Mission
Name
Nationality
Occupation
Origin
Probate
Property
Religion
Residence
Retirement
Title
Unknown
Will
Last edit: Joseph Wathen 2020-07-12
Hi, Joseph
Before answering your question, please resend directly to the email address I prefer to use for such exchanges: Brs4Gen@Yahoo.com
I doing so, please clarify what you mean by "250,000 or more" cells, i.e., is that the result of multiplying the number of columns you want by the number of rows you need (for Individuals)?
Brian Smith
San Jose, California, USA
Hello,
This is a great project thanks for it.
could be great if I was able to manage this kind of data :
https://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 for this kind of source in a excel file then apply the magic:-)
translate SOSA to be a number
Q8=IF(LEFT(A8,4)="Géné","",VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(A8="",A7,A8)," ","",1)," ","",1)," ","",1)," ","",1)," ","",1)," ","",1)," ","",1)," ","",1)," ","",1)))
Sex : if peer = F and odd =M
S7=IF(ISEVEN(Q7),"M","F")
father Sosa = Sosa2
mother Sosa =sosa*2+1
spouse sosa= sosa+1
if sosa ID id already known find it consider itto find father and mother
*if personne is know as other sosa id :
=IF(LEFT(A7,4)="Géné","",IF(P7="","",IF(O7<>"",LEFT(P7,FIND(" → ",P7)),P7)))
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 :
* translate text in french
* try to go from found date (geneanet.org to this gedcom export.
email me :-)
Best regards
Tetonne
Hi, Tetonne
Your input regarding Excel2GED is appreciated, especially the suggestion to use the ".xlsb" (binary) format instead of ".xlsm" (XML). I had not been aware of its benefits. Having so many more rows in the latest releases makes .xlsb now look like the better one.
I don't fully comprehend all of your suggestions and formulas, partially due to the lack of sufficient context and explanation. Additional details would be helpful. Regardless, here are some observations:
Excel2GED is intended to be a general purpose tool to streamline entering data that can then be imported into other programs. To accommodate a specific data source like Geneanet, I'll suggest using a separate worksheet to convert the data of interest to what could then be pasted as "text-only" into Excel2GED--as it is. You seem to have the skills to provide that solution. ?
Excel2GED exports whatever is found in a Date cell, quoting it exactly. A GEDCOM file is simple text. To get predictable behavior, cells for dates are set to be in "Text" vs. "Date" format; otherwise Excel's treatment of dates often produces unacceptable results. In order to be compliant with the GEDCOM 5.5.1 specification, exact dates must be in the form "(d)d MMM yyyy" (avoid leading zeros). So beware of using slashes to separate the parts.
The GEDCOM spec only approves the month (MMM of "dd MMM yyyy") to be an abbreviation using three or four capital letters. (My observation is that many genealogy programs are tolerant of mixed case, and some auto-correct it to be all caps; nevertheless, ...) Any other date format may be rejected by the importing program.
Brian
PS1-a: For future communications, I'd prefer you send email directly to: Brs4Gen(at)Yahoo.com
PS1-b: Please copy to Paul Pruitt: socrtwo(at)gmail.com
PS2: In which time zone do you live?
mail sent :-) best regards
I recently started trying to gather all my ancestral data from various family pdfs. The Excel2GED file has been a huge help. I was having trouble with my first few lines of data not being imported. It took me way too long to realize the darn umlaut (ü) was causing all my grief. Is this a fluke? Maybe add a warning that special characters may cause issues.