Converting Ancestry Gedcom file in MS Excel or another s/w prog.......

[valcolb]

Having a large f/t via Ancestry, I want to be able to analyse and collate persons so I can group, for example, all those married or buried in a particular church to make visiting a village more interesting, or those born or died during a certain period to look into epidemics, blitzes, etc.  I have used Gramps to create a CSV and then imported the result into Excel.  The problem starts there - is there a way of creating column headings in the Excel sheet that match Gedcom's fields so I end up with a clean, legible, searchable database?  I am using excel 2010 and for obvious reasons would like to keep costs to a minimum or even zero.  Any and all comments welcomed (um, well, the useful ones !) . Ta muchly. Colin.

[valcolb]

a subsequent question to my Gedcom to Excel query:   Apache's Open Office Base software?

[bluesofa]

I don't use GRAMPS but I downloaded it and had a quick look. The CSV appears to be in the format as described here
https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export#Export

The CSV file is divided into 4 sections (separated by a blank row): Places, Individuals, Marriages, Families

Once imported to a spreadsheet program, the Individuals section appears to have much of the information you require, except places are identified by an ID reference.  The ID reference is described in the Places section.  You could use a spreadsheet function, such as vlookup, to join these together to give you a single table. This should be possible in Excel 2010 or a free spreadsheet program.

Alternatively, Gramps users may be able to describe how to export specifically the data you require (for example the Places Text Report may be helpful).

There may also be other free software which will allow you to create spreadsheets with only the data you want more easily. For example, Family Tree Analyzer (http://ftanalyzer.com/) will allow you to export all "Facts" to a spreadsheet which perhaps suits your needs.

[valcolb]

Many thanks for the pointer to the Analyzer app....it may be just the job. 
Long may your Sofa be Blue!

[Garthkh]

Hi. RootsMagic is able to define groups that you can put profiles into.  It's not free (about US$30 once off)  You can download it and use it free but will not open the many options.  The free version is able to download directly from Ancestry and FamilySearch, and upload a new tree into Ancestry. The licensed version will sync with both. Lots of user help available on their sites and in a FaceBook group.
Hope this helps

[KGarrad]

You will probably need a script to manage this task?
A Gedcom file is a complicated beast! Try opening a Gedcom file in a basic editor, like Notepsd.

But there ways. Try this:
https://dataminingdna.com/how-to-convert-a-gedcom-file-to-spreadsheet-python-colab/

[Garthkh]

Yes it is complicated and needs code.
I found a fellow on YouTube who take one through a tutorial on using VBA. I followed it right through and it works but he stopped short of sorting the relationships out. I contacted him and he has sent me some code to look through which I'm slowly doing. Hopefully, I'll get to understand it.