Skip to main content

DNA Info Lab team · Editorial review · · 5 min read

23andMe Raw Data File Explained: Format, Columns & Limits

What is the 23andMe raw data file? A tab-separated text file of roughly 640,000 rows on 23andMe's current chip, with four columns — rsid, chromosome, position and genotype. It records ~0.02% of your genome at carefully chosen positions. Below: what each field means, the genome build, no-calls, and the limits.

What the file actually is

When you download your data from 23andMe you get a zipped (.zip) text file whose name begins with “genome”. Unzipped, it is plain text: a short header explaining the file — it says the fields are tab-separated and names the reference build — then one row per genetic position the chip measured. NCI researchers who reconstructed 23andMe's current (v5) chip from users' files describe it as a custom Global Screening Array with 642,824 SNPs, so expect roughly 640,000 rows. It stores the letters at those positions, not the whole genome.

The four columns

rsidchromosomepositiongenotype
rs49882352136608646AG
rs1801133111856378--
rs60251169519049CT
rs4293581945411941CT

The rsid column gives you an identifier to investigate. Enter one in our public rsID lookup to explore reference information and source links. You do not need to upload the file or enter a genotype.

Genome build: GRCh37 / hg19

The position numbers are relative to a reference build. By default 23andMe reports genotypes on the plus strand of GRCh37 (“Build 37”) — hg19 in UCSC's naming — and the header of the downloaded file names build 37; its online raw-data browser also shows GRCh38 positions. This matters if you cross-reference positions with a database on a different build (e.g. GRCh38) — the coordinates will not line up. Matching by rsid avoids the problem, which is why our analysis matches on rsid.

No-calls: -- and 0

Not every position reads cleanly. When 23andMe's algorithm cannot make a confident call, the downloaded file shows -- instead of a two-letter genotype; AncestryDNA files write 0 in both allele columns instead, and our parser treats that as a no-call too. 23andMe says a number of no-calls are expected, more often on X, Y and mitochondrial markers. A no-call simply means that position is skipped in any analysis.

Why it is not your whole genome

A microarray genotypes specific, pre-chosen positions — roughly 640,000 of the genome's about 3 billion nucleotides (~0.02%). 23andMe describes its chip, a custom version of the Illumina Global Screening Array, as including variants in medically relevant genes, variants with known disease associations, variants involved in drug processing, trait variants and ancestry markers. That makes the file useful for looking up well-studied variants, but it will not contain rare private mutations that were not on the chip. For that you need whole-genome sequencing.

How to open it

It is just text — any editor opens it, though roughly 640,000 rows can be slow in a word processor. To actually interpret it, either look up individual rsids by hand in SNPedia/dbSNP, or upload the whole file to a tool that cross-references it against curated research.

Frequently asked questions

Can I open the 23andMe raw file in Excel?▼

Yes. It is tab-separated text, and 23andMe itself suggests a text editor or Excel. With roughly 640,000 rows it may be slow; a plain text editor or an analysis tool is lighter.

What genome build does 23andMe use?▼

GRCh37 (Build 37, hg19 in UCSC naming) by default, and the downloaded file names build 37 in its header; 23andMe's online raw-data browser also shows GRCh38. Match variants by rsid rather than position to avoid build mismatches.

What does -- mean in the genotype column?▼

It is a no-call: 23andMe could not make a confident genotype call at that position. No-calls are skipped in analysis, and 23andMe says a number of them are expected.

Is the raw file my complete DNA?▼

No. It covers ~0.02% of your genome — the pre-selected positions on the chip. It is enough for common-variant risk and trait analysis but not for rare private mutations.

Already have your raw DNA file?

Explore the matches, explanations, limits and sources available for your file.

Want to see what the file looks like inside? An annotated example of the four columns →

Related articles

This article is for educational purposes only and does not constitute medical advice, diagnosis or treatment. Always consult a healthcare professional for decisions about your health.