Importing 23Andme Data: A Guide For Dna Painter Users

DNA Painter is a tool that allows users to visualise their DNA results and map chromosome segments to ancestors. To import 23andMe data into DNA Painter, users must first download their raw genetic data from 23andMe. This can be done by accessing the Browse Raw Genotyping Data section of the 23andMe website and confirming the date of birth associated with the profile. Once the data has been downloaded, it can be imported into DNA Painter by clicking on the settings button above the chromosomes and selecting Import segment data. It's important to note that the file being imported should be in CSV format and contain segment data, rather than raw DNA data. Additionally, a subscription to DNA Painter is required to utilise the import functionality.

Navigate to the import function

To navigate to the import function in DNA Painter, you must first ensure you have an active subscription to the service. Then, you can follow these steps:

• Go into any of your chromosome maps.
• Click on the 'settings' button above the chromosomes.
• Click on 'Import segment data'.
• If you haven't yet created a map, you can do so by clicking on the provided link.

Importing a DNA Painter Map

You can download a CSV file from a DNA Painter map by visiting 'All segment data'. To do this, click on the settings cog icon above chromosome 1 and find the '.csv file' link in the top left corner.

Importing a Custom File of Segments

You can also import a custom file of segments that you create. Files for import need to be in CSV format. To create your own file, use the provided template, ensuring that the header row remains intact. You can fill out the template in a spreadsheet program (e.g. Excel or Google Docs) or in a text editor. If you use a text editor, do not use commas in the data you enter for each field.

Importing 23andMe Ancestry Composition Data

To import data from 23andMe, click on the settings cog above chromosome 1 in the map you want to use. Then, click on 'Import 23andMe ancestry composition'. You will then see a blank form, which will ask you to indicate whether 'copy 1' and 'copy 2' are consistently identifiable. This will only be the case if you have a parent tested at 23andMe.

Download a CSV file from a DNA Painter map

To download a CSV file from a DNA Painter map, you must first visit the 'All segment data' page. You can do this by clicking on the settings cog icon above chromosome 1. Once you have done this, you will find the 'All segment data' page under 'Reports'. Finally, click on the '.csv file' link at the top left of the page. Alternatively, you can import a custom file of segments that you create.

To create your own file, you can use a template, which can be found on the DNA Painter website. The template is in a comma-separated-values (CSV) format and can be filled out in a spreadsheet programme (e.g. Excel or Google Docs) or in a text editor. If you use a text editor, you will need to ensure that you do not use commas in the data you enter for each field.

It is important to note that the file you download or create must be in CSV format. This is because the DNA Painter site will only recognise this format.

If you are using Gedmatch, you can subscribe to their Tier 1 tools, which will enable you to download a 'Segment Search' report. This is a segment list for any DNA kit, and it is a CSV file in the same format as the main uploaded file. You can then import this into a DNA Painter chromosome map.

If you have tested your DNA with 23andMe, you can import this data into DNA Painter by first clicking on the settings cog above chromosome 1 in the map you want to use. Then, click 'Import 23andme ancestry composition'. You will then see a blank form, which will ask you to tell DNA Painter if 'copy 1' and 'copy 2' are consistently identifiable. This will only be the case if you have a parent who has also been tested by 23andMe.

Copy and paste 23andMe ancestry composition segments into DNA Painter

To copy and paste 23andMe ancestry composition segments into DNA Painter, you must first download your 23andMe data. To do this, log in to your 23andMe account and hover over the 'Ancestry' navigation item. Click on ''Ancestry Composition' and scroll down to the 'Download Raw Data' button. It is important to note that this is not your raw DNA file, but rather the file with the segment coordinates you need.

Once you have downloaded your data, open the CSV file and copy and paste the contents into the import form in DNA Painter. You can reach the import function by going into any of your chromosome maps and clicking on the 'settings' button above the chromosomes. Then, click 'Import segment data'. After pasting your data into the form, click 'Save segments'. A new group will now be imported for each ancestral population in the file.

If you have identified a parent who has also been tested by 23andMe, the segments will be listed as either ''copy 1' or 'copy 2'. In this case, you will need to tell DNA Painter if 'copy 1' and 'copy 2' are consistently identifiable.

In addition to 23andMe, you can also import population segment data from FamilyTreeDNA. This feature is called 'Chromosome Painter' and can be accessed by logging in to FamilyTreeDNA.com and downloading your data.

By importing your 23andMe ancestry composition segments into DNA Painter, you can visualise your DNA results and map chromosome segments to ancestors. This can help you verify how you have assigned segments in your chromosome map and confirm other matches.

Import 23andMe ancestry composition data

To import 23andMe ancestry composition data into DNA Painter, you will need to have a DNA Painter subscription. You will also need to have already taken an autosomal DNA test, such as the ones provided by 23andMe.

To import the data, first, click on the settings cog above chromosome 1 in your chromosome map. Then, click 'Import 23andMe ancestry composition'. You will then see a blank form, which will ask you to tell DNA Painter if 'copy 1' and 'copy 2' are consistently identifiable. This will only be the case if you have a parent who has also been tested by 23andMe.

Next, open the CSV file and copy and paste the contents into the blank form. After that, click 'Save segments'. A new group will now be imported for each ancestral population in the file.

It is important to note that the file you are importing is not your raw DNA file. Instead, it is a file containing the coordinates for each segment that you share with your matches.

Save segments

To save segments when importing 23andMe data to DNA Painter, you need to first download the data from 23andMe. This can be done by navigating to the 23andMe Ancestry Composition page and clicking the "Download raw data" button. The data will include a "copy" column, and segments will be listed as either "copy 1" or "copy 2".

Next, open DNA Painter and click on the settings cog above chromosome 1 in the map you want to use. Then, click on "Import 23andMe ancestry composition". You will see a blank form asking if "copy 1" and "copy 2" are consistently identifiable. This will only be the case if you have a parent tested on 23andMe.

After filling out the form, open the CSV file and copy and paste the contents into the form. Finally, click the "Save segments" button. A new group will now be imported for each ancestral population in the file.

It is important to note that DNA Painter does not use raw DNA data. Instead, it uses a file containing the coordinates for each segment you share with your matches. This file can be directly imported from your testing company in the form of a CSV file or a custom file. The CSV file format must be retained during the upload process, and certain fields are compulsory, such as the chromosome number, start and end position for the segment, the number of centimorgans shared, and the name of the person with whom you share the segment.

Frequently asked questions