Skip to main content.

This page’s menu:

Import and Export

Page 3 of 5

Import pedigree from a CSV file

1. CSV (comma separated values) file format

You can import pedigrees from a CSV file.
The first 5 columns in the CSV file must have the following format:

» Family ID | Individual ID | Father ID | Mother ID | Gender «

  1. Family ID: Optional (can be ommitted) | string or integer
  2. Individual ID: Mandatory | Unique integer > 0
    (if you have Family ID-Individual ID separated by a hyphen in a single column, PED should recognize this)
  3. Father ID: Mandatory | integer >= 0
  4. Mother ID: Mandatory | integer >= 0
  5. Gender: 0 (unknown), 1 (male), 2 (female)

The next two columns are optional.
If present, they must follow these rules:

All other columns are totally optional

2. Imports that will work, and those that won't:

Some rules to obey

3. Import a pedigree from the CSV file shown at the previous page

This is the CSV file opened in a text editor:

family,ID,father,mother,gender,phenotype,arrow,Text 1,Text 2,Text 3,Text 4,M 1,M 2,M 3,M 4,M 5,M 6,M 7,M 8,
0,1,5,6,1,8,1,John,Doe,12-12-1950,,HNCCP,50,D123-45-2005,XYZ1,c.123G>T,c.456G>T,ABC1,c.333G>C,
0,2,7,8,2,2,1,,,,,,,,,,,,,
0,3,1,2,1,3,0,,,,,,,,,,,,,
0,4,1,2,2,17,0,,,,,,,,,,,,,
0,5,0,0,1,1,0,,,,,,,,,,,,,
0,6,0,0,2,8,2,,,,,,,,,,,,,
0,7,0,0,1,1,2,,,,,,,,,,,,,
0,8,0,0,2,1,2,,,,,,,,,,,,,

This is the same file opened in OpenOffice.org:

The CSV file shown in OpenOffice.org

Be sure that the file format follows the rules given above.

In PED input pane, press the Import button:

Press Import in PED input pane

In the File dialog that opens, enter as file type CSV, then choose the appropriate file:

Windows file open dialog

After you press the Open button, the import wizard will be launched.
The top pane of each of the 6 pages of the wizard - hopefully - contains all information you need to import a CSV file:
This is the first page of the import wizard:

import wizard

This is page 5 of the import wizard:

import wizard

This is the final page of the import wizard:

import wizard

After pressing the Finish button, here is the pedigree you got from this file:

pedigree imported from a CSV file

Remember: Imported pedigrees know nothing about a "best" layout. To restore the pedigree from the previous page, you have to adjust background / line / text colors, and the distance between symbols. Also notice that import / export does not distinguish between the various kinds of arrows available in PED. If an arrow is imported, always the default arrow will be displayed.

the oroginal pedigree


Go to: previous page | top of this page | next page of Import and Export