Tools

0 @T@ TOOL  ·  1 FORM .xlsx → .ged

Your Excel sheet, as a real family tree.

If your research lives in an Excel workbook, this turns it into a valid GEDCOM 5.5.1 file that Ancestry, MyHeritage, FamilySearch, Gramps, and every desktop program can import — with parents, spouses, and children properly linked. Drop the .xlsx straight in; there's no save-as-CSV step.

Drop an Excel file here (.xlsx)

One row per person, with whatever columns you have — names, dates, places, and ID columns for father, mother, and spouse. The first worksheet is used, and Excel date cells are understood. (CSV works here too.)

— or —

Nothing is uploaded. The spreadsheet is read and the GEDCOM file is built entirely in your browser.

…or paste rows straight from Excel

Copying cells in Excel or Google Sheets produces tab-separated text — paste it as-is, including the header row.

Real .xlsx files, read in your browser

The workbook is unpacked and read locally — the first worksheet becomes your people list. Excel's quirks are handled: date cells (which Excel stores internally as serial numbers like 31200) come out as proper dates, formatted numbers stay intact, and accented names survive. Only the modern .xlsx format is read; for an old binary .xls, save it as .xlsx first. Cells can also be pasted straight from an open workbook using the paste box above.

How the family links work

GEDCOM connects people through family records, not through columns — so the converter rebuilds them. Give each person an ID column (any text or number), then reference those IDs in Father ID, Mother ID, and Spouse ID columns. Children who share the same two parents are gathered into one family; a spouse pair with a marriage date becomes that family's marriage event. This is the part the old Excel2GED-style macros often lost, leaving you to reconnect everyone by hand.

Columns it understands

Name (or separate given/surname), sex, birth and death dates and places, father, mother, and spouse IDs, marriage date and place, occupation, and a free-text note. Headers are matched automatically — “First name”, “Born”, “DOB”, “Last name” and friends are all recognised — and you can correct any guess before downloading. A pre-made worksheet layout is available via the starter-template button; note that dates from before 1900, which Excel can't store as date values, should simply be typed as text (ABT 1850 and other GEDCOM date forms pass through untouched).

Working from a CSV instead?

There's a dedicated CSV to GEDCOM converter for comma-, semicolon-, and tab-separated files — same engine, tuned for plain-text exports from Google Sheets, Numbers, or a database.

Check the result

Open the downloaded file in the free viewer to see the tree you built, or run it through the GEDCOM validator before importing it anywhere.

More free GEDCOM tools: GEDCOM to PDF · GEDCOM to Excel · GEDCOM to CSV · CSV to GEDCOM · GEDCOM validator · GEDCOM to HTML · GEDCOM to JSON · GEDCOM to XML