Jump to: navigation, search
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 in rows above in the spreadsheet.
If you use the 'grampsid' as a way to assign specific ids, be ''very '' careful when importing to a current database. Any data you enter will '''overwrite ''' the data assigned to that grampsid. If you use ids in the place, person, marriage, or family columns that are surrounded by brackets (for example '[i0001]'), the values you use will be interpreted as grampsids as well. If you are adding '''new ''' items, you are encouraged to avoid use of the '[]' bracket format or grampsid columns, so as to avoid accidentally overwriting your data.
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:
Notice that you can use numbers or strings as the reference names between areas. In the person area, I used the numbers 1 through 16. That made it easy to refer to them in the second area of marriages. The marriages are labeled with the letters A through H.
{{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}}.}}
Also note that the children in the third area are existing people as indicated by the brackets around the Gramps IDs.

Navigation menu