Org chart maker

How to make an org chart from a list

1. In your spreadsheet, select the columns Name, Title and Reports to (plus Department if you have one), header row included, and copy them.
2. Paste into Paste your list in place of the example and tap Make the chart. If a column was read wrongly, fix it under Columns: which is which.
3. Read Checks: anyone whose manager is not in the list, or who sits in a reporting loop, is shown there and drawn in the orange Unplaced group until you correct the name.
4. Pick Top-down, Compact (a manager's reports who manage nobody are stacked in one column, which saves width) or Left to right. Tap a box to edit a person, mark an assistant or add a photo.
5. Save it: PNG for slides, SVG for design programs, PDF to print on A4, A3, Letter or Tabloid, CSV to keep the list. Or make a share link.

How the list is read and laid out

Tabs (what a spreadsheet puts on the clipboard), commas or semicolons separate the columns; quoted cells may hold commas. The first row counts as a header when two or more of its cells are column names the page knows, such as Name, Job title, Manager, Reports to, Department, Team, Employee ID or Dotted line. Without a header the columns are read in the order Name, Title, Reports to, Department. Names are matched ignoring capital letters and extra spaces, so ana lopez finds Ana Lopez, but a nickname or a typo does not.

For example, these six rows:

Name,Title,Reports to
Ana,CEO,
Bo,CTO,Ana
Cy,Developer,Bo
Di,Developer,Bo
Ed,CFO,Ana

give Ana at the top with two direct reports, Bo and Ed, and Bo with two of his own. Every manager's whole branch gets its own band of columns and each level its own row, so boxes never overlap, however long the names. Ten people who all report to one manager need ten boxes side by side top-down (about 2,000 pixels wide); Compact stacks them in one column barely wider than one box.

What it cannot do

• No sync with an HR or payroll system: it draws the list you paste. When people change, paste the new list (or edit the CSV) again.
• A matrix organisation is shown as a tree plus dashed lines: each person has one place in the chart, under their main manager, and dashed lines to any dotted-line manager.
• Over about 300 people it gets slow on a phone, because the whole chart is laid out and redrawn after each change: measured on a desktop computer, 300 people take about 50 ms and 2,000 (the limit) about 0.3 s, and a phone takes several times longer. Fields are cut at 200 characters.
• Two people with exactly the same name are both drawn, but anyone who reports to that name goes under the first. Add an ID column and put IDs in Reports to to tell them apart.
• The PDF uses Helvetica, so a chart with letters outside Western European alphabets (or emoji) goes into the PDF as a high-resolution picture instead of text.
• A share link over 2,000 characters may be cut by some chat apps; with short names and titles that is about 150 people (100 people made a 1,254-character link in our test). The page tells you the length; send the CSV instead for a big chart.

Privacy and what is stored

Nothing you paste leaves your device. The page sends an anonymous page-view count and, when you first change the chart or export it, one of two fixed words (orgchart-make, orgchart-export), never a name or a file name. The list, layout and collapsed branches are kept in this browser's local storage; photos are cropped to a square here and kept in this browser's IndexedDB, and they are never put in a share link or sent anywhere. Clear the list and all photos removes everything in one tap. A share link carries the list after the #, which browsers do not send to any server; opening one shows it as a copy and saves nothing until you tap Save this copy on this device. The PDF library (pdf-lib, MIT licence) is loaded from this site only when you first ask for a PDF.

Questions

Is this org chart maker free, with no sign-up?

Yes. No account, no trial, no watermark and no limit on people up to 2,000. The chart is drawn in your browser and kept in this browser's storage, so the names you paste are not sent anywhere.

How do I make an org chart from a spreadsheet?

Select the columns Name, Title and Reports to (and Department if you have it) in Excel, Google Sheets or Numbers, copy, and paste into the box. A header row such as Name, Job title, Manager is recognised; if your columns are in another order, pick each one under Columns. A saved .csv file can be opened directly. The Reports to cell must hold the manager's name exactly as it appears in the Name column, or their ID if you add an ID column.

Can I make an org chart online for free on a phone?

Yes. The page works in a phone browser with nothing to install: paste or type the list, tap a box to edit that person, pinch to zoom and drag to pan. Charts over about 300 people get slow on a phone because the whole chart is laid out again after each change.

What if someone reports to two managers?

Put the main manager in Reports to and the second one in a Dotted line to column (or the field in the form). The person is placed under the main manager and a dashed line runs to the second. A full matrix organisation is shown this way: a tree plus dashed lines.

How do I print a big org chart?

Choose the paper (A4, A3, Letter or Tabloid, all landscape) and either Fit to one page, which scales the whole chart down, or Tile at full size, which keeps the boxes at their on-screen size and spreads the chart over as many pages as it needs. The page count is shown before you save. For a wall chart, A3 or Tabloid tiled is usually the readable choice.

Are the photos uploaded or put in the share link?

No. A photo is cropped to a square in your browser and kept in this browser's IndexedDB storage on this device. Share links carry names, titles and departments only, so whoever opens one sees the chart without photos. Clear removes the list and every photo in one tap.