How to make an org chart in Google Slides that updates from a sheet
By Jake Marsh · Updated
To make an org chart in Google Slides from a spreadsheet, list your people in Google Sheets with a name and a Reports to column, open Extensions, Rowtree, Open org chart, and click New deck under Google Slides on the Export tab. Rowtree draws the chart and creates a deck with it. When the sheet changes, choose Update charts in Slides and Docs from the same menu and the chart is redrawn in that deck. New Doc does the same for Google Docs.
Why not draw it in Slides
Slides and Docs have diagram tools and templates where you type each box and draw each line by hand. That's fine for six people. For a company that changes every month, every hire means moving boxes again, and the slide and the HR spreadsheet slowly stop agreeing. Making the chart from the sheet means the sheet stays the one place you edit.
Steps
- Set up the sheet: one person per row, with headers. Name and Reports to are required; add Job title, Department and a Photo URL if you want them on the cards.
- Open the chart from Extensions, Rowtree, Open org chart, and fix anything listed under Problems first, such as a manager who isn't in the sheet.
- Shape it for a slide. On Layout, Left to right often fits a wide slide better than Top down for deep orgs. Stacking teams of individual contributors keeps wide teams narrow.
- Split a big org. On Export, set Pages to Split into pages by team and choose Cards per page, at most (8 to 36). Each team gets its own slide with a title.
- Click New deck. Rowtree creates a Google Slides deck with one slide per page and gives you a link to open it.
- Add your own slides around the chart slides if you like: an intro, a hiring plan, anything else.
Updating the deck later
After the sheet changes, choose Extensions, Rowtree, Update charts in Slides and Docs. Every deck and Doc made from this spreadsheet is redrawn with the same settings that made it. In a deck, the chart images and slide titles are replaced, slides are added if the org now needs more, and leftover chart slides are removed. Slides you added yourself are left alone. The Export tab also lists each linked file with Update from sheet to update just that one, and Forget to stop updating it.
Google Docs
New Doc creates a Google Doc with the chart, one page per team if you split it. Use it for a handbook page or an org summary you share as a document. An update rewrites the Doc's body with the new chart, so keep any writing you want to keep in a separate Doc and link to it.
What lands in Slides
The chart goes in as a picture, drawn sharp at slide size. To change a name or a title, change the sheet and update; that way the deck and the sheet can't drift apart. If you need the chart in a different tool, the same tab downloads PNG, SVG and PDF.
What it costs
Rowtree is $99 a month or $999 a year per Google account. Free trial: 14 days or 10 exported charts, whichever comes first. No card needed. Every plan and the install link are on the Rowtree page.
Rowtree: Org Chart from Google Sheets
Org charts from a Google Sheet: dotted lines, open roles, your own order, and charts in Slides and Docs that update from the sheet $99 a month or $999 a year per Google account.
Questions
Can I see when a deck was last updated?
Yes. The Export tab lists each linked deck and Doc with when it was last updated and by whom, plus a link to open it.
Does Rowtree need access to all my Slides files?
No. It can open only the decks and Docs it created. That's also why it can't add a chart to a deck it didn't make.
Can I put the chart in an existing deck?
Make it with New deck, then move your existing slides into that deck. Rowtree keeps updating its own chart slides and leaves the rest.
Does each update use a trial chart?
The trial counts exported charts. The same chart sent to several places counts once.
More Rowtree guides
More Google guides
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to share only part of a Google Sheet (Rowsplit)
- How to make a copy of a template tab for each name in a list (Tabherd)
- How to create barcodes in Google Sheets (Rowcode)