AI Prompts & Code for Ancestry Match Spreadsheet

INSTRUCTIONS

[1] Download your Ancestry DNA matches to a text file.

Watch the first six minutes of this video for full instructions.

[2] Log into Google Colab (Free) and upload your DNA match file.

Watch from 08:40 to 11:00 of this video for instructions.

[3] Copy the Python script into a new Notebook on Google Colab

[4] Edit the name of your DNA match file at the top of the script.

[5] Run the script.

[6] Download the output file and import into Google Sheets or Microsoft Excel

Watch from 37:20 to 38:30 of this video for instructions.

[7] Import the file into Google Sheets or Microsoft Excel.