Convert GEDCOM To Spreadsheet - Without Technical Knowhow

This is a walkthrough of converting a GEDCOM file to a spreadsheet using a helpful script and a Google website known as Google Colab.
Although this tutorial uses Python, you don't need any technical or programming knowledge. All you need is to type in a few commands and follow the instructions to run the script.
COMPANION ARTICLE:
www.datamining...

[@missjoy4u]

Thank you! That was awesome. I've been trying to learn Python, so this helps me struggle a little less!

[@DataMiningDNA]

Good to hear. Check out our Python playlist, we have more videos for beginners using Python with their family trees.

[@midwifelife]

Absolutely fantastic!! Thank you so much

[@peggydolane6775]

This is amazing! Thank you. Now I just need to learn how to auto convert genealogical dates to modern format.

[@19Bmiller]

This worked very, very well. The only errors I encountered were because I wasn't paying attention. Thank you

[@traceyrothgeb7807]

Worked like a charm!!! I am soooo excited! Thank you so much!

[@valauramiddleton686]

Worked perfectly as advertised. Thank you so much.

[@AmberMcBurney]

This worked fantastically! Thank you!! The hardest part was making that python code download LOL

[@mckennapat]

Many thanks for the excellent instructive video and I have now successfully imported my .ged file into Excel; mind you it would have been a lot quicker if I had followed your instructions.

[@CindyPerry-x2f]

How would you add spouse(s) and marriage(s)?

[@CindyPerry-x2f]

How do you add spouses and marriages to this spreadsheet

[@m3habeeb]

You are great, very professional. Thank

[@admissionband5114]

Excellent instructions. You really helped me a great deal - thank you very much!

[@grantbowser567]

Extremely helpful, thank you!

[@storytimewithmimi4561]

Agree with previous comment. Subscribed to your newsletter but when I try to download the script it is no longer available. Very frustrating to have gone through all the other steps for nothing. Would have been wonderful to create a spreadsheet from my bed on file. Back to square one.

[@nimrodshefi2046]

This is brilliant thank you. Gedcom has many more columns, so I was wondering how to get every piece of data in the gedcom onto the excel spreadsheets? For example, this generates only informaiton about the individual people, but no information about families in general. So I was wondering how to get a table or multiple tables if needed that show all the data that is stored in the gedcom file?

[@deecath6082]

Many thanks for this. A really useful exercise.

[@user-ew9zb3fw5w]

I subscribed to receive the script file but I haven't received anything

[@juliepeakall8886]

Where is the python script, I cannot find it anywhere.

[@ZEROHOURFISHING]

Excellent tutorial, thanks

[@patriciaandrews521]

Fantastic! Many thanks

[@TraHitt1]

Brilliant! Thank you very much

[@ConorODea]

great tutorial! thanks

[@zeroblank57]

Are you able to grab the relationship as well with this method? Another column that says "third great grandmother" and that type of thing? This is awesome btw! Thank you!

[@alicee.ridgway2672]

I got to the part where the print outputs the names but no XLSX file appears after running it

[@MarleneSorenson]

When I open the python_gedcom-1.0.0-py2.py3-none-any in Notepad it looks like wingdings. What am I doing wrong?

[@anrao]

Interesting... Subscribed, but not received confirmation email. Then I have to wait for the script.. Not sure if the script will be available (based on previous comments)

[@jaimystery1]

good video but useless without the python scrip you provide. i tried subscribing 3 days ago and never received anything. Also subscribed again today so maybe that will work.

[@BengtAlverborg]

Very educational. But the file only contains the birth place. I would like the full address information, e.g. also the country etc. How can I achieve that?

[@feyme0]

I subscribed to your newsletter via the link in the companion article....no script. Why don't you just add a direct link to the script or add the text of the script directly where we can copy/paste. A little frustrating to go through all of the steps and get hung up on that step. Appreciate the work, but several people have already cited the same issue, so why not fix for all.

[@the_blue_jeans]

Where is the companion article?

[@DataMiningDNA]

Sorry, I forget to put it into the description. The link is there now. And here too: www.dataminingdna.com/how-to-convert-a-gedcom-file-to-spreadsheet-python-colab/

[@keithbutt9411]

Couldn't access the python file even after subscribing and also tried the other file storage area

[@Elistarielle]

Sorry, but I have ADHD, It's been like 7 minutes and I'm struggling to pay attention, when does the actual tutorial start?

[@sarahmayj]

How long does it take for the email to come through with the script? I've been waiting a while and It's not in junk folder.

[@sharoncovington52]

Have an issue when I go to execute the script. Done it twice from scratch. I did use python-gedcom-2 instead if the one you suggested. Getting an error that states: Interrupt execution (Ctrl +M I) cell executed since last change Previous execution e ended unsuccessfully.

[@DataMiningDNA]

I had some issues with that package so I don't use it.

[@user-bj7rh3iq6z]

I had to write out the script and then run it. I had a couple of minor mistakes to correct but now I'm stuck. It's failing to write to the spreadsheet as it's saying first_name is not defined. I updated to 'first' and it then failed on last_name for same reason. I have triple-checked the script and I have it exactly. Why is this failing?

[@user-bj7rh3iq6z]

Figured it out - indenting improperly is killer.

[@jorgeortiz101]

Hello there. I have subscribed to receive the script file but I haven't received anything yet. Is it still available?

[@MegaRover04]

Hi, I am stuck at - Step 9: Paste The Python Script Into A Code Box. Where do I get this Python script, please?

[@MegaRover04]

I managed to get the Python file and successfully created the excel file. Thank you!

[@TheTjb1956]

Where abouts did you find The Python Script?@@MegaRover04

[@donames]

Hi there. Where did you get the script? I am unable to locate it. Thank you. Don

[@donames]

Gotta. Thanks anyway.

[@wilsonlegros1451]

@@donames Hello, on the script download page, there is a link that takes me to Microsoft One Drive, but it does not work. It's buggy... The page resets every two seconds. Did this work for you or did you receive the script by email?

[@user-oe1yw7eh9c]

So far so good but where to find the link to your script? - I am subscribed.

[@DataMiningDNA]

Ah, right. I think the easiest thing to do is to click on the subscribe option in step one of the linked article and you will be taken to the download link. Don't worry, you won't get the newsletter twice!

[@alicee.ridgway2672]

@@DataMiningDNAI just did that and ms says the file is no longer available?