Step-by-step tutorial
How to make a genogram in Excel
Quick answer

Why people try to make genograms in Excel
Excel is on nearly every work and school computer, and its cell grid looks temptingly like graph paper. Snap to Grid even gives it a real edge over Word for keeping generations in straight rows. But a spreadsheet is not a canvas: there are no genogram symbols, no clinical templates, and shapes float precariously above cells that can resize underneath them. Below, we walk through every step honestly, including where Excel falls apart.
How to make a genogram in Excel: 8 steps
- 1
Set Up the Excel Grid as a Drawing Canvas
Excel's cell grid can act like graph paper. Resize the columns so cells become small squares, which makes alignment far easier than a blank Word page.
- Open a blank workbook and click the Select All corner (above row 1, left of column A)
- Set a narrow column width so each cell is roughly square with the row height (about 2 in width units, or drag until the column pixel width matches the row pixel height)
- Zoom out to 70-80% so you can see several generations at once
- Turn off unneeded worksheet elements if you want a cleaner canvas (in the View options, you can hide gridlines later before exporting)
Tip: Column width and row height use different units in Excel, so match them by the pixel value shown in the tooltip while dragging, not the number itself.
- 2
Insert Shapes for Each Family Member
Use Insert > Shapes to draw squares for males and circles for females, following standard genogram notation.
- Go to Insert > Shapes and pick Rectangle for males
- Pick Oval and hold Shift while dragging to draw a perfect circle for females
- Keep every shape the same size: draw one, then copy-paste (Ctrl+C, Ctrl+V) or duplicate (Ctrl+D) for each person
- For a deceased person, layer two short diagonal lines over the shape to form an X
- For the index person (the client or self), give the shape a thicker outline via the shape outline weight setting
Tip: Set the fill to white or no fill and the outline to black before duplicating your first shape. Every copy inherits the formatting, so you only style once.
- 3
Arrange People by Generation Using Snap to Grid
Place each generation in its own horizontal band of rows. Excel's Snap to Grid makes shapes align to cell edges automatically.
- Enable Snap to Grid from the shape alignment options (under the drawing/shape format tools, in the Align menu)
- Reserve the top rows for grandparents, the middle band for parents, and the bottom band for the index person and siblings
- Leave 3-5 empty cell columns between people in the same generation for connector lines
- Leave 4-6 empty rows between generations so vertical lines have room
- Center children beneath the midpoint between their two parents
Tip: Snap to Grid is Excel's biggest advantage over Word for genograms: shapes click into cell boundaries, so rows stay straight without manual nudging.
- 4
Connect Partners and Children with Elbow Connectors
Excel's elbow connectors attach to shapes and stay attached when you move them, which is better than drawing free-floating lines.
- Go to Insert > Shapes and choose Elbow Connector (or a straight Line for simple horizontal links)
- Hover over a shape until connection points appear on its edges, then drag from one shape's connection point to another
- Draw a horizontal line between married partners, connecting the bottom or side points of their shapes
- Drop vertical connectors from the partner line area down to each child's shape
- For divorce, layer two short diagonal line shapes across the partner line; one slash indicates separation
Tip: Connectors that snap to connection points (they show as small dots when you hover) will follow shapes when moved. Free-drawn lines will not, so always attach both ends.
- 5
Add Names and Dates with Text
Label every person with their name, birth year, and death year if applicable.
- Right-click a shape and choose Edit Text to type the name and birth year inside it
- Use a small font (8-9pt) so text fits within the shape
- For longer notes (occupation, diagnosis, dates), insert a text box just below the shape
- Remove the text box outline and fill so only the words show
- Do not type labels into the worksheet cells behind the shapes; cell text will not move with the shapes and will misalign the moment anything shifts
Tip: Group each shape with its text box (select both, then Group) so labels travel with the person when you rearrange the chart.
- 6
Try the SmartArt Hierarchy Shortcut (and Know Its Limits)
SmartArt's Hierarchy layouts can rough out a descendant chart in minutes, but they cannot produce a true genogram.
- Go to Insert > SmartArt and choose a Hierarchy layout (such as an organization-chart style)
- Type names in the text pane; press Tab to demote a person to the next generation down
- SmartArt auto-spaces and auto-aligns everything, which is fast for a simple one-parent-line family tree
- The catch: SmartArt only supports one parent per node, so it cannot draw marriage lines or partner pairs
- It also cannot use circles for females and squares for males within the same layout, so standard genogram notation is impossible
Tip: Use SmartArt only as a quick draft of who belongs where, then rebuild with manual shapes, or skip Excel entirely for anything clinical.
- 7
Mark Relationship Types on the Lines
Adjust line styles to distinguish marriage, divorce, cohabitation, and other relationship statuses.
- Solid line = marriage (the default connector style)
- Dashed line = cohabitation (change via the shape outline dash options)
- Dotted line = dating or engagement
- Two manual slashes across the line = divorce; one slash = separation
- Excel has no wavy, zigzag, or double-line connectors, so emotional relationship notation (close, conflicted, enmeshed, cut-off) cannot be drawn properly
Tip: If you must indicate an emotional relationship, add a small text annotation near the line, but note this is a workaround, not standard McGoldrick notation.
- 8
Set the Print Area and Export to PDF
Define exactly which cells contain your genogram, then export a clean copy.
- Select the cell range covering the whole genogram, then set it as the Print Area (Page Layout > Print Area > Set Print Area)
- Switch page orientation to Landscape in the Page Layout settings
- Use the scale-to-fit options to force the chart onto one page (fit to 1 page wide by 1 page tall)
- Hide worksheet gridlines before exporting if you want a white background (uncheck Gridlines in the View options)
- Save or export as PDF (File > Save As or File > Export, choosing PDF), since Excel has no native PNG export for a sheet
Tip: Always preview before exporting. Excel loves to split charts across page breaks, and a genogram cut in half between generations is unusable.
| Relationship | How to draw it in Excel | Standard genogram notation |
|---|---|---|
| Marriage | Solid connector (default) | Solid horizontal line |
| Cohabitation | Dashed outline on the connector | Dashed line |
| Separation | One short line shape across the partner line | One slash |
| Divorce | Two short line shapes across the partner line | Two slashes |
| Close, conflicted, cut-off | Not possible; text annotation only | Double, zigzag and broken lines (see the symbols guide) |
The problem with genograms in Excel
No Standard Genogram Symbols
Relationship-Line Spaghetti
Shapes Detach When Rows Resize
A Spreadsheet Is Not a Canvas
No Clinical Templates
Painful Reflow When Adding People
Excel or GenogramAI?
| Microsoft Excel | GenogramAI | |
|---|---|---|
| Setup Time | Resize grid, configure shapes manually | Open browser, start immediately |
| Creating Symbols | Generic rectangles, ovals, lines | Built-in McGoldrick-style symbols |
| Emotional Relationships | Not supported (solid/dash/dot only) | Close, conflicted, enmeshed, cut-off, and more |
| Medical Quadrants | Not possible | 4 quadrants per person |
| AI Generation | Not available | Text-to-genogram in under a minute |
| Time to Complete | 2-4 hours for 3 generations | 5-15 minutes by hand, under a minute with AI |
| Adding a Person Mid-Chart | Manually shift every shape over | Smart repositioning |
| Export | Print area + PDF workaround | PNG free; PDF and SVG on paid plans |
| Cost | Requires Microsoft 365 ($70-100/yr) | Free (2 genograms, 5 AI credits a month) or $12/mo |
Real comparison
Skip the spreadsheet: describe your family instead
Instead of hours in Excel, type this:
AI Builds It for You
Standardized Clinical Symbols
Clean Exports in One Click
Genogram in Excel: FAQs
Can you make a genogram in Excel?
Yes, you can make a basic genogram in Excel using Insert > Shapes for squares (males), circles (females), and elbow connectors for relationship lines. Excel's Snap to Grid actually makes alignment easier than in Word. However, Excel has no genogram symbols, no emotional relationship lines, and no medical quadrants, so it only works for simple family-tree-style diagrams, not clinical genograms.
Is there a free genogram template for Excel?
Excel does not include a built-in genogram template. Some websites offer downloadable .xlsx genogram templates, but they are just pre-drawn shapes on a worksheet: hard to edit, missing clinical symbols, and prone to breaking when rows resize. GenogramAI's free plan includes 2 genograms with standardized symbols, 5 AI credits a month and PNG export, which is a more practical free option than an Excel template.
How do I make family tree connectors in Excel?
Use Insert > Shapes and choose the Elbow Connector. Hover over a shape until connection points appear on its edges, then drag from one shape's connection point to another. Connectors attached this way stay linked when you move the shapes. Free-drawn lines do not follow shapes, which is the most common reason Excel genograms fall apart during editing.
Can I use SmartArt to make a genogram in Excel?
SmartArt's Hierarchy layouts can quickly draft a simple descendant chart, but they cannot make a real genogram. SmartArt supports only one parent per node, so there is no way to draw marriage lines or partner pairs, and every node uses the same shape, so you cannot use squares for males and circles for females. It is useful as a rough draft at best.
How long does it take to make a genogram in Excel?
A basic 3-generation genogram with 10-15 family members typically takes 2-4 hours in Excel, covering grid setup, shape placement, connectors, labels, and export cleanup. The same genogram takes 5-15 minutes to build by hand in GenogramAI, or under a minute using its AI text-to-genogram feature.
How do I export a genogram from Excel as an image?
Excel has no native PNG export for a worksheet. The usual workarounds are: set the Print Area around your genogram and export to PDF, take a screenshot, or select all the shapes, copy them, and paste them into another program as a picture. For clinical documentation that needs clean image files, a dedicated genogram tool with one-click export is far more reliable.
What is the best alternative to making a genogram in Excel?
GenogramAI is the best alternative to Excel for genograms. It is purpose-built for clinical genograms with standard McGoldrick-style symbols, structural and emotional relationship types, medical quadrants, clinical templates, AI generation from a text description, and one-click export. It runs in any web browser with no installation and offers a free plan.