# Enhance .csv import

**URL:** <https://gramps.discourse.group/t/enhance-csv-import/5979>\
**Category:** Ideas\
**Tags:** data-import\
**Created:** [September 1, 2024, 3:08pm UTC](https://gramps.discourse.group/t/enhance-csv-import/5979 "2024-09-01T15:08:49Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\
**Post date:** [September 1, 2024, 11:28pm UTC](https://gramps.discourse.group/t/enhance-csv-import/5979/4 "2024-09-01T23:28:05Z")

</div>

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](https://gramps.discourse.group/t/csv-template-for-text-import/5277/6)

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](https://gramps.discourse.group/t/featuring-gramps-features-is-it-really-a-genealogy-program-for-all/1322)) 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](https://gramps-project.org/wiki/index.php/Addon:Import_Text_Gramplet) gramplet, the default “comma” delimiters in the [**CSV Dialect** configuration option](https://gramps-project.org/wiki/index.php/Gramps_5.2_Wiki_Manual_-_Settings#CSV_Dialect) must be changed to excel-tab delimiters.)

 ![image](https://global.discourse-cdn.com/free1/uploads/gramps/original/2X/5/58aca033adab0f4acc63de574a19d9005016d8a6.png)

---

_[View the full topic](https://gramps.discourse.group/t/enhance-csv-import/5979)._