Timeline to spreadsheet

Gramps 5 on macOS

The Quick View - Timeline has a lot of good information but sometimes I’d like to get it into a spreadsheet for analysis. But that seems to be pretty difficult.

The best I’ve found is:

-bring up a Timeline like the following

-right click and Select All
-switch to a text editor and paste
-save the file as a csv
-switch to a spreadsheet program and import the csv file
=Problem is that the commas embedded in the various fields cause the spreadsheet to split the data quite differently from how it was displayed in the Timeline view.

Is there a better approach?


Maybe a feature request to add an “Age” column to the Events category view? Then you could just do a CSV export from that view. Such export already includes quotes around the columns that contain commas.

Actually, I guess that suggestion wouldn’t work. It would have to be calculated as the age of the primary person in each event, and in the case of events such as marriage which have more than one primary person, then it couldn’t be calculated.

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