spreadsheet to GEDCOM or PAF utility?

[TomAlciere]

Does anybody know of a utility for converting spreadsheets from
transcribing projects, from spreatsheet formats to GEDCOM? Or to PAF,
from which GEDCOM can easily be exported?

Tom Alciere
http://GedcomLibrary.com

[C.R.]

On 29 Nov 2006 03:48:23 -0800, "TomAlciere"
<[email protected]> wrote:

Does anybody know of a utility for converting spreadsheets from
transcribing projects, from spreatsheet formats to GEDCOM? Or to PAF,
from which GEDCOM can easily be exported?

There is no way to know - ahead of time - how the spreadsheet might
have been constructed by the person who created it, therefore such a
program would be unable to put each piece of data into the proper
GEDCOM format. It would have to be custom written.

C.R.

[TomAlciere]

C.R. wrote:

On 29 Nov 2006 03:48:23 -0800, "TomAlciere"
[email protected]> wrote:

Does anybody know of a utility for converting spreadsheets from
transcribing projects, from spreatsheet formats to GEDCOM? Or to PAF,
from which GEDCOM can easily be exported?

There is no way to know - ahead of time - how the spreadsheet might
have been constructed by the person who created it, therefore such a
program would be unable to put each piece of data into the proper
GEDCOM format. It would have to be custom written.

C.R.

Or the program could ask the user which column is the birth date, which
is the death date etc.

[Charlie Hoffpauir]

On Wed, 29 Nov 2006 07:17:13 -0500, C.R. <[email protected]> wrote:

On 29 Nov 2006 03:48:23 -0800, "TomAlciere"
[email protected]> wrote:

Does anybody know of a utility for converting spreadsheets from
transcribing projects, from spreatsheet formats to GEDCOM? Or to PAF,
from which GEDCOM can easily be exported?

There is no way to know - ahead of time - how the spreadsheet might
have been constructed by the person who created it, therefore such a
program would be unable to put each piece of data into the proper
GEDCOM format. It would have to be custom written.

C.R.

Actually there is an Excel file that leads the user through the steps.
I've never used it, but I do have a copy downloaded from somewhere.
It's presently in the form of a ZIp file named "Excel-to-gedcom.zip"
that's about 6 KB in size. I took a look at the excel file, and it's
in the form of steps to take to put the data into the right form, then
it seem to have a macro or something to export the information. If you
want to take a look at it, I can e-mail you a copy (no guarantees
here... I can't even find the writer's name, but it may be embedded in
the file somewhere.)

I'll email a copy if you send me your address. Send the request to my
yahoo address, charliehoffp at yahoo dot com.

Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

[Lars Erik Bryld]

Scripsit C.R.:

Does anybody know of a utility for converting spreadsheets from
transcribing projects, from spreatsheet formats to GEDCOM? Or to
PAF, from which GEDCOM can easily be exported?

There is no way to know - ahead of time - how the spreadsheet might
have been constructed by the person who created it, therefore such
a program would be unable to put each piece of data into the proper
GEDCOM format. It would have to be custom written.

You don't, however, need special programming skills, just a little
knowledge of the GEDCOM-format and a copy of MS-Word. I have
successfully made valid GEDCOMS from spreadsheets using the Mail Merge
feature.

--
Regards
Lars Erik Bryld