Jump to: navigation, search
Protected "Gramps 5.0 Wiki Manual - Manage Family Trees: CSV Import and Export": ‎(fix protection (lost after migration!)) ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))
This section relates to using Gramps with the '''Comma Separated Values Spreadsheet(CSV)''' format.*[[Gramps_5.0_Wiki_Manual_-_Manage_Family_Trees#Gramps_CSV_import|Gramps CSV import]]*[[Gramps_5.0_Wiki_Manual_-_Manage_Family_Trees#Comma_Separated_Values_Spreadsheet.28CSV.29_export|Comma Separated Values Spreadsheet(CSV) export]]
== Gramps Spreadsheet Import/Export ==
== Export ==
[[File:ExportAssistant-ExportOptions-CSV-defaults-50.png|right|thumb|450px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}} Export Assistant - Export Options - wizard dialog (showing defaults for "Comma Separated Values Spreadsheet(CSV)") with highlight Bottom section for File format specific options]]
To export your database:
## In the top section select which filters to apply to your family tree
## From the checkboxes select which items to include in the export (people, marriages, children, places) and whether to Translate headers into the language you are using.
{{-}}{{stub}}<!--add image with options shownupdate text-->
A selected set of fields of your genealogy data will be saved to a .csv file in the format described below. In addition, the people and families are referenced so that the data can be edited and read back in, thereby updating the database.
Here is an example spreadsheet in LibreOffice, but any spreadsheet program should work.
[[File:Test.csv-LibreOffice4LibreOffice-Calc-50.png|thumb|left|650px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}}]]{{-}}<pre>,,,,,,,,,,"Firstname","Surname","Callname","Gender","Prefix","Suffix","Title","Note","Grampsid","Douglas","Test","Doug","male","Von","Sr.","Dr.","This is not related","I0007","Laura","Test",,"female",,,,,</pre>
And here is the resulting data in Gramps:
[[File:Example FamilyTree-example-imported Family Tree-test.csv-4150.png|thumb|left|650px|Fig. {{#var:chapter}}.{{#vardefineecho:figure|{{#expr:{{#var:figure}}+1}}}}]]
Finally, this also make place P0001 be enclosed by place P0002.
=== 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:Calc.
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.
Saving as CSV and importing into Gramps produces the far right-hand column in the tree:.
 [[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)]]{{-}}Contents of CSV file <code>gen4-test.csv</code><pre>,,,,,,"Person","Firstname","Lastname",1,"Peter","Blank",2,"Anna Maria","Kiefer",3,"Georg","Schmidt",4,"Barbara","Goering",5,"Johann","Kiefer",6,"Fides","Federer",7,"Sebastian","Schelli",8,"Magdelena","Schlegel",,,,,,,"Marriage","Husband","Wife","Date""A",1,2,"28 jan 1712""B",3,4,"4 may 1732""C",5,6,02/07/1930"D",7,8,17/08/1927,,,"Family","Child",,"A","[I0104]",,"B","[I0105]",,"C","[I0972]",,"D","[I0973]",,</pre>
[[Category:Gramps Examples|CSV import/Export]]

Navigation menu