Changes

Jump to: navigation, search
m
add-on > addon ( stick with one spelling )
{{man index|Gramps 5.1 Wiki Manual - Manage Family Trees|Gramps 5.1 Wiki Manual - Probably Alive|5.1}}
{{languages|Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export}}
{{#vardefine:chapter|5.16}}
{{#vardefine:figure|0}}
This section relates to using Gramps with the '''Comma Separated Values Spreadsheet(CSV)''' format.
*[[Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees#Gramps_CSV_import|Gramps CSV import]]
*[[Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees#Comma_Separated_Values_Spreadsheet.28CSV.29_export|Comma Separated Values Spreadsheet(CSV) export]]
 
You can also [[Gramps_5.1_Wiki_Manual_-_Settings#Export_View|Export]] the current list view to a Spreadsheet(*.ODT) or CSV file.
== Gramps Spreadsheet Import/Export ==
{{man warn|This spreadsheet format does not allow for 100% export of Gramps data.|It only exports (and imports) a subset of data, namely: people (names, gender, birth, baptism, death, and burial dates/places/sources); marriages (dates/places/sources); relationships (parents and children); and places (title, name, type, latitude, longitude, code, enclosed by, and enclosed date). Notes are not exported, but new notes are appended onto the end of existing notes.}}
 
{{man warn|The CSV import and export both use the Edit/Preferences/Display/Place Format setting for places. For most uses, the 'Full' setting for Place Formats should be used. If the place format setting doesn't match the CSV file for import, you may get the same place created more than once.}}
There are three main uses for this format:
<pre>
person - a reference to be used for families (marriages, and children)
grampsid - to assign a gramps Gramps id to the person
firstname - a person's first name
surname/lastname - a person's last name
gender - male or female (you should use the translation for your language)
note - a note for the person's record
 
birthdate - date of birth
birthplace - place of birth
birthplaceid - place id of birth
birthsource - source title for birth
 
baptismdate - date of baptism
baptismplace - place of baptism
baptismplaceid - place id of baptism
baptismsource - source title of baptism
 
deathdate - date of death
deathplace - place of death
deathsource - source title for death
deathcause - cause of death
 
burialdate - date of burial
burialplace - place of burial
burialplaceid - place id of burial
burialsource - source title of baptismburial occupationdate - date of occupationoccupationplace - place of occupationoccupationplace_id - place id of occupationoccupationsource - source title of occupationoccupationdescr - description of occupation residencedate - date of residenceresidenceplace - place of residenceresidenceplace_id - place id of residenceresidencesource - source title of residence attributetype - type of attributeattributevalue - value of attributeattributesource - source title of attribute
</pre>
</pre>
If you cut and paste that into a file (or use the [[Addon:ImportGramplet|Addon:Import Gramplet]]), you can import it directly.
A date can be any valid Gramps date, including dates formats like "26 JAN 1973" or "26.1.1973".
"D","[I0973]",,
</pre>
=== See also ===* [[Addon:ImportGramplet|Addon:Import (text) Gramplet]] 3rd party addon by Doug Blank - an interactive version of the [[Gramps_{{man version}}_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export|CSV Import]]
{{languages|Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export}}

Navigation menu