Excel to Org Chart: Free Options and How to Build One

Charts & pivot tables · Updated November 19, 2026

Yes—if you already have access to desktop Excel, you can make an org chart at no extra charge using SmartArt. Excel itself is not universally free, and a list of employees in a worksheet will not automatically become a chart: you need to arrange the reporting relationships in a hierarchy.

What free means when making an org chart in Excel

The org chart feature is part of Excel’s SmartArt graphics, rather than a separate paid add-in. If Excel is already included with your work or school account, or you have a licensed desktop copy, creating the chart does not usually require buying another tool. The cost of access to Excel is a separate matter: Microsoft 365 subscriptions are paid, and a desktop license is not the same thing as a free download.

Microsoft offers Excel for the web at no charge with a Microsoft account, but its capabilities are not identical to the desktop application. SmartArt authoring may be limited or unavailable in the web app, depending on the current experience available to your account. If you do not see SmartArt on the Insert tab, you may need desktop Excel to create the graphic. You can still use a spreadsheet to organize your employee information and then build the chart in another free diagramming tool.

So the practical answer depends on what you mean by free: SmartArt can be an included feature when you already have compatible Excel, but Excel is not a free, full-featured org-chart service for everyone.

What Excel can and cannot do

Excel does not have a dedicated org-chart chart type that reads a table of staff and automatically infers who reports to whom. Its built-in option is a SmartArt hierarchy graphic. You place people into the right levels and connect them visually. This works well for a compact department chart, a project team, or a simple organization with a clear chain of command.

A common source list has columns such as Employee, Job Title, and Reports To. That table is useful for checking names and relationships, but simply selecting it and choosing Insert Chart will not produce an org chart. SmartArt uses an outline-like hierarchy, so you must enter the people in the correct order and level, or add and move shapes after creating the graphic.

Excel is therefore a reasonable choice when the chart is small and you want it beside other spreadsheet information. It is less convenient when the organization is large, changes frequently, has many cross-functional relationships, or needs automatic layout from a maintained employee directory.

Prepare the reporting data first

Before drawing, make a clean source list and confirm each person’s manager. A simple table might contain one row per employee and columns for name, role, and reports-to name. For example, Maya Chen, Operations Director, reports to Jordan Lee; Dev Patel, Warehouse Manager, reports to Maya Chen. The chart should put Jordan at the top, Maya beneath Jordan, and Dev beneath Maya.

Check for common data problems before building the graphic:

  • Use one consistent spelling for each person’s name, especially when the same name appears in the Reports To column.
  • Make sure the top person has no manager within the chart, and that every other person has the intended reporting relationship.
  • Decide whether to show job titles, departments, locations, or only names. Extra details make shapes larger and the chart harder to scan.
  • Choose the scope. A chart for one department is easier to read than a single page showing every employee in a large organization.

This source table is valuable even though it does not automatically generate SmartArt. It gives you a record to check against the finished diagram and makes later revisions less error-prone.

Create the org chart with SmartArt

In desktop Excel for Microsoft 365 on Windows, create a blank worksheet or open the workbook that will hold the chart. Use the ribbon path Insert > SmartArt > Hierarchy, choose Organization Chart, and select OK. The chart appears with a text pane where you can enter the hierarchy. On Mac, use the Insert tab and choose SmartArt, then select a hierarchy layout; names of buttons and the ribbon arrangement can differ slightly by version.

  1. Click the first text-pane entry and type the name and, if useful, job title of the top person.
  2. Press Enter to add another entry, then use the text-pane indent controls to set whether that person is a subordinate or a peer. Indented entries appear at a lower reporting level; entries at the same level are peers.
  3. Continue entering employees in reporting order. For example, put a director below the chief executive, then indent that director’s team one level further.
  4. Review the chart against your source table. If someone is at the wrong level, change the outline indentation or select the person’s shape and use the SmartArt Design tab’s Add Shape options to insert a subordinate, peer, or assistant.

The exact outline behavior is worth checking as you go: pressing Enter creates another item, while changing its level determines where it sits in the structure. Do not assume that pasting rows from a three-column employee table will preserve the Reports To relationships. A pasted list needs to be converted into a correctly indented outline, and each employee must be placed under the appropriate manager.

