GEDCOM to Excel — every person in a spreadsheet
Convert a GEDCOM (.ged) family tree into an Excel workbook: one row per person with names, birth, death and burial dates and places, occupation, parents, spouses and children. In your browser, nothing uploaded.
About this conversion
A spreadsheet is the quickest way to sort a tree by birthplace, count everyone born in one village, or hand the list to a relative who has no genealogy program. Every person becomes one row: given names and surname, sex, birth, death and burial with date and place, occupation, father and mother, spouses with the marriage date and place, children and notes. The file's own IDs are kept in the first columns, so the same sheet can be corrected in Excel and turned back into a GEDCOM file here without losing who belongs to whom. Dates are written the way people read them — “12 Mar 1890”, “about 1850”; the rare ones that would not read back exactly, like dates in the Julian or Hebrew calendar, keep their GEDCOM form. Sources, photos and less common events stay in the .ged — the sheet carries everyone and how they are related.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same tree, other ways
The tree stays open after it is read, so the format is picked at the end: the same file can leave here as PDF, Word (.docx), CSV, HTML, TXT, JSON, PNG, JPG, XML or SVG. Before that you can walk through it person by person, print it as a chart or a book, find people who were entered twice, hide the living, and correct names and dates.
Questions
- Can I edit the sheet and turn it back into GEDCOM?
- Yes. Keep the ID, Father ID, Mother ID and Spouse IDs columns, change what you need, and drop the sheet on the Excel to GEDCOM page.
- Does it open in Google Sheets and Numbers?
- Yes — it is a standard .xlsx file.