GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum




Converting .xls, .txt, .csv files to .ged (Gedcom)

Click to view RSS...
Author Working with XLS, TXT or CSV
Posted Saturday, January 6, 2007 - Post #15645
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Forum Members
FamilyTrees.GenoPro.com
GenoPro version: 2.00

Last Login: Tuesday, January 9, 2007
Posts: 2, Visits: 2
Hi,

I would like to know How to convert XLS, TXT or CSV files to GED format.

Is possible using GenoPro?

Exists any program that to do this task?

Thans!

Fábio S. Vidal


Edited: Monday, January 8, 2007 by GenoProSupport
Posted Monday, January 8, 2007 - Post #15672
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Moderators
Customers
Gamma
FamilyTrees.GenoPro.com
Translator
GenoPro version: 3.1.0.1

Last Login: Thursday, January 16, 2025
Posts: 4,886, Visits: 22,775
I would recommend converting to XML for three reasons:

1. Converting from XLS, TXT or CSV is easier to XML.  In fact, Excel may have a built-in facility to export to XML.

2. The XML format is much easier to understand than Gedcom.  Gedcom is old and is full of quirks, including character encoding for non-English text, line limitation to about 80 characters and some ambiguous values for tags such as NAME and DEAT.  I am not bashing Gedcom, however I am just expressing my difficulties working with .ged files.

3. The XML format is native to GenoPro, meaning you can round-trip data in XML without any data loss.  Importing Gedcom to GenoPro results in some data being modified while being imported.

Posted Tuesday, January 9, 2007 - Post #15744
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Forum Members
FamilyTrees.GenoPro.com
GenoPro version: 2.00

Last Login: Tuesday, January 9, 2007
Posts: 2, Visits: 2
Hello, thanks for informations.

It's very useful.

Bye
Posted Sunday, March 9, 2025 - Post #46738
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Forum Members

Last Login: Sunday, March 9, 2025
Posts: 1, Visits: 2
I tried to import XML file but it didn't work
Posted Monday, March 10, 2025 - Post #46739
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 4 hours ago
Posts: 3,410, Visits: 26,293
Your XML needs to be in a format accepted by GenoPro.

e.g. the following nuclear family

https://support.genopro.com/Uploads/Images/98eca8b2-ddba-4ec6-bcc4-e284.png
can be created using the following XML

<?xml version='1.0' encoding='UTF-8'?>
<GenoPro>
<Individuals>
<Individual ID="ind00001">
  <Name>Son Smith<First>Son</First><Last>Smith</Last></Name>
  <Gender>M</Gender>
  <Birth><Date>8 Jul 2011</Date><Place>place00002</Place></Birth>
</Individual>
<Individual ID="ind00002">
  <Name>Dad Smith<First>Dad</First><Last>Smith</Last></Name>
  <Gender>M</Gender>
  <Birth><Date>21 Nov 1979</Date></Birth>
</Individual>
<Individual ID="ind00003">
  <Name>Mum Jones<Display>Mum Jones</Display><First>Mum</First><Last>Jones</Last></Name>
  <Gender>F</Gender>
  <Birth><Date>2 May 1977</Date></Birth>
  <Death><Date>12 Apr 2022</Date></Death>
</Individual>
<Individual ID="ind00004">
  <Name>Daughter Smith<First>Daughter</First><Last>Smith</Last></Name>
  <Gender>F</Gender>
  <Birth><Date>30 Sep 2014</Date></Birth>
</Individual>
</Individuals>
<Families>
<Family ID="fam00001"><Unions>marr00001</Unions></Family>
</Families>
<Marriages>
<Marriage ID="marr00001"><Date>14 Dec 2009</Date><Place>place00001</Place></Marriage>
</Marriages>
<PedigreeLinks>
<PedigreeLink PedigreeLink="Parent" Family="fam00001" Individual="ind00002"/>
<PedigreeLink PedigreeLink="Parent" Family="fam00001" Individual="ind00003"/>
<PedigreeLink PedigreeLink="Biological" Family="fam00001" Individual="ind00001"/>
<PedigreeLink PedigreeLink="Biological" Family="fam00001" Individual="ind00004"/>
</PedigreeLinks>
<Places>
<Place ID="place00001">
  <Name>Gretna Green</Name>
</Place>
<Place ID="place00002">
  <Name>London</Name>
</Place>
</Places>
</GenoPro>


Further information on GenoPro's XML format can be gleaned by exporting an existing .gno to XML format and examining the resulting file.


'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"


Similar Topics

Click to view RSS...
Expand / Collapse
No results found!

Reading This Topic

Expand / Collapse
Active: 3 - 1 guest, 1 member, 0 anonymous.
Refresh