* Convert Excel files to GEDCOM

Homeless Posts from the old forum system
Locked
avatar
ArchiesDad
Newbie
Posts: 1
Joined: 06 Jul 2004 13:07
Family Historian: None

Convert Excel files to GEDCOM

Post by ArchiesDad » 06 Jul 2004 13:18

I have a lot of data in Excel spreadsheet files, and want to convert them into GEDCOM files so I can import them direct into FH. Does anyone have any idea how to do this?

ID:480

User avatar
Jane
Site Admin
Posts: 8442
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Convert Excel files to GEDCOM

Post by Jane » 06 Jul 2004 13:36

Normally the biggest problem with going into GEDCOM from excel is the excel data does not contain any family linking.

What sort of information do you have in excel? what fields and what do you want to do with it.

You may be able to write VB scripts to output the data to a gedcom file.

avatar
vliet
Famous
Posts: 118
Joined: 20 Aug 2003 09:30
Family Historian: None

Convert Excel files to GEDCOM

Post by vliet » 06 Jul 2004 17:15

What about the CSV to GEDCOM Program in the Query Store/Download section in the GEDCOM utilities bit?!

vliet

User avatar
Jane
Site Admin
Posts: 8442
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Convert Excel files to GEDCOM

Post by Jane » 06 Jul 2004 19:53

well done I had forgotten about that one.

Locked