Org Chart Template for Google Sheets

To make an org chart in Google Sheets, put each person or position in column A and that person’s manager in column B, then select the data and choose Insert > Chart; in the Chart editor, set Chart type to Organizational chart. Sheets builds a connected hierarchy from those relationships, so you can start with a simple table instead of downloading a separate template.

What a Google Sheets org chart template does

An organizational chart shows who reports to whom. It can make a company’s management structure easier to scan, clarify team responsibilities, and help people find the right reporting line. In Sheets, the chart can be generated from rows of data, which is useful when the structure changes and you want a visual linked to a source list.

The word template can mean two different things here. It may mean a preformatted spreadsheet file with boxes and connectors already arranged, or it may mean a reusable data layout that produces a chart. Google Sheets has an Organizational chart chart type, but a dedicated org-chart file is not necessarily available in every template gallery or account. The built-in chart is often the quickest starting point; a manually drawn diagram is better when precise placement and styling matter more than data-driven updates.

A chart is a view of the reporting relationships you enter, not an HR system that verifies them. It will not determine the correct manager, resolve conflicting records, or decide which roles belong in the organization. Check the source data before sharing the diagram.

Choose between the chart and a manual layout

Use the built-in chart when the main goal is to show a hierarchy from a list and you expect to update names or reporting lines. It is especially suitable for a small or medium team whose structure fits a straightforward tree. Since the chart is based on cells, changes to the included data can be reflected in the chart without rebuilding every box by hand.

Choose a manual diagram if the organization has complex cross-functional relationships, dotted-line reporting, many departments that need separate visual groupings, or a strict design requirement. A standard org chart communicates one main parent-child relationship per person or position. It is not a good way to show every project connection or collaboration link at once.

Built-in Organizational chart: best for a simple hierarchy generated from rows and columns.
Manual drawing in Sheets: useful when you need more control over individual boxes, labels, and placement, but updates take manual editing.
Google Slides or a dedicated diagram tool: worth considering for a presentation-ready chart, complex layouts, or a diagram that needs more visual control than a spreadsheet chart provides.

You can also keep a data-driven chart for routine updates and create a separate polished diagram for presentations. That separates the maintained source list from a design that may need deliberate rearrangement.

Prepare the source data

Use one row per person or position. The first column identifies the person or role, and the second column identifies their direct manager. The manager value should match the identifying value used for that manager elsewhere in the first column. A top-level leader has no parent, so leave that manager cell blank. If the chart includes a header row, label the columns clearly, such as Employee and Manager.

For example, a small team could be represented like this:

Employee: Morgan Lee; Manager: blank
Employee: Priya Shah; Manager: Morgan Lee
Employee: Devin Park; Manager: Morgan Lee
Employee: Alex Chen; Manager: Priya Shah

This data says Morgan is at the top, Priya and Devin report to Morgan, and Alex reports to Priya. The order of the rows is less important than making the parent references consistent. Use the same spelling, punctuation, and spacing in a person’s manager entry as in that person’s own row.

Keep labels unique when possible. Two employees named Jordan Kim can make a chart difficult to interpret and may make parent references unclear. Add a role, department, or other short distinguishing detail to the displayed label, such as Jordan Kim — Sales, if that suits your audience. If your source records use employee IDs, keep those in a separate column for administration; do not assume the chart will display a hidden identifier the way you want.

Before inserting the chart, check for blank names, misspelled manager values, accidental self-reporting, and reporting loops. A manager must also appear as a node in the list if you expect that person to appear in the chart. For a large organization, decide whether the diagram should include every employee or only the leadership and teams relevant to its readers.

Create the chart in Google Sheets

Open the spreadsheet in Google Sheets in a web browser. Put the person or role labels in the first column and their manager labels in the second. Include a header row if you want the columns identified clearly.
Select the data range, including the headers if present. If you have a third column for extra information, include it only if you intend to use it as chart tooltip text.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually at the right side of the window.
In the Chart editor’s Setup tab, open the Chart type menu and choose Organizational chart. Confirm that the data range covers the intended rows and that the correct columns are being used.
Close the Chart editor when the chart looks right. Drag the chart to reposition it on the sheet and use its handles to resize it. Keep the source table available so you can check or edit the underlying relationships later.

If Sheets selects a different chart type automatically, changing the type in the Setup tab is the key step. The org chart is generated from the selected cell range, so it is not the same as inserting a static picture. When you update a name or manager in the chart’s source range, the displayed hierarchy can update with the data.

