Skip to main content.

This page’s menu:

Tutorial

Page 4 of 5

Now we export our pedigree from the previous page:

tutorial pedigree

Press the Export button. In the dialog that opens, select the first option (PIP file format).

export pedigree

After you press Save, a Windows File Save dialog will open.

If you are not interested in importing your pedigree data in a spreadsheet, or a database, always select PIP file format, and press Save. In the Windows File Save dialog enter a pedigree name (suffix PIP), and you are done.

But we want to save our pedigree data in a spreadsheet. Again, press the export button. This time select CSV file format. A big dialog will open:

CSV file export

Enter a family ID (if you plan to import the data into a database, you will probably use an integer instead of a string), accept the following defaults, change the columns to a value of two, and the number of rows to five. We like to have headers exported, and use a comma as the default separator.

Press OK. The well known Windows file save dialog shows. Accept, or change, the default file name, and save your CSV file

Save CSV

Close PED. In your favorite spreadsheet program, open the previously saved CSV file

CSV file opend in a spreadsheet program

Compare the results with the pedigree drawing at the top of this page.

Launch PED, and press the Import button. In the Windows file open dialog select the CSV file type, and enter the file name:

open CSV file

The import wizard opens. This is the first of 7 pages:

Import wizard page 1

The second page is most important, if your CSV file had not been exported from PED. Press next.

mandatory columns

On the next page, enter the number of the column containing the phenotype (affected / unaffected). Here, accept the default. Press Next.

enter phenotype

If the CSV file is a PED export, you probably did add arrows, or other decoration after a right click on a symbol:

enter arrow

This may be re-imported in PED:

arrows re-imported

The following columns contain text that should be displayed around the symbol:

text around a symbol

Finally the last page. Here we tell PED which columns are to be displayed below a symbol. We need 4 rows with 2 columns, starting with file column 12:

Final wizard page

Here we are again... Probably you want to adjust spaces (Menu Input Window - Options)

back again


Go to: previous page | top of this page | next page of the tutorial