Enhance .csv import

Because entry for repetitive data in a Spreadsheet is blazingly fast, mouse-free, intuitive, and easy. (Until you get to the “save as CSV” and Import that file into Gramps. That’s where the ‘easy and intuitive’ breaks down.) see CSV template for Text Import

A spreadsheet lets you be certain that ALL the family members queued up in a single place without spawning layer-upon-layer of popup dialogs.

If you do the 3 generation data-entry test (that @ed4becky does in his Genealogy Showcase video) in the Gramps interface, that’s 3 Families (plus 3 marriage Events and 3 children relationship-to-parents), 7 persons (plus 14 events: birth, death) plus 17 Places. That would be 47 dialogs!

And possibly nearly double that if you choose citations for all of those.

But I can fill in that information in less than 5 minutes in a spreadsheet… including a sole source for them all.

In the spreadsheet below, all that a person needs to fill in are the Yellow fields. The light green (Places) are helpful. (To copy’n’paste into the Import Text gramplet, the default “comma” delimiters in the CSV Dialect configuration option must be changed to excel-tab delimiters.)

3 Likes