Format and lay out the chart

Once the hierarchy is correct, select the SmartArt graphic to show its contextual design options. Use the SmartArt Design tab to try a layout or change the color treatment; use the Format tab to adjust an individual shape’s appearance. A standard organization-chart layout is often clearest for a conventional top-down structure. If the chart is too wide, a layout that distributes subordinates may use the page more effectively, although it can take more effort to follow the reporting lines.

Keep the design readable rather than decorative. Use consistent wording for job titles, avoid shrinking text until it is difficult to read, and give the graphic enough worksheet space. If you need the chart in a report, select the chart and copy it into a document or presentation, then check how it looks at the final printed or displayed size. A chart that fits on a monitor may become cramped when printed on a standard page.

Updating and sharing the chart

SmartArt is a visual graphic, not a live view of an employee database. When someone changes role or a new person joins, you need to edit the text and hierarchy yourself. For a small team, this is usually straightforward. For a larger organization, keep the source table as the authoritative list and schedule a check of the diagram after staffing changes. Otherwise, the chart can look polished while showing out-of-date reporting lines.

Save the workbook in Excel format if recipients need to edit the SmartArt. If you share a PDF or image, people can view or print it, but the chart will no longer be editable as a SmartArt object. When sharing employee information, include only details the intended audience needs. Names and reporting relationships can be sensitive organizational information, so follow your workplace’s sharing and storage rules.

Free alternatives if SmartArt is unavailable

If you do not have desktop Excel or cannot create SmartArt in the web app, a free diagramming tool may be a better route. diagrams.net, also known as draw.io, offers diagram editing and can use CSV-based diagram creation. That is not a one-click conversion of any Excel staff list: you need to prepare the data and configure how rows become people and connections. For a small chart, creating and arranging boxes manually may be quicker than setting up an import.

LibreOffice Draw is another free desktop option for drawing boxes and connector lines. It is a general-purpose drawing application, so expect to position and format the chart yourself rather than relying on an automatic employee-directory connection. Google Sheets can hold the employee list, but it does not turn an ordinary reporting table into a finished org chart automatically either.

Before choosing an alternative, consider whether collaborators need to edit the chart, whether the tool supports the file format you need, and whether your organization permits employee data to be uploaded to an online service. You can also keep the spreadsheet local and enter only the necessary names and roles into a diagram.

Common problems to avoid

  • Everyone appears at the same level: the entries were not indented into subordinate levels. Correct the outline rather than rearranging boxes randomly.
  • The chart is too crowded: split it into department-level charts or reduce optional information. Making the font tiny rarely fixes the underlying problem.
  • A manager is missing: check whether the person was omitted from the outline or placed under the wrong branch.
  • The chart becomes stale: SmartArt does not automatically synchronize with the source table. Update both, and verify that they agree.

One misconception is that an org chart is simply a normal Excel chart with names in rows. It is not: the key information is the parent-child relationship between people, which a plain list does not communicate unless you explicitly arrange it.

Frequently Asked Questions

Can I make an org chart in Excel for free?
If you already have a version of desktop Excel that includes SmartArt, you can create the graphic without buying a separate org-chart add-in. Excel itself may require a subscription or license, so it is not free for every user.

Can Excel automatically create an org chart from a spreadsheet?
Not from a standard employee table with no extra setup. Excel’s SmartArt hierarchy requires you to enter or arrange the reporting levels. A compatible diagramming tool may support CSV-based creation, but the data still needs suitable structure and mapping.

Does Excel for the web have org charts?
The web version is not the same as desktop Excel for creating SmartArt. Check the Insert tab in your account; if SmartArt creation is not offered, use desktop Excel or a diagramming alternative.

Can I edit an Excel org chart after sharing it?
Yes, if you share the workbook and the recipient can open it in an application that supports editing the SmartArt. A PDF or image is convenient for viewing, but it is not an editable SmartArt chart.

What is the easiest free alternative to Excel SmartArt?
For a small chart, a free diagram editor such as diagrams.net or LibreOffice Draw can work. The easiest choice depends on whether you want to arrange shapes manually or prepare data for a CSV-based diagram, and on your organization’s data-sharing rules.

Related

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.