GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 
Converting .xls, .txt, .csv files to .ged (Gedcom)


https://support.genopro.com/Topic15645.aspx
Print Topic | Close Window

By 233211 - Saturday, January 6, 2007
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
By GenoProSupport - Monday, January 8, 2007
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.

By 233211 - Tuesday, January 9, 2007
Hello, thanks for informations.

It's very useful.

Bye
By nguoiveday - Sunday, March 9, 2025
I tried to import XML file but it didn't work
By genome - Monday, March 10, 2025
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.