Free online GEDCOM to XLSX converter

Genealogy applications export GEDCOM files, but spreadsheet workflows often require XLSX for sorting, filtering, and adding columns. Converting the data makes it easier to review people and dates in spreadsheet software, though family relationships are not preserved as spreadsheet relationships.

What the GEDCOM format is

GEDCOM is a plain-text format for exchanging genealogical records, including people, dates, and family links. Genealogy programs such as Gramps, RootsMagic, and Family Tree Maker can create or import GEDCOM files; you may also receive one when exchanging a family tree. GEDCOM is a genealogy format, not a graphics format.

What the XLSX format is

XLSX is the spreadsheet workbook format used by Microsoft Excel and supported by LibreOffice Calc and other spreadsheet applications. It stores data in worksheets, where columns can be sorted, filtered, formatted, and used in formulas. A workbook can present genealogy records as tables, but it does not inherently represent GEDCOM’s linked family structure.

How to convert GEDCOM to XLSX

Online on 101convert.com

1. Open the GEDCOM-to-XLSX converter on 101convert.com and upload the GEDCOM file.
2. Choose XLSX as the output format and start the conversion.
3. Download the converted workbook. The page supports batch conversion; its per-file size limit is shown there.

Offline with desktop software

For a local conversion, Python 3 with the openpyxl package can turn common person fields into a worksheet. This method works on Windows, macOS, and Linux; it creates a simple people table rather than a complete genealogy workbook.

Install the package with python -m pip install openpyxl, save the following as gedcom_to_xlsx.py, then run python gedcom_to_xlsx.py family.ged family.xlsx (replace the input filename as needed):

import re
import sys
from openpyxl import Workbook

source, destination = sys.argv[1:3]
people = {}
person = None
event = None

with open(source, encoding="utf-8-sig", errors="replace") as ged:
    for line in ged:
        match = re.match(r"(\d+)\s+(.*)", line.rstrip())
        if not match:
            continue
        level, rest = int(match.group(1)), match.group(2)

        if level == 0:
            record = re.match(r"@([^@]+)@\s+(\S+)", rest)
            person = record.group(1) if record and record.group(2) == "INDI" else None
            if person:
                people[person] = {"ID": person, "Name": "", "Sex": "",
                                  "Birth date": "", "Death date": "",
                                  "Family as child": [], "Families as spouse": []}
            event = None
            continue
        if person is None:
            continue

        parts = rest.split(None, 1)
        tag = parts[0]
        value = parts[1] if len(parts) == 2 else ""
        if level == 1:
            event = tag if tag in ("BIRT", "DEAT") else None
            if tag == "NAME":
                people[person]["Name"] = value
            elif tag == "SEX":
                people[person]["Sex"] = value
            elif tag in ("FAMC", "FAMS"):
                column = "Family as child" if tag == "FAMC" else "Families as spouse"
                people[person][column].append(value.strip("@"))
        elif level == 2 and tag == "DATE" and event:
            column = "Birth date" if event == "BIRT" else "Death date"
            people[person][column] = value

workbook = Workbook()
sheet = workbook.active
sheet.title = "People"
columns = ["ID", "Name", "Sex", "Birth date", "Death date",
           "Family as child", "Families as spouse"]
sheet.append(columns)
for row in people.values():
    sheet.append(["; ".join(row[col]) if isinstance(row[col], list) else row[col]
                  for col in columns])
workbook.save(destination)

Quality and limitations

The script extracts individual IDs, names, sex, birth and death dates, and family-record references. It does not export notes, places, sources, events beyond birth and death, or family records as their own worksheet; review the result before relying on it for a complete tree. For richer exports, use a genealogy application that can report or export the specific records you need, then open its tabular output in a spreadsheet program and save it as XLSX.