Step-by-Step Guide

How to Create an Org Chart from Excel or CSV

Creating an org chart from a spreadsheet should take ten minutes. In practice, it often takes an afternoon — because the data isn't clean, the tools require specific formats, and something always goes wrong. This guide covers every step, every common mistake, and how to use AI to skip the painful parts.

Step-by-Step: Spreadsheet to Org Chart

1

Open your spreadsheet and add the required columns

Start with a blank spreadsheet or your existing employee list. Add the following columns as the first row:

Name | Title | Department | Manager

Name and Manager are the only two columns that are strictly required. Title and Department improve the output quality significantly.

2

Enter one row per person

Each person gets exactly one row. Enter their name in the Name column and their manager's name in the Manager column. The Manager column must contain the exact name as it appears in the Name column for that person.

Name,Title,Department,Manager
James Carter,CEO,Executive,
Sarah Chen,CPO,HR,James Carter
Tom Walsh,CTO,Engineering,James Carter
Priya Nair,HR Director,HR,Sarah Chen

Leave the Manager field blank for the top of the hierarchy (typically the CEO). Do not type “N/A” or “-” — just leave it empty.

3

Check for name consistency

The most common reason org chart tools fail to build the hierarchy correctly is name inconsistency. Before you export, scan both the Name and Manager columns for these issues:

  • !Name uses middle initiale.g., "Tom Walsh" in Name, "Thomas P. Walsh" in Manager
  • !Abbreviated first namee.g., "Jennifer Brown" in Name, "Jen Brown" in Manager
  • !Extra spacese.g., "Sarah Chen " (trailing space) vs "Sarah Chen"
  • !Different capitalisatione.g., "sarah chen" vs "Sarah Chen"
  • !Title in name fielde.g., "Tom Walsh (CTO)" vs "Tom Walsh"

OrgBrief's AI catches most of these automatically, but it is faster to fix them in the source file.

4

Export as CSV

Save your file as a .csv (comma-separated values). In Excel, use:

Excel

File → Save As → CSV (Comma delimited) (.csv)

Google Sheets

File → Download → Comma-separated values (.csv)

5

Upload to OrgBrief and review

Upload the CSV file to OrgBrief. The AI reads your data, normalises names, infers any missing relationships from job titles, and generates the org chart. The whole process takes under 30 seconds for a 100-person organisation.

Any relationship that the AI inferred (rather than read directly from the data) gets a confidence score. Review low-confidence links before exporting. High-confidence links can be auto-approved.

The 7 Most Common CSV Formatting Mistakes

These are the issues that cause org chart tools to produce broken hierarchies, orphaned nodes, or silent failures.

01

Circular references

Person A reports to Person B, who reports to Person A. This creates an infinite loop. Usually caused by copy-paste errors. OrgBrief will flag this as an error.

02

Multiple people with the same name

Two "John Smiths" in the same org creates ambiguity. Add a middle initial or department suffix to distinguish them: "John Smith (Finance)" and "John Smith (Engineering)".

03

The CEO has a manager listed

Some HR exports include a "Board" or "Shareholders" as the CEO's manager. Most org chart tools will include this as an extra node. Either remove it or add a note in a separate column.

04

Merged cells in Excel

Merged cells in Excel don't export cleanly to CSV. Before exporting, select all cells, unmerge everything (Format > Merge & Center > Unmerge Cells), and fill down any blank cells.

05

Text in number columns

"50 people", "~30", or "TBC" in headcount columns breaks numeric parsing. Keep structured columns strictly typed.

06

Blank rows between data rows

Blank rows in the middle of your data cause most parsers to stop reading at the first blank row. Delete all blank rows before exporting.

07

Non-UTF-8 characters

Names with accents (Müller, García, Nguyen) can corrupt if the file is not saved as UTF-8. In Excel, use "CSV UTF-8 (Comma delimited)" when saving.

Manual Approach vs. AI-Assisted: What's the Real Difference?

The manual approach — export CSV, clean in Excel, import into Lucidchart or Visio, style, export — works. It produces a good result if you have clean data and time to spare. But the data is almost never clean, and time is almost never available. Here is what the two approaches actually look like in practice:

Manual approach

  • 1.Export CSV from HRIS
  • 2.Spend 30 min cleaning data (name mismatches, blank cells, merged cells)
  • 3.Import into Lucidchart or Visio
  • 4.Spend 1 hour fixing layout, styling boxes
  • 5.Add logo and brand colours manually
  • 6.Export as PDF
  • 7.Client asks for an edit — repeat from step 3

Typical time: 3–5 hours

AI-assisted (OrgBrief)

  • 1.Export CSV from HRIS (or use whatever format you have)
  • 2.Upload to OrgBrief
  • 3.Review AI-generated hierarchy (30 seconds)
  • 4.One-click export as PDF or PowerPoint
  • 5.Client asks for an edit — re-upload updated CSV

Typical time: under 5 minutes

Your CSV is probably fine as-is

OrgBrief was designed to handle real-world data — inconsistent names, missing managers, partial information. Upload what you have and let the AI do the cleaning.

Upload your first CSV freeTry it free

Related guides

Org Chart Template: Free Excel & CSV Templates for 2025

Download free templates to format your data for any org chart tool.

Best Org Chart Software for Executive Search Firms (2025)

A frank comparison of every tool that claims to solve the org chart problem.

Executive Search Org Charts: How to Map and Present Client Hierarchies

Best practices for presenting org charts in exec search engagements.