Monday, December 30, 2013

Google Trix! - Automatic Org charts on google spreadsheet

I was recently looking for a smarter way to draw my team's organizational chart. The longer, fancier way is to meticulously build the org tree using your favorite vector/office tool (like visio, powerpoint etc). It is perfectly doable for a smaller team. But what if your org has ~300 people.

I had a spreadsheet with Employee name, title and manager, and was looking for a programmatic way to automatically build the tree using the manager names. Visio has a way to import a csv into a org chart but since I don't have it and my coding being a bit rusty, I decided to look for an easier solution in Google docs.