GEDxlate is a FREE Windows program that quickly and easily translates genealogy data from standard GEDCOM format into MS Access dB (*.mdb), MS Excel Worksheet (*.xls), comma delimited (*.csv), or text file (*.txt) formats. If you would like to export data from your favorite genealogy program so that you can examine it in a spreadsheet or another database program, GEDxlate should simplify the task.
Use of a utility such as GEDxlate can often help you find data inconsistencies. An Excel spreadsheet shows the data in columnar form. You can export a GEDCOM file from your favorite genealogy program, import the result into Excel or any other spreadsheet program, and then look at the column of names to identify misspellings more easily. You can also sort by columns, such as the birthdate field, to find inconsistencies in the data.
To use GEDxlate, download the program, double-click on the newly-downloaded file, and follow the instructions that appear on the screen. Then launch GEDxlate in the same manner as you would any other Windows application. Next, pick a GEDCOM file to translate, select which fields you want to include in your dB, spreadsheet, csv, or txt file; choose an output format and file name to save the translated data in. The program will then create your new file.
Next, go to Excel or whatever other program you wish to use, select FILE and then select IMPORT in order to import your new file. A few seconds later all your data will appear in the spreadsheet.
GEDxlate can be downloaded free of charge at http://www.gedmagic.com/GEDxlate.htm.
My thanks to Bruce Greenberg for telling me about GEDxlate.
Very nice utility. I wrote one several years ago that would convert the GEDCOM information to a .DBF or data table. From there it had the option of extracting the data into a "Research Locality" Report. Quite handy for collecting all your research for a trip or even Internet focused search.
In Excel, you can do the same thing by sorting it by the location column. It won't be EXACTLY like mine, though, because mine considered the location for ALL events BMD, burial, christening, etc., but you can alter the sort criteria to arrive at the data you need.
Happy Dae·
http://ShoeStringGenealogy.com
Posted by: Dae Powell | April 15, 2009 at 09:01 AM
I downloaded it and tried it on 2 different GED files I have and it did not work on either one - saying that there was no GED data in them. I have used both files for transferring data between different software.
Posted by: Robbin Smith | April 15, 2009 at 04:55 PM
Same with me - no Ged Data.
Posted by: Ida | April 15, 2009 at 11:00 PM
One of the options I use in generating GEDCOMs is "PAF compatible." GEDXLATE reads my GEDCOMs with this option.
Happy Dae·
Posted by: Dae Powell | April 16, 2009 at 11:41 AM
I downloaded this program but after opening it did not recognize either of my GEDCOM files. It opened to show my desktop but only the folders were shown, not individual files. I put my GEDCOM files in a folder but when I clicked on the folder it indicated that it was empty.
Posted by: Ed Keelin | April 16, 2009 at 10:20 PM
I can fix that. Give me a minute. Or two.
I'll announce it on the GEDXLATE web page when it's good to go.
Tip of the hat to this site's host. Thanks for being here.
~Rick
Posted by: Rick Seelhoff | April 17, 2009 at 08:14 PM
Fixed. Thanks again for being here.
Posted by: Rick Seelhoff | April 20, 2009 at 02:35 PM
I just download version 1.2 and tried it on GED file exported from MyHeritage Family Tree Builder and I am still getting a error message. The error says: Run-time error '75': Path/File access error. The 1.1 version worked last week with a GED file which had 211 people, the file now has 272 people.
Posted by: Warren Steckler | April 20, 2009 at 09:24 PM
I too am still having problems. I uninstalled the previous version then installed the new one. When I open the program it still does not see the GEDCOM files in my folder. I changed the type of file to open to "All Files" and it then sees my GEDCOM. But when I try to open it I get a Runtime Error 62. Thanks for all you are doing to fix this Rick.
Posted by: Ed Keelin | April 21, 2009 at 03:10 PM
Yeah, sometimes it can be like trying to get air bubbles out of a water matress. Let's pick up this conversation over at my place - e-mail me if you're still having troubles. Thanks!
Posted by: Rick Seelhoff | April 22, 2009 at 08:27 PM
The bubbles have abated. GEDxlate Lite 1.2 is up and running.
Posted by: Rick Seelhoff | May 02, 2009 at 06:02 PM
Awesome tool. Very useful to save me trying to convert a GED to csv.
Posted by: Lantrix | September 28, 2009 at 11:36 PM
I have tried to download Lite version 1.2
on my new laptop - but each time I get an error message:
run-time error '339 - component 'comctl32.ocx' not correctly registered:file is missing or invalid.
any help would be great as i had it on my old computer and loved it.
Posted by: Cindy Perry | October 06, 2009 at 08:44 PM