Is is possible? Spreadsheet to Gramps

Help
1

I have created spreadsheets for a Civil War Regiment (913 men, over 700 wives).

I have a bio table with name, birth, death, marriage dates. In this table, I also have military service dates (muster in / muster out), pension filing, residence in 1863 (draft date) and residence in 1890 (Veterans schedule).

In separate tables, I have the serviceman and separate links of sources that relate to the events mentioned in the bio table. The source table has source title, complete citation and URL.

So… is it possible to convert these spreadsheets (Google Sheets, but might be able to convert to Excel if needed) to CSV files to upload to Gramps?

If so, what are the steps I need to take?

I was able to follow the steps to convert the Google Sheets to CSV following the steps in this page Gramps 5.2 Wiki Manual - Manage Family Trees: CSV Import and Export - Gramps I just didn’t know if custom events and sources can also be converted.

Sorry if someone has asked this before. I’ve read the other CSV discussions and I think the answer is it’s not possible. However, I wanted to ask with these specifics to see if I’m incorrect in what I believe I’ve read.

Thanks in advance
Devon Lee

I think I’m using the latest Gramps edition (installed yesterday) and have Windows 11.

2

I see that there are Excel to Gedcom converters. These might work with some tinkering.

Makes it a two stage process, and the second stage could be interesting. Keep us informed.

Peter M.

1 Like
3

Most of the data can be imported with the standard CSV import features.

The other parts will take a bit of tweaking with a few SuperTool scripts for a custom solution.

But it all very possible.

4

What are the SuperTool scripts. I’m really looking for step-by-step so I can accomplish this goal. Any help would be appreciated.

5

SuperTool is a free Gramps addon from the Isotammi group. (A workgroup of Finland’s genealogical society.) It simplifies touching Gramps tree data directly with Python scripts. (When you Execute a script in SuperTool, it looks at what Category is active in the View. Then does all the niggling Python Initialization details to make that data easily accessible… down to the point of knowing which records are selected in the filtered view.)

There was a discussion thread just a week ago where the task was to update a couple thousand Source’s titles and abbreviations.

The user obviously had some programming background. But they discovered SuperTool and had a script that let them complete the task the following day.

In the final message, @Bigfoot shared a script that loaded a CSV file (with field name headers for source ID, title, abbrev), then parsed the CSV and overwrote that data in the Source view. Other than needing to paste in the path with filename for the CSV, the script is ready to run.

He did some parts in a somewhat unsafe way. (But that might just be my impression.) Instead of using the sandboxed virtual copy of the records that SuperTool offers for testing before committing, he worked directly on live data. Look at the SuperTool Help for lists of what all the fieldnames are in each view.

Also, please tell us if you are using the just released 5.2 version of Gramps. Both the CSV import and SuperTool have new 5.2 features.

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.