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.
