Tutorial
Now we export our pedigree from the previous page:
Press the Export button. In the dialog that opens, select the first option (PIP file format).
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:
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
Close PED. In your favorite spreadsheet program, open the previously saved CSV file
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:
The import wizard opens. This is the first of 7 pages:
The second page is most important, if your CSV file had not been exported from PED. Press next.
On the next page, enter the number of the column containing the phenotype (affected / unaffected). Here, accept the default. Press Next.
If the CSV file is a PED export, you probably did add arrows, or other decoration after a right click on a symbol:
This may be re-imported in PED:
The following columns contain text that should be displayed around the 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:
Here we are again... Probably you want to adjust spaces (Menu Input Window - Options)
