1,583
edits
Changes
Added place information for 4.2.1
This format allows you to import/export a spreadsheet of data all at once. The spreadsheet must be in the Comma Separated Value (CSV) format. Most spreadsheet programs can read and write this format. It is also easy to write by hand. This is the only Gramps import format which allows for merging with existing data.
{{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 and , gender), birth, baptism, death, and burial dates/places/sources, ); marriages (dates/places/sources) and ; 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 note|New feature since Gramps 3.3|Previously, sources were not exported, but now they are. Sources are referred to by their title text. You can add further details to a source after importing.}}
{{man note|New feature since Gramps 4.2.1|Now you can export and import place information.}}
There are three main uses for this format:
# Select "Export" from the Family Trees menu
# Select "Comma Separated Values Spreadsheet (CSV)"
# Select which items to export (people, marriages, families, and/or places)
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 familes families are referenced so that the data can be edited and read back in, thereby updating the database.
There are some columns that will be blank, specifically note and source columns. These are listed in the spreadsheet so that you can make notes for the import, but notes are never exported with this tool. '''From Gramps 3.3 you can now export source titles; previously no source data was exported.'''
Your data is broken up into three four sections representing individuals, marriages, children, and childrenplaces. The exported fields and column names are:
;Individuals: Person, Lastname, Firstname, Callname, Suffix, Prefix, Title, Gender, Birthdate, Birthplace, Birthsource, Baptismdate, Baptismplace, Baptismsource, Deathdate, Deathplace, Deathsource, Burialdate, Burialplace, Burialsource, Noteote
;Families: Family, Child
;Places: Places, Title, Name, Type, Latitude, Longitude, Code, Enclosed_by, Date The first column in each area is the gramps ID. That is what will tie your edits back to the correct data, so don't alter those data. Load this file into your favorite spreadsheet using comma separated, double-quote text delimited, and Text format (any encoding for now). Then you can add or correct data, and save it back out, keeping the same format. You can then import the data back ontop on top of your old data and it will be corrected.
{{man note|LibreOffice allows you to turn off auto-formatting when you open the CSV file.|If you don't do this, LibreOffice may interpret the dates incorrectly. Change the type of the column to Text rather than Standard. If your spreadsheet program doesn't allow you to format the fields before you get it into columns (eg, Excel) you need to change the display format of dates in Gramps before you export. You can do this under {{man menu|Edit -> Preferences -> Display -> Date Format}}}}.
gender - male or female (you should use the translation for your language)
[You can put gender here, or in person above]
</pre>
=== Place ===
<pre>
places - a reference to this place
title - title of place
name - name of place
type - type of place (eg, City, County, State, etc.)
latitude - latitude of place
longitude - longitude of place
code - postal code, etc.
enclosed_by - the reference to another place that encloses this one
date - date that the enclosed_by place was in effect
</pre>
== Details ==
Case doesn't matter. Notice that the names don't use underscores in them. You may use any combination of these, in any order. (Actually, you have to at least have a surname and a given name when defining a person, and you have to have a marriage and child columns when defining children, and places need a place reference, but that is it.) The column names are the English names given (for now) but the data should be in your language (including the words "male" and "female").
Each of these can go in its own area in a spreadsheet. There is no limit to the number of areas in a sheet, and each area can have any number of rows. Leave a blank row between "areas". Just make sure that areas are not next to each other; they must be above and below one another.
You can have multiple areas of each kind on a spreadsheet. The only limitation is that if you refer to a person, you must do that in a row lower than where that person is described. Likewise, if you refer to a marriage, you must do that in a row lower than where the marriage is described. References to enclosed_by places must already exist in the database, or be defined above in the spreadsheet.
If you are entering the data in a text file, and if you wish to have a comma inside one of the values, like "Clinton, Co., MO" then you need place the entire value in double-quotes and put the first double-quote right after the preceding comma. For example:
m1, p6
m2, p7
Place, Title, Name, Type
p1, Canada, Canada, Country
p2, USA, USA, Country
</pre>
If you cut and paste that into a file(or use the Import Gramplet), you can import it directly.
A date can also be given in format any valid Gramps date, including dates formats like "26 JAN 1973" or "26.1.1973".
If you make your references be gramps IDs inside square brackets, then you can refer to people already in the database, like this:
firstname, surname
Timothy, Jones
place, enclosed_by
[P0001], [P0002]
</pre>
Also, this example would marry two previously existing people, I0123, and I0562.
=== Real world example ===
