How to make an org chart from a CSV file

A CSV file is just a spreadsheet saved as plain text — and it happens to be the perfect raw material for an org chart. If you can get your team into a CSV with a few key columns, you can turn it into a clean, navigable org chart in about a minute, without drawing a single box by hand.

This guide walks through exactly how: how to format the CSV, how to build the chart from it, and how to fix the handful of errors that trip most people up.

Why CSV is the right starting point

Almost every system that holds employee data — HR platforms, payroll tools, spreadsheets — can export to CSV. It's the universal format. And an org chart, underneath the visuals, is really just structured data: a list of people and who each one reports to. CSV captures exactly that. So instead of manually drawing your organization, you let a tool read the CSV and construct the hierarchy for you.

And if you've only ever worked in Excel or Google Sheets, don't let the word "CSV" slow you down — a CSV is a spreadsheet, just saved as plain text, and it's a one-click "Save As" away. Better still, most good tools (OrgPlease! included) take your Excel file directly, so in practice you often don't convert anything at all — you just upload the sheet you already have.

Step 1: Get the three columns right

Your CSV needs three essential columns. Everything else is optional.

Name — how the person should appear on the chart.
Email — the unique identifier for each person. Emails are ideal because they're guaranteed unique; two people might share a name, but never an email.
Manager's email — the column that defines the hierarchy. Each person's row points to their manager by that manager's email. The single person at the very top (CEO, owner, executive director) leaves this blank.

A minimal CSV looks like this:

Name,Email,Manager Email
Dana Reed,dana@company.com,
Sam Patel,sam@company.com,dana@company.com
Alex Kim,alex@company.com,dana@company.com
Jordan Lee,jordan@company.com,sam@company.com

In that example, Dana is at the top (blank manager), Sam and Alex report to Dana, and Jordan reports to Sam. A tool reading this builds the whole tree automatically.

Want a head start? Download a sample CSV with the columns set up — open it, swap in your team, and upload.

Step 2: Add optional columns (if you want)

Once the three essentials are in place, you can enrich the chart with extra columns — these become the detail shown on each person's card:

Job title
Department or team
Location or office
Employee ID or start date

You don't need any of these to build a working chart, but they make it far more useful. Title and department are the two most commonly added.

Step 3: Export your CSV cleanly

How you get the CSV depends on where your data lives:

From an HR system (BambooHR, Gusto, Rippling, ADP): look for an "export" or "reports" option and choose CSV. Most can export a team list including manager relationships directly.
From a spreadsheet (Excel, Google Sheets): use File → Download / Save As → CSV. Make sure your column headers are in the first row.
From scratch: create a new sheet with the three columns and fill it in. For a small team this takes only a few minutes.

One tip: keep the header names simple and clear. Most good tools match columns case-insensitively and accept common variations (for example, Manager Email, Supervisor Email, or Reports To all meaning the same thing), but clean headers reduce the chance of a mismatch.

Step 4: Upload and build the chart

Upload your file to an org-chart tool that reads it and constructs the hierarchy. With a purpose-built tool, this takes seconds — the columns are detected, the manager-email links are resolved, and the chart appears. You don't have to convert to CSV first if your data is in Excel: tools like OrgPlease! accept an .xlsx file directly, so you can upload the spreadsheet exactly as it is. (OrgPlease! is built for exactly this: upload the roster, get the chart in about 60 seconds. It's our tool, so judge accordingly.) Try OrgPlease! free →

Step 5: Fix the common errors

Most charts come out right on the first try. When something looks off, it's almost always one of these:

A person floating at the top, disconnected: their manager-email is blank (when it shouldn't be) or doesn't exactly match any email in the file. Check for typos.
Two or more people at the top: more than one row has a blank manager-email. Only the actual top person should be blank; everyone else needs a valid manager-email.
A circular reference: Person A reports to B, who reports to A. The tool can't build a tree from a loop. Find and fix the incorrect row.
Duplicate people: the same person appears in two rows with slightly different emails. Standardize to one email per person.
Mismatched emails: the manager-email is spelled differently than that manager's actual email row (for example, rob@ vs robert@). They must match exactly.

The fix for nearly all of these is the same: correct the value in your CSV and re-upload. Because the chart is generated from data, you never fix the chart directly — you fix the data, and the chart follows.

Step 6: Share and export

Once the chart looks right:

Share a live link so colleagues can view the current structure without needing the file.
Export to PDF for board decks, onboarding materials, or printing — or to PNG for a quick shareable image.
Keep it current by re-uploading an updated CSV whenever your team changes — or, with some tools, editing rows directly on the chart.

Why this beats drawing it by hand

The whole advantage of the CSV approach is that your org chart becomes maintainable. When someone joins, leaves, or changes managers, you don't hunt through a diagram dragging boxes — you update one row of data and regenerate. For a team that changes even a few times a year, this is the difference between an org chart that's always current and one that's perpetually out of date in a file named "Org Chart FINAL v3."

Bottom line

Making an org chart from a CSV comes down to three columns — name, email, manager's email — a clean export, and a tool that reads the file. Get the manager-email links right and the hierarchy builds itself in about a minute. Best of all, it stays easy to update: change the data, regenerate the chart, done.

Three columns, one upload, sixty seconds. Try OrgPlease! free up to 25 people — no credit card. orgplease.com