=== Real world example Example CSV from Spreadsheet ===

[[ImageFile:Gen5Gen4-spreadsheettest.jpgcsv-LibreOfficeCalc.png|thumb|right|400px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} ]]

In Using Gramps [[Example.gramps]] for this example, I had . The children already exist in the Family Tree. So you can enter an entire generation to enter, 16 (8 names with marriage dates. The children I already had in the database. I entered them ) into LibreOffice:

Notice that you can use numbers or strings as the reference names between areas. In the person area, I used the numbers 1 through 168. That made it easy to refer to them in the second area of marriages. The marriages are labeled with the letters A through HD.

Also note that in the spreadsheet the children in the third area are existing people in Gramps as indicated by the brackets around the Gramps IDs.

 [[ImageFile:Gen5Gen4-csv-import-gramps-50.jpgpng|thumb|left|500px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Saving as CSV and importing into Gramps produces the far right-hand column in the tree.(Highlighted in yellow)]]