YourAITools

Org Chart Builder Skill

Your HR export, as an org chart you can share, with the broken reporting lines found first.

Org Chart Builder Skill product illustration

What it does

Turn the employee export you already have (BambooHR, Gusto, Rippling, Workday, ADP or a spreadsheet) into an org chart in one command. It also checks the reporting lines, which is where most org charts go wrong. Runs on your computer, so employee data never leaves it. Python 3.9+, no installs, and a Claude Code skill (skills/org-chart/).

$ python3 -m orgchart examples/hris-export.csv --out orgchart/
43 people, 2 open positions, 13 managers, 4 levels; median 2 direct reports per manager
Maya Okafor - Chief Executive Officer  [4 direct]
|-- Daniel Reyes - VP Engineering  [3 direct]
|   |-- Arjun Mehta - Engineering Manager, Platform  [14 direct]
...
Checks (4 errors, 2 warnings, 3 notes):
  ERROR MANAGER_NOT_FOUND  line 42   Diego Torres: manager id E150 is not in the file
  ERROR CYCLE              line 43   reporting loop: Wei Zhang -> Fatima Noor -> Wei Zhang; the loop is broken at Wei Zhang
  ERROR SELF_MANAGER       line 46   Sara Lind is listed as their own manager
  ERROR DUPLICATE_ID       line 47   employee id E271 is used 2 times; this row is skipped, line 39 is used
  ...

What you get

The screenshot is real output from the kit’s own commands. Tested from a fresh download of this exact zip: ./run_tests.sh ran 5 tests OK on Python 3.13 and 3.10.

Real terminal output from Org Chart Builder Skill: demo and passing tests

Output files

FileUse it for
orgchart.htmla standalone page that opens in any browser: collapsible boxes, a search box, open positions dashed. Email it or put it on the intranet
orgchart.mmdMermaid: paste into Notion, GitHub, GitLab, Confluence (Mermaid app) or mermaid.live
orgchart-drawio.csvdraw.io / diagrams.net: Arrange > Insert > Advanced > CSV, paste, Import. The boxes are laid out as a tree and stay editable
orgchart.dotGraphviz: dot -Tsvg orgchart.dot -o orgchart.svg
orgchart.txtplain-text tree
checks.mdcounts, departments, columns used and every finding with its line number

Checks

CheckMeaning
MANAGER_NOT_FOUNDthe manager id or name isn't in the file (left, typo, or another entity)
CYCLEA reports to B, B reports to A (or a longer loop); the loop is broken so the chart still draws
SELF_MANAGER / DUPLICATE_ID / AMBIGUOUS_MANAGERown manager; the same employee id twice; two people with the manager's name
MULTIPLE_TOPmore than one person without a manager (often contractors or a missing CEO row)
VACANT / VACANT_MANAGERopen positions ("Open", "TBH", "Vacant" or no name), including ones with people under them
WIDE_SPANa manager with more direct reports than --wide-span (default 12)

These are checks on the structure of the file. They say nothing about any person's performance.

Options

  • --root "Daniel Reyes" (or an employee id or email) charts one person's organization. --depth 3 stops after 3 levels.
  • --title "Engineering, Nov 2026". --dept shows departments in the boxes.
  • Columns are found by name: employee id, full name (or first + last), job title, manager id (or manager name / reports to), department, location and email. If yours are named differently, use --col-id, --col-name, --col-manager-id, --col-manager, --col-title or --col-department.
  • --json for scripts. Exit code 1 when there are reporting-line errors (the charts are still written), 2 when the file can't be read.
  • Excel: save as CSV UTF-8 first.

./demo.sh runs it on the examples. ./run_tests.sh runs the tests.

Employee files are personal data: keep the outputs where your HR data is allowed to be.

Related: Employee Census Checker Skill cleans the census for benefits renewals: https://youraitools.co/marketplace/employee-census-checker-skill. CSV Compare & Reconcile shows what changed between two exports: https://youraitools.co/marketplace/csv-compare-reconcile-skill

Honest limits

  • Excel: save as CSV UTF-8 first.
  • Employee files are personal data: keep the outputs where your HR data is allowed to be.

Format and license

Zip, 19 KB, v1.0, 15 files. You may use and modify this kit for your own work and for clients you serve, including paid client work. Not affiliated with or endorsed by any HR software vendor or JGraph (draw.io).

FAQ

Which HR systems?
Any CSV with names and managers: BambooHR, Gusto, Rippling, Workday, ADP or a spreadsheet.
Does it upload employee data?
No, it runs on your computer.
Can I edit the chart?
Yes, import orgchart-drawio.csv into draw.io, or edit the Mermaid text.
How do I get the files?
Right after payment, Stripe’s confirmation page shows your download link.
Refunds?
Email hello@youraitools.co within 14 days if it doesn’t work and we can’t fix it.
Can I pay with crypto?
Yes. Pay the same price in USDC or USDT on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana from the "Pay with crypto" button, with no account or KYC. We check the payment on-chain and show your download links as soon as it confirms.

Get Org Chart Builder Skill

Create an org chart from a CSV or HRIS export: HTML, Mermaid, draw.io and Graphviz. Finds missing managers, reporting loops and duplicate IDs. Runs locally.

$19 one-time

Buy and downloadPay with crypto

Pairs well with

Download$119

Agent Builder Bundle

Swarm Operator Kit + x402 Builder Skills + MCP Starter Kit. $119 instead of $157.

View Agent Builder Bundle
Download$89

Swarm Operator Kit

Run a team of AI agents as a business: charter, 5 roles, 6 skills, routines and scripts.

View Swarm Operator Kit
Download$29

x402 Builder Skills

4 SKILL.md skills to ship, audit, verify and list a pay-per-call x402 API.

View x402 Builder Skills

Related