This app is provided 'as-is' for alpha-testing. Updated January 16, 2025. See below for providing feedback.
The Genealogy Friends of Plano Libraries DNA SIG meeting on January 15, 2025 focused on a method to download DNA match data from 23&Me. The method allows download of data for up to 1500 matches in a single download. The method for capturing all of this data is described on the GenealogyExplained website in a video, which can also be found on YouTube (https://youtu.be/22T7lhuPgAE)
Basically, the method involves capturing the data in JSON format, as follows:
1. Use a chromium browser (Chrome, Edge, Vivaldi, Opera, etc.)
2. Sign in to 23&Me and go to your DNA Match list page (‘DNA Relatives’)
3. Click control-Shift -I – this opens a new pane (for developers)
4. Click the Network tab in the ‘new pane’
5. Refresh the browser page and let matches reload.
6. In the ‘new pane’, type ‘ajax’ into the filter box
a. You should see 2 files; click the one that does not have the word ‘limit’
b. This provides match data in the JSON format in the response tab
c. Up to 1500 matches are captured
7. Click inside the response text then:
a. Click CTRL-a (CMD-a on a Mac). This selects all JSON data
b. Click CTRL-c (CMD-c on a Mac). This copies the JSON data
8. Open Notepad and paste the data into Notepad. Then save the text file.
The webpage on the GenealogyExplained.com site has an app to convert the JSON file into a CSV file, which can be imported into a spreadsheet. The below app tabulates the data directly, adding a conversion of %DNA to approximate centiMorgans, and converting country codes into country names. The app was generated using Claude 3.5 Sonnet. Copy the text file to clipboard (CTRL-a then CTRL-c), and paste into the below paste box. Once the data have been tabulated, click 'Copy Data to Clipboard', and paste the tabulated data into a spreadsheet.
If an error occurs in tabulation, please tell the developer at colleyvillegenealogy@gmail.com, providing as much detail as possible. If the app is working well for you, feedback is also appreciated.