How to Create an Org Chart in Google Sheets: A Guide for the Non-Tech Savvy

Hey there! Are you stuck trying to create an org chart for your company? Do you dread it because you're not tech-savvy? Well, fear not! In this article, I'll show you step-by-step how to create an org chart in Google Sheets, with easy-to-follow instructions and no complicated jargon. By the time you finish reading, you'll be able to create a professional-looking org chart that will impress your boss and colleagues.

The Benefits of Using Google Sheets for Org Charts

Before we get started, let me tell you why using Google Sheets for org charts is a great idea. First of all, it's free! You don't need to spend money on expensive software or tools. Second, it's user-friendly and intuitive, even for those who are not tech-savvy. Third, it's accessible from anywhere, as long as you have an internet connection. Fourth, it's easy to collaborate with others, as you can share the sheet with them and they can edit it in real-time. And finally, it's customizable, so you can make your org chart look just the way you want it.

Step-by-Step Guide to Creating an Org Chart in Google Sheets

Now let's get into the nitty-gritty of creating an org chart in Google Sheets. Follow these simple steps and you'll be done in no time:

Step 1: Create a New Spreadsheet

The first thing you need to do is create a new Google Sheet. You can do this by going to and clicking on the "Blank" option. Give your sheet a name by clicking on the "Untitled spreadsheet" title at the top left corner and typing in the name you want.

Step 2: Enter Your Data

Next, you'll need to enter your data into the sheet. This will include the names of your employees, their job titles, and other relevant information. You can either type this information in manually or copy and paste it from another source. Be sure to use separate columns for each piece of information to make it easier to sort and filter later on.

Step 3: Insert a Hierarchy Diagram

Here's where the magic happens! To create the org chart, you'll need to insert a hierarchy diagram using the SmartArt feature. Click on the "Insert" tab at the top menu, then select "Drawing" and click "New". From there select "Diagram" and scroll down to find a hierarchy chart that fits your needs. Decide on the shape and orientation of your chart, and click "Save and Close".

Step 4: Link Your Data to the Diagram

Now it's time to link your data to the diagram. Click on the diagram to activate it, then click on the "Link" icon at the top left corner. In the sidebar that pops up, select "Spreadsheet" and find the sheet where your data is stored. Select the data you want to link (names and job titles) and click "Apply". Voila! Your diagram is now linked to your data.

Step 5: Customize Your Org Chart

The final step is to customize your org chart to make it look professional and visually appealing. You can change the colors, fonts, and sizes of the shapes and text, as well as add images or logos. Rearrange the chart to your liking by clicking and dragging the shapes. And if you want to add more information, such as email addresses or phone numbers, you can do so by adding new columns to your sheet and linking them to the diagram.


Creating an org chart in Google Sheets may seem daunting at first, but with these simple steps, you can create a chart that looks great and is easy to understand. Remember to take advantage of the customizable and collaborative nature of Google Sheets to make your org chart unique and tailored to your company's needs. And don't forget to have fun with it! Who said org charts have to be boring?

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.