Miscellenea Edintone

How to transfer Excel to Gedcom 10

admin — Sat, 02 Jan 2010 10:21:22 +0000

Gramps is an excellent, open source (free) genealogy program. It is primarily a Linux solution, but don’t let this put you off as it is available for several other operating systems including Mac OS X. There is also a Portable Windows version described here http://www.ormus.info/archives/278-Portable-Gramps-Genealogy-in-your-Pocket.html which can be run from a USB stick. You can also run this version from a folder directly in Windows without needing to worry about technical dependencies.

Its beauty comes from the fact that it can export from an import to the database in CSV format so makes for an easy way of transferring spreadsheet data to a genealogy database and then via GEDCOM to any other program of your choice. The export and import process is fully described here http://gramps-project.org/wiki/index.php?title=Gramps_3.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export

It handles relationships, its only limitation is that it only imports the following fields:

Individuals: Person, Lastname, Firstname, Callname, Suffix, Prefix, Title, Gender, Birthdate, Birthplace, Birthsource, Deathdate, Deathplace, Deathsource, Note

Marriages: Marriage, Husband, Wife, Date, Place, Source, Note

Families: Family, Child

but it does provide a hassle free way of accomplishing this task.

How to transfer Excel to Gedcom 9

admin — Fri, 04 Dec 2009 17:34:03 +0000

GEDaRHIZ is an French program developed by Jacques Louvel

It is described in English here http://pagesperso-orange.fr/jacques.louvel/chrest/gedarhiz_eng.htm

To obtain a copy of the Excel workbook you need to subscribe to the program’s Yahoo Group http://fr.groups.yahoo.com/group/gedarhiz/ The program is free and is documented in English and French. In the Group home page select Fichiers. First read the explanations in 2_explanations.htm and download the Excel version ged2rhiz.exe from 3_ged2rhiz.

How to transfer Excel to Gedcom 8

admin — Fri, 04 Dec 2009 17:07:58 +0000

Here is a French program TransGed which can be downloaded here http://www.visuged.org/chargetg.php3

How to transfer Excel to Gedcom 7

admin — Fri, 04 Dec 2009 16:59:03 +0000

Here is a ”knife and fork” method http://www.tedpack.org/text2ged.html using Word and Excel is described by Ted Pack.

How to transfer Excel to Gedcom 6

admin — Fri, 04 Dec 2009 16:52:52 +0000

Using Fix2Ged. Fix2Ged is a DOS program written by the LDS Family History Department in 1993, but still works.

This utility was developed so that the user could use a grammar pattern file to describe the fixed field (field delimited) input file, as well as defining the appropriate GEDCOM structure in which the specified fixed fields are to be mapped. This program will not provide linkage of relationships.

The Fixed Field to GEDCOM Conversion Utility uses a GEDCOM processor and a GEDCOM grammar pattern file to convert the field delimited file into a GEDCOM output. The fields in the field delimited input file are usually variable length, separated by a field delimiter, but they can fixed length as specified by the GEDCOM grammar pattern file.

The GEDCOM Processor reads in the input fixed file and parses the record into fields as specified by the define record structure from the GEDCOM grammar file. The GEDCOM portion of the grammar file is traversed to determine the mapping from the fixed field input file to the desired GEDCOM output structure. Function call directives are placed within the GEDCOM grammar file to initiate this mapping. The GEDCOM processor will call these functions to retrieve the fixed field values and then places them in the GEDCOM output structures. The output structure is written when all of the nodes in the GEDCOM pattern file have been visited and populated with the fields from the input file. (Details from PAF Review)

The program can be downloaded from http://pac-its.psu.edu/genealogy/gedcom/demo.zip. The program and documentation is contained ion the zip file.

How to transfer Excel to Gedcom 5

admin — Fri, 04 Dec 2009 15:02:58 +0000

GedTool is a collection of Excel macros for processing of GEDCOM files. All functions are started from a common menu interface. With GedTool all fields from a GEDCOM file can be converted into an Excel file. Once in Excel, they will be changed and written back. The same process can be used for creating a completely new Gedcom from and Excel worksheet in various layouts. The program is written by Peter Schulz and works in both English and German.

It can be obtained by emailing Peter is is available as shareware with a one month trial version. Details here http://www.genealogienetz.de/misc/software/hilfsprogramme/gedtool.html and http://wiki-de.genealogy.net/

How to transfer Excel to Gedcom 4

admin — Fri, 04 Dec 2009 14:47:32 +0000

Using Ancestor Access.

Ancestor Access is an Access database that is compliant with the Gedcom 5.5 standard. VBA code is included as a module to create a Gedcom from the database. The file was available for download from http://home.att.net/~douglas.parrish/home.htm but is not currently available. If you cannot locate a copy please contact me.

How to transfer Excel to Gedcom 3

admin — Fri, 04 Dec 2009 13:01:29 +0000

Using SmartGenealogy, from http://alainlecomte.free.fr/Download.htm#SmartGenealogy. You will need to set your spreadsheet up first, but it does get you from Excel to SmartGenealogy and thence from there exported to Gedcom in easy non technical steps.

The best way to do this is:

1. Import an existing Gedcom into SmartGenealogy

2. Export it to Excel

3. Adapt your new data into the format of the Excel sheet you have created

4. Import your new data into a new SmartGenealogy database

5. Finally, export to Gedcom

How to transfer Excel to Gedcom 2

admin — Fri, 04 Dec 2009 12:55:03 +0000

Using excel2ged-family, an Excel spreadsheet template including VBA macros to create the Gedcom file. This method also has the ability to import relationships. It can be downloaded from http://www.godskingsandheroes.info/software/Excel2GEDv1.0-family.zip

How to transfer Excel to Gedcom 1

admin — Fri, 04 Dec 2009 12:46:31 +0000

Many family historians collect family data in Excel (or other another spreadsheet program) as research progresses. There often comes a time time when it would be useful to convert that data into a Gedcom file so that it can be imported into a Family History program without re-keying the data.

There are several approaches to this, most will involve some reformating of the layout of the Excel data first.

Here is one method using Acc2Ged. The program is well described here and can be downloaded from http://website.lineone.net/ ~d.j.cooke/acc2ged.zip