GEDCOM to Excel conversion?
The Walrus
Is there any easy way to convert a GEDCOM to an Excel file that just has
surname, given name, birthdate, place of birth, and spouse?
I have a bunch of GEDCOMs that I want to cull down to the absolute
essentials. I don't need to see relationships other than marriages.
Richard Pence
h> From: hal...@concentric.net (The Walrus)
h> Is there any easy way to convert a GEDCOM to an Excel file that just has
h> surname, given name, birthdate, place of birth, and spouse?
h> I have a bunch of GEDCOMs that I want to cull down to the absolute
h> essentials. I don't need to see relationships other than marriages.
Look for a (freeware) program called GED2FIX, which converts a GEDCOM into a
fixed file format that you should be able to inport into any database manager.
There's also a program called GIPSI, which I think is shareware and does the
same thing.
John Morrison
In article <3203c492...@news.concentric.net>, hal...@concentric.net
says...
>
>Is there any easy way to convert a GEDCOM to an Excel file that just has
>
field types on different lines. All database programs like Access, or spread
sheets like Excel, want their data arranged in neat rows and columns, with
data being split up into tables by logical relationships. To import a
GEDCOM file into Excel would require buying or writing an Excel Basic program
to split the GEDCOM up line by line and dispatch the records to different
worksheets or areas based on what type of record it is.
I happen to charge very reasonable rates for this sort of thing.
joe
David Conover wrote:
>
> Buy The Master Genealogist, http://www.WhollyGenes.com/ import your
> GEDCOM and you can export to Miicrosoft Excel, V2
> ***************************************************************
> David Kipp Conover, Annapolis, MD 21401
> Researching
> Billington, Blauvelt, Brinckerhoff, Buchanan, Conover,
> Covenhoven, Ferdon, Gibbs, Iddings, Jackett,
> Kingsley, Kipp, Knapp, Sabin, Swift, Thompson
> Van Kouwenhoven, Vanderveer
> e-mail <con...@radix.net>
>
> Homepage: <http://www.radix.net/~conover>
Tried to contact you by email, but msg was returned.
I have info on both Brinkerhoffs (NY and CT) and Conovers( Monmouth Cty,
NJ). Contact me if you are interested.
jpa...@epix.net
Elizabeth Harris
In article <4u622e$2...@library.airnews.net>, jdm1...@airmail.net (John
Morrison) wrote:
> In article <3203c492...@news.concentric.net>, hal...@concentric.net
> says...
> >
> >Is there any easy way to convert a GEDCOM to an Excel file that just has
> >surname, given name, birthdate, place of birth, and spouse?
> >
> >I have a bunch of GEDCOMs that I want to cull down to the absolute
> >essentials. I don't need to see relationships other than marriages.
>
> An easy way, no. Gedcom files are mixed record format files with different
> field types on different lines. All database programs like Access, or spread
Why can't he just read the gedcom into Reunion (or another genealogy
program that can export a tab- or comma-delimited file), select the fields
he wants, export, and then import this file into Excel?
--
Elizabeth Harris
chl...@acpub.duke.edu
David Conover
Chris
jdm1...@airmail.net (John Morrison) wrote:
>In article <3203c492...@news.concentric.net>, hal...@concentric.net
>says...
>>
>>Is there any easy way to convert a GEDCOM to an Excel file that just has
>>surname, given name, birthdate, place of birth, and spouse?
>>
>>I have a bunch of GEDCOMs that I want to cull down to the absolute
>>essentials. I don't need to see relationships other than marriages.
>
>An easy way, no. Gedcom files are mixed record format files with different
>field types on different lines. All database programs like Access, or spread
>sheets like Excel, want their data arranged in neat rows and columns, with
>data being split up into tables by logical relationships. To import a
>GEDCOM file into Excel would require buying or writing an Excel Basic program
>to split the GEDCOM up line by line and dispatch the records to different
>worksheets or areas based on what type of record it is.
>I happen to charge very reasonable rates for this sort of thing.
There are a number of shareware and even a freeware or two which
convert GEDCOM files to flat file database files. IGIREAD, GED2FIX,
GIPSI and others come to mind off the top of my head. I've used
IGIREAD a few times, and been very pleased with the result. And it IS
easy. No need to re-invent the wheel and write programs from scratch.
The NGS web site has at least some of these types of programs,
probably most that exist.
Chris
==============================
"You can not solve the problem
with the same kind of thinking
that has created the problem."
(Albert Einstein)
==============================
Bob Anderson
David Conover wrote:
>
> Buy The Master Genealogist, http://www.WhollyGenes.com/ import your
> GEDCOM and you can export to Miicrosoft Excel, V2
You don't need to spend $100 to merely import a gedcom into EXCEL. You
don't need to convert it first to comma delimited or fixed format. Just
set your delimiters to "none" instead of quote marks and "space" instead
of commas, then import it directly into Excel or Access. It will import
just fine. Importing isn't the real problem. Figuring out what to do
with it once you get it into your database handler is.
Gedcom files have definite reason to them, but they don't fit naturally
into tables because of the many to one relationships of individuals to
families. This factor, not the importing, may cause you to spend some
money or time to get what you want.
Bob
--
G. Robert (Bob) and Maureen Anderson and Family
We invite you to visit our home page at http://www.qni.com/~anderson/
mrneila...@gmail.com
> Is there any easy way to convert a GEDCOM to an Excel file that just has
> surname, given name, birthdate, place of birth, and spouse?
>
> I have a bunch of GEDCOMs that I want to cull down to the absolute
> essentials. I don't need to see relationships other than marriages.