For a chart that should include future hires, consider how its source range is defined. If the chart uses a fixed range that ends at the current last row, rows added below that range may not be included automatically. Recheck the chart’s data range after adding records, or leave suitable blank rows within the range if that fits your workflow. Avoid including unrelated notes or totals in the selected range.

Format the chart and make it readable

Organizational charts become hard to use when they try to show too much. Keep labels short enough to fit, use consistent naming conventions, and decide whether the chart is about people, job titles, or both. For example, Name — Role can be informative, but long names combined with long job titles may make nodes crowded.

Use the Chart editor’s Customize tab to review the options available for the selected chart type. Google Sheets provides chart-specific settings, and the exact controls depend on the chart. Do not expect the same fine-grained control as a hand-built diagram: a data-driven chart may not let you position every box independently or make every node a different shape. If a setting you need is not available, consider a manual diagram rather than spending time trying to force the chart into a design it does not support.

Give the chart a clear title, such as Customer Support Team Structure, if readers might confuse it with other charts.
Keep the source columns close to the chart or give the data its own clearly labeled tab.
Test the chart at the size people will actually view it. A hierarchy that looks fine on a large monitor may be difficult to read when printed or viewed on a phone.
For a printed copy, use print preview and check whether the chart is clipped or scaled too small. A wide chart may need a landscape page or a larger paper size.

Color can help distinguish departments, but do not rely on color alone to communicate reporting relationships. Clear labels and the connecting hierarchy should carry the meaning. If the chart is shared with people who use screen readers or need an accessible text version, retain the underlying table and provide a short written description of the structure.

Keep the chart updated and share it carefully

A spreadsheet chart is only as current as its source data. Assign an owner to maintain the reporting list, and agree on whether it reflects current employees, approved positions, or a planned future structure. Those are different views; labeling the chart with its purpose and an updated date can prevent readers from treating a draft or outdated version as authoritative.

Google Sheets sharing permissions apply to the spreadsheet. Use the Share button to choose who can view, comment on, or edit the file, and review link access before distributing it. A person who can edit the source data may be able to change the reporting relationships as well as the visual. If readers only need the chart, consider whether a view-only link or an appropriately prepared export is more suitable than broad edit access.

Org charts can reveal names, roles, team structures, and sometimes sensitive staffing plans. Include only information needed for the intended audience. Follow your organization’s rules for employee information and confirm permissions before sharing outside the team. A chart is not private simply because it is on a separate tab; access is controlled at the file level unless you use a different sharing arrangement.

Common problems and practical fixes

A person appears disconnected: check that the manager’s label exactly matches a node in the first column and that the manager row is included in the chart range.
The hierarchy looks wrong: verify the manager column, remove accidental spaces or inconsistent spellings, and check that no one has been assigned the wrong parent.
A manager is missing: add that manager as a row, even if the person has no manager in the chart, and leave the parent cell blank for the top-level node.
New rows do not appear: inspect the chart’s data range in the Setup tab. The newly added rows may fall outside the range used by the chart.
The chart is crowded: show fewer levels, shorten labels, split the organization into department-level charts, or use a manual diagram for a more controlled presentation.
The chart does not represent dotted-line work: treat the chart as the primary reporting structure and explain secondary relationships separately. A basic hierarchy is not a complete map of collaboration.

One common misconception is that a spreadsheet can infer the organization from a list of job titles. It cannot reliably do that: the manager or parent relationship must be supplied in the data. Another is that a chart automatically becomes a polished template. It provides a useful structure, but checking labels, readability, scope, and sharing settings remains part of making a dependable chart.

Frequently Asked Questions

Does Google Sheets have an org chart template?
Sheets includes an Organizational chart chart type that can turn a parent-and-child data table into a hierarchy. A dedicated predesigned org chart file may not be available in the template gallery, so the built-in chart is a practical template-like starting point.

What columns do I need for an org chart in Google Sheets?
Use one column for each person or position and another for that node’s manager or parent. Leave the top-level person’s parent blank. Make parent labels match the corresponding node labels so the hierarchy can be connected correctly.

Can the chart update when I change the spreadsheet?
Edits to the included source data can update the chart. However, new rows may be outside a fixed chart range, so check the data range when adding people. A manually drawn chart does not update from the table automatically.

Can I show two managers for one employee?
A basic organizational chart is designed around a hierarchy, not multiple simultaneous reporting lines. If you need to show a dotted-line or matrix relationship, explain it in a separate table or use a diagramming method that supports more complex connections.

Is Google Sheets different from Excel for this?
Yes. These instructions describe Google Sheets in a web browser and its Organizational chart chart type. Excel has different chart tools and menus, so the Sheets menu path should not be assumed to apply in Excel.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.