VCF to CSV / Excel

Turn a VCF file into a table that opens in Excel and Google Sheets.

or drop the file here

Learn more

What's in the table

  • chromosome, position — the variant's chromosome and position.
  • rsid — the SNP identifier, if the VCF has one.
  • ref, alt — reference and alternative alleles.
  • gt — the genotype as in the VCF, e.g. 0/1.
  • genotype — the same genotype in letters, e.g. A/G.

Opening it in Excel

  • Both .vcf and .vcf.gz files work. The first sample of the file is used.
  • If everything lands in one column: Data → From Text/CSV, comma as the delimiter.
  • Excel shows at most 1,048,576 rows. A whole genome VCF is longer — open it in parts or in R/Python.

Why is it useful?

A table makes it easy to look up your genotype by rsID, filter a chromosome or share the data with a genetic counselor without special software.

Frequently asked questions

Will the table open in Excel?

Yes. If everything lands in one column, open the file via Data → From Text/CSV with a comma delimiter. Excel shows at most 1,048,576 rows, so a whole genome VCF is easier to open in R, Python or in parts.

What does the genotype column mean?

It's the genotype in letters: 0/1 with REF A and ALT G becomes A/G. A missing allele is shown as “-”.

Which files work?

Files in .vcf and .vcf.gz, bgzip included. If the VCF has several samples, the first one is used.

Can I open AncestryDNA or MyHeritage raw data this way?

There's no need to convert them: those files are already tables and open in Excel directly. This page handles VCF only.

Is it safe?

Yes. The file is processed right in your browser, on your device: it is never sent to our server or shared with anyone. Nothing is kept after you close the tab.

Other tools

Where to upload the result — services catalog