{"id":85160,"date":"2024-03-28T06:15:09","date_gmt":"2024-03-28T10:15:09","guid":{"rendered":"https:\/\/venngage.com\/blog\/?p=85160"},"modified":"2026-01-08T05:17:16","modified_gmt":"2026-01-08T10:17:16","slug":"create-org-chart-in-google-sheets","status":"publish","type":"post","link":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/","title":{"rendered":"How to Make an Organizational Chart in Google Sheets (2026)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"576\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png\" alt=\"how to make an organizational chart in google sheets\" class=\"wp-image-85174\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets-300x169.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets-768x432.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets-730x411.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Organizational charts, or org charts, provide a visual overview of the decision-making hierarchy within a company and show how different branches connect.<\/p>\n\n\n\n<p>Making an org chart can be challenging if you&#8217;re not a designer because you have to align shapes, space the shapes evenly, and make frequent changes to ensure the chart is up to date.<\/p>\n\n\n\n<p>This is why Google Sheets is such a powerful method for making org charts. You can feed it your data and it\u2019ll whip up an org chart for you (there\u2019s no need to do draw anything!).&nbsp;<\/p>\n\n\n\n<p>In this post, I\u2019ll show you how to make an org chart using Google Sheets and then an alternative method using an <a href=\"https:\/\/venngage.com\/features\/organizational-chart-maker\" target=\"_blank\" rel=\"noreferrer noopener\">Organizational Chart Maker<\/a> and <a href=\"https:\/\/venngage.com\/templates\/diagrams\/organizational-chart\" target=\"_blank\" rel=\"noreferrer noopener\">&nbsp;organizational diagram templates<\/a>.&nbsp;<\/p>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/features\/organizational-chart-maker\" target=\"_blank\" rel=\"noopener\"><button class=\"btn-cta\"><b>START CREATING FOR FREE\u00a0<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p><strong>Click to jump ahead:&nbsp;<\/strong><\/p>\n\n\n\n<ul>\n<li><a href=\"#sheets\">How to make an organizational chart using Google Sheets<\/a><\/li>\n\n\n\n<li><a href=\"#venngage\">How to make an organizational chart in Venngage<\/a><\/li>\n\n\n\n<li><a href=\"#conclusion\">Conclusion<\/a><\/li>\n<\/ul>\n\n\n\n<ol>\n<li>Open a &#8220;<strong>Blank Spreadsheet<\/strong>&#8221;&nbsp;<\/li>\n\n\n\n<li>Add employee names in column A&nbsp;<\/li>\n\n\n\n<li>Add the names of managers in column B<\/li>\n\n\n\n<li>Select and highlight both columns<\/li>\n\n\n\n<li>Click \u201c<strong>Insert<\/strong>\u201d &gt; \u201c<strong>Chart<\/strong>\u201d<\/li>\n\n\n\n<li>Select the org chart option&nbsp;<\/li>\n\n\n\n<li>Customize your org chart<\/li>\n\n\n\n<li>Download your org chart<\/li>\n<\/ol>\n\n\n\n<p><strong>To create an org chart in Google Sheets, follow these steps:<\/strong><\/p>\n\n\n\n<p>If you prefer a visual walk-through of each step, keep reading!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sheets\">A step-by-step guide on creating an organizational chart using Google Sheets<\/h2>\n\n\n\n<p>If you work as an HR manager or are a project manager, Google Sheets is one of the best ways to build org charts.&nbsp;<\/p>\n\n\n\n<p>You probably already know how to use Sheets to create column and line charts and honestly the process isn&#8217;t much different for creating org charts. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 &#8211; Open a blank spreadsheet&nbsp;<\/h3>\n\n\n\n<p>First, head over to Google Sheets on your browser and click on \u201c<strong>Blank Spreadsheet<\/strong>\u201d on the welcome screen.&nbsp;<\/p>\n\n\n\n<p>If you already have a spreadsheet open, click on &#8220;<strong>File<\/strong>&#8221; &gt; &#8220;<strong>New<\/strong>&#8221; to open a new sheet.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/ymzuNMrVyuPHRsFEsFRPS7ZbNv8MPm_3AZ8D9AqQhY9mSNLi_TpLn0XqfgoijD0tjpe6aG8qzHZ0rt2wYORLg9NqP821w0TrmzpzvjdXR_ME2iHr_PhjXPCiFCoczypDpksU4Es1QhhG-FlqS_bvyws\" alt=\"blank spreadsheet\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"2\">Step 2 &#8211; Add &#8220;Employee Name&#8221; in column A<\/h3>\n\n\n\n<p>Unlike Google Docs where you have to manually draw an org chart, in Sheets, you have to add your org chart details as data and then use the chart feature to visualize it. <\/p>\n\n\n\n<p>Start by entering employee names in column A (you can either type them in manually or copy-paste from an external source). <\/p>\n\n\n\n<p>For example, in column A,&nbsp; I entered the following fictional employee names: Amy, John, Katarina, and Rayna. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-41-1024x570.png\" alt=\"employee names column a google sheets\" class=\"wp-image-85165\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"3\">Step 3 &#8211; Add &#8220;Manager Name&#8221; in column B<\/h3>\n\n\n\n<p>After entering employee names in column A, it&#8217;s time to add information on who they report to in column B.&nbsp;<\/p>\n\n\n\n<p>For example, I entered \u201cCEO\u201d next to Amy, Katarina, and Rayna. This means all three of them report to the CEO.&nbsp;<\/p>\n\n\n\n<p>For John, I entered  \u201cRayna\u201d in column B to indicate that he reports to Rayna instead of the CEO.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/8xra2fiE8ur8eIWNdsdrQir4CIUUcX3gah_PhvEPiL3YiGroAOzcX6Mt_Gqu0d5-eIijmAGiQh0JFaOtNZuuUnec9_-bmlL_S1X1pTAXVINqDt9byCQ6FWT1JR42g16Y8Ckp1W0bWyIuzhr8x1qvH18\" alt=\"employee names column b google sheets\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"4\">Step 4 &#8211; Create the org chart<\/h3>\n\n\n\n<p>Once you\u2019ve entered your data, select both columns like this. &nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/QbG4PMyqllU-nBpImFFBzipX-dBIWXmjs4rU2Z80aH9hevcFI_W9KWYk4IO6bK6iCzVWIp1RZUjbNKD43BDdjg7ks8gOObZ00LObrIvdY83qaJkHSwG4yHi0Yj1VnkEqwU0M6MDX1lv2JYsnwIrMjnk\" alt=\"Highlighted text within google sheets\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<p>Then, click on the &#8220;<strong>Insert&#8221; <\/strong>on the menu at the top and select the &#8220;<strong>Chart&#8221; <\/strong>option.&nbsp;<\/p>\n\n\n\n<p>A &#8220;<strong>Chart Editor<\/strong>&#8221; panel should appear on the right side of Google Sheets where you can instruct Sheets on how to visualize the data.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/5nIE-Eq_IAZk5eeChbltM7zWXTBYW6NFlIF5o7pg5Wz6aj-rIiCJz1_icNELcdh-6LKyO394-QMFHkyX4wUV_m_t1KExBzWRmfCeRLu2sdm8UZ4v5HYjGOuOjrdzW3q-eN9HAVAJAId9fe6pO4cQJaM\" alt=\"preparing to add chart in Google Sheets\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"5\">Step 5 &#8211; Select your chart&nbsp;type<\/h3>\n\n\n\n<p>In the &#8220;<strong>Chart Editor&#8221;<\/strong> panel, select organizational chart under the &#8220;<strong>Chart Type&#8221; <\/strong>dropdown menu.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/t3qn1sNPe1oxWrZtyuKHhkYROWaxGoeJS0A1bqcqmbKY3lOUcvySuFQAItHsrhY4a5B-c2trRi4iAEMvkvD16euc52-vw9KvIKcTmylojB60u0h24KTMO3773vz4k8qzyf0Nhoms1x3Nhf83huftd4c\" alt=\"Google Sheets selecting chart type \" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<p>Once you\u2019ve selected org chart, Sheets will automatically transform the data into an org chart.&nbsp;&nbsp;<\/p>\n\n\n\n<p>There&#8217;s no need for you to do any design work (which is a lifesaver!) but make sure to double-check if the information is accurate.&nbsp; <\/p>\n\n\n\n<p>If not, update the data in the columns and Sheets will automatically update the chart accordingly.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/i-r6-kpUyhmtM_WXGAbtsIwr3SSgOv9IAixT_tCRt4kJRA6MAlCP3hsxvvhCh6zYJMXuEfz9QobGzxQN08LhSqmqMhUFFG42UEAzLSTiRmMTUplE7t24MpJJp5PQudTbv6a6Rp39IriHZSLjIobLVl0\" alt=\"org chart in google sheets\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"6\">Step 6 &#8211; Customize your org chart&nbsp;<\/h3>\n\n\n\n<p>Once you\u2019re happy with your org chart, you have a few customization options in the <strong>\u201cCustomize Tab\u201d<\/strong> option under &#8220;<strong>Chart Editor<\/strong>&#8220;.&nbsp;<\/p>\n\n\n\n<p>You can do any of the following to your org chart: change the chart size, text, and color of nodes at each level of hierarchy.&nbsp;&nbsp;&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/YpYFxp2ObFjiJefKFx2HodVAjtwgTaF1B7YnUrukEuOtx9ZCQmKoGx9fpYm0R5NpV-qvoGDPzGiTL33XfQuQSfaa72osqKptEvP4AG5hhC5yVCoQtgpSRr860elaqKZOrThNZZaQ6Yuw3uUEVjO-Ec0\" alt=\"org chart in google sheets\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"7\">Step 7 &#8211; Download your org chart<\/h3>\n\n\n\n<p>Once you\u2019re happy with your org chart, you can download the spreadsheet by clicking &#8220;<strong>File&#8221; &gt; &#8220;Download&#8221;<\/strong> or share a link to it in your report or presentation. <\/p>\n\n\n\n<p>That wasn&#8217;t so bad, right? Google Sheets is pretty handy if you want something functional quick but if you&#8217;re hoping for colorful and engaging org charts, Sheets can be tricky. &nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"venngage\">How to create an organizational chart with Venngage<\/h2>\n\n\n\n<p>If you want to create org charts that don&#8217;t look like they were made using old software, I recommend giving Venngage a try.<\/p>\n\n\n\n<p>Our&nbsp;<a href=\"https:\/\/venngage.com\/templates\/diagrams\/organizational-chart\" target=\"_blank\" rel=\"noreferrer noopener\">org chart templates<\/a>&nbsp;are built by professional-designers which means they&#8217;re functional, attractive, and colorful. And best of all, you don\u2019t have to waste time creating them from scratch.<\/p>\n\n\n\n<p>You can just edit our templates instead (you don&#8217;t need design skills). If you know how to use a tool like Google Sheets, you&#8217;ll pick up Venngage in no time. <\/p>\n\n\n\n<p>Here are some sample org chart template you can edit in Venngage and make your own. <\/p>\n\n\n\n<p>This classic top-down org chart uses various colors to represent different levels of hierarchy within a company which makes it easy to see reporting relationships at a glance. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/venngage.com\/templates\/diagrams\/vibrant-corporate-organizational-chart-39e976d7-cc06-4c7c-ba4f-2ea29b1bcaad\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42-1024x791.png\" alt=\"Vibrant Corporate Organizational Chart\" class=\"wp-image-85166\" width=\"768\" height=\"593\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42-1024x791.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42-300x232.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42-768x593.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42-730x564.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-42.png 1056w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/diagrams\/vibrant-corporate-organizational-chart-39e976d7-cc06-4c7c-ba4f-2ea29b1bcaad\" target=\"_blank\" rel=\"noopener\"><button class=\"btn-cta\"><b>CREATE THIS TEMPLATE<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Who said org charts have to be all text? This org chart uses graphics and icons to make a hospital&#8217;s internal structure more appealing to study. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-1024x663.png\" alt=\"Hospital Organizational Chart\" class=\"wp-image-85167\" width=\"768\" height=\"497\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-1024x663.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-300x194.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-768x497.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-1536x994.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43-730x472.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-43.png 1632w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/diagrams\/hospital-organizational-chart-d55d0d04-5b99-473c-9303-c94dd812b65f\" target=\"_blank\" rel=\"noopener\"><button class=\"btn-cta\"><b>CREATE THIS TEMPLATE<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Here&#8217;s another great example of an org chart template that uses graphics and colors make the information visual and appealing. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"Corporate Healthcare Organizational Chart\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-1024x663.png\" alt=\"Corporate Healthcare Organizational Chart\" class=\"wp-image-85168\" width=\"768\" height=\"497\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-1024x663.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-300x194.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-768x497.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-1536x994.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44-730x472.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/image-44.png 1632w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/diagrams\/corporate-healthcare-organizational-chart-130a5d5e-5229-4b3f-9274-76d8a1d286ea\" target=\"_blank\" rel=\"noopener\"><button class=\"btn-cta\"><b>CREATE THIS TEMPLATE<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Note: <em>Some of our organizational templates are free, and some require a small monthly fee. Sign-up and access to Venngage\u2019s online drag-and-drop editor are always free.<\/em><\/p>\n\n\n\n<p>When editing our templates, you&#8217;ll get access to our drag-and-drop interface so it&#8217;s easy to add, remove, or reposition nodes in your org chart. <\/p>\n\n\n\n<p>Venngage also makes it easy to change the color scheme in templates and font style to match your company branding. You&#8217;ll also get access to our in-house library of thousands of free icons and graphics.<\/p>\n\n\n\n<p>Here&#8217;s what you need to do to start creating org charts in Venngage. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 &#8211; Sign up for a free Venngage account<\/h3>\n\n\n\n<p><a href=\"https:\/\/infograph.venngage.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\">Sign up<\/a> for Venngage using your email, Gmail, or Facebook. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter is-resized\"><a href=\"https:\/\/infograph.venngage.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/NGBGFfO9gbNljK4q3MG-5h2Z2YUZu3oF21xxqd4yK8LKpXeth1WMqfODlLpqZclZmu-T1O4m0oczMTIJyClHH3jx5BNYKtRor3TR1M8zEWVqZE3oM3eYCF276NjRnh-dWOpaNLLZ4CIALSLtIXh5FRw\" alt=\"venngage sign up\n\" width=\"750\" height=\"450\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 &#8211; Choose an org chart template from our library&nbsp;&nbsp;<\/h3>\n\n\n\n<p>Head to our templates page and first select the \u201c<strong>Diagram<\/strong>\u201d category. Here you&#8217;ll see our range of diagram templates from org charts, flowcharts, and more. <\/p>\n\n\n\n<p>If you want to filter only for org charts, select the \u201c<strong>Organizational<\/strong>\u201d subcategory. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/Fvpe7sygzgyCQewrb-5YZu909FqR-KktnEorXMvkIeVZYa85e1GkHIStkHFiefsOqoL_AG1mNeURD1_EAQv2B_vxxv3mCZFqSs5yl_5FuZBV4LHnyHLno9RxNpThU1ye__LjxBLFH7uxNdTxbBbzR1A\" alt=\"venngage org chart templates \" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Step 3 &#8211; Customize an org chart template with your&nbsp;information&nbsp;<\/h3>\n\n\n\n<p>Once you\u2019ve selected an org chart template, click on \u201c<strong>Create<\/strong>.\u201d This should open the editor window where you can edit the org chart.&nbsp;<\/p>\n\n\n\n<p>For example, you\u2019ll probably want to replace the text with your own company details.&nbsp;<\/p>\n\n\n\n<p>This is pretty straightforward in Venngage. Just click on a text, delete it, and then type in what you need.&nbsp;<\/p>\n\n\n\n<p>If you want to replace the images and add real photos of your employees, click on an image and select <strong>&#8220;Replace&#8221;<\/strong>.&nbsp;This should open our icon and image library where you can import your own.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/TSZU8UCp4h-6D_AxLwOvU--3R5vI-a0Lbgy5XYT2PW5KWDVr1tijSvKi6FII8L4rufsxTgl0r1MUJWzM5LPmfmfcMvbGHmUmFJom873sIjopVP33wHYSVmwNhN37m3j-pjNR_WZBcpwUlccsSK1BnpE\" alt=\"Venngage org chart template\" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Step 4 &#8211; Customize your org chart<\/h3>\n\n\n\n<p>I changed the color of one of the org chart nodes in a few clicks. You can also add an icons and\/or graphics using the icons tab on the left panel.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/wgHi6BCkpPmrjbaWwrlFeudHO_XkAK9byXCVCd6V6xiqRslSisHchmC6_Ttj5mSx7DIgwA_hke0UeUfKodpVHmwp2bQrTEiEHInVKmWM9qUgQfXDAzfW6WVEo4IRZspvMfc7znKke1atQv-EeNI0uvM\" alt=\"Editing Venngage org chart template \" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Step 5 &#8211; Share or download your org chart&nbsp;<\/h3>\n\n\n\n<p>Once you\u2019re happy with your org chart in Venngage, you can share a link to it (available to all users). <\/p>\n\n\n\n<p>However, to download your org chart as a PDF or PNG, you\u2019ll need to upgrade to a <a href=\"https:\/\/venngage.com\/blog\/business\" target=\"_blank\" rel=\"noreferrer noopener\">Business<\/a> Plan.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/lh7-us.googleusercontent.com\/IijfW5QMOy6cSDtjUMfGfMR0MUjU61hPNVRyXpAd7ubNnoFbm6ESdVO36lWko0ISM9MyCB79J8r8lXLh1IFqlS_UmIu_CxoV92ojZUYWgsuEEGgZ5syvGFc7HkAWz-Cdc9FcO-cIgVnLug2jxKUyJT8\" alt=\"venngage download \" width=\"750\" height=\"450\"\/><\/figure><\/div>\n\n\n<p>&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion: Don&#8217;t settle for less than ideal org chart software like Google Sheets when you have options like Venngage <\/h2>\n\n\n\n<p>No one likes org charts with bland colors and boring designs.&nbsp;<\/p>\n\n\n\n<p>But that\u2019s what you\u2019ll get if you create your org charts on Google Sheets. Why not give Venngage a try and impress your team with fun and engaging organizational charts instead?<\/p>\n\n\n\n<p>Check out our <a href=\"https:\/\/venngage.com\/templates\/diagrams\/organizational-chart\" target=\"_blank\" rel=\"noreferrer noopener\">organizational chart templates<\/a> today and start creating for free. <\/p>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/diagrams\/organizational-chart\" target=\"_blank\" rel=\"noopener\"><button class=\"btn-cta\"><b>START CREATING FOR FREE\u00a0<\/b><\/button><\/a><\/center>&nbsp;\n","protected":false},"excerpt":{"rendered":"<p>Organizational charts, or org charts, provide a visual overview of the decision-making hierarchy within a company and show how different branches connect. Making an org chart can be challenging if you&#8217;re not a designer because you have to align shapes, space the shapes evenly, and make frequent changes to ensure the chart is up to [&hellip;]<\/p>\n","protected":false},"author":156,"featured_media":85174,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false},"categories":[188,610],"tags":[255],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Make an Organizational Chart in Google Sheets (2026) - Venngage\" \/>\n<meta property=\"og:description\" content=\"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Venngage\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Venngage\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T10:15:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-08T10:17:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@venngage\" \/>\n<meta name=\"twitter:site\" content=\"@venngage\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Danesh Ramuthi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/venngage.com\/blog\/#website\",\"url\":\"https:\/\/venngage.com\/blog\/\",\"name\":\"Venngage\",\"description\":\"Learn to Communicate with Data\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/venngage.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png\",\"contentUrl\":\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png\",\"width\":1024,\"height\":576,\"caption\":\"how to make an organizational chart in google sheets\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#webpage\",\"url\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/\",\"name\":\"How to Make an Organizational Chart in Google Sheets (2026) - Venngage\",\"isPartOf\":{\"@id\":\"https:\/\/venngage.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#primaryimage\"},\"datePublished\":\"2024-03-28T10:15:09+00:00\",\"dateModified\":\"2026-01-08T10:17:16+00:00\",\"author\":{\"@id\":\"https:\/\/venngage.com\/blog\/#\/schema\/person\/d528dbe67dda467d0f1f072045370471\"},\"description\":\"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/venngage.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Beginner Guides\",\"item\":\"https:\/\/venngage.com\/blog\/category\/beginner-guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Make an Organizational Chart in Google Sheets (2026)\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/venngage.com\/blog\/#\/schema\/person\/d528dbe67dda467d0f1f072045370471\",\"name\":\"Danesh Ramuthi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/venngage.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/974bae41a46326e57c489213f9ea2cd4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/974bae41a46326e57c489213f9ea2cd4?s=96&d=mm&r=g\",\"caption\":\"Danesh Ramuthi\"},\"description\":\"Danesh Ramuthi is a freelance content writer at Venngage, specializing in crafting detailed guides and tutorials on a variety of design and marketing topics. His expertise covers flyer design, flowchart creation, the use of generative AI in design, and marketing presentations. Through his clear, informative writing, Danesh helps readers master complex concepts and enhance their creative skills, making him a go-to resource for actionable design insights.\",\"url\":\"https:\/\/venngage.com\/blog\/author\/danesh-ramuthi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"description":"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Make an Organizational Chart in Google Sheets (2026) - Venngage","og_description":"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.","og_url":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/","og_site_name":"Venngage","article_publisher":"https:\/\/www.facebook.com\/Venngage","article_published_time":"2024-03-28T10:15:09+00:00","article_modified_time":"2026-01-08T10:17:16+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_creator":"@venngage","twitter_site":"@venngage","twitter_misc":{"Written by":"Danesh Ramuthi","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/venngage.com\/blog\/#website","url":"https:\/\/venngage.com\/blog\/","name":"Venngage","description":"Learn to Communicate with Data","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/venngage.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#primaryimage","inLanguage":"en-US","url":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png","contentUrl":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2024\/03\/How_to_Make_an_Organizational_Chart_in_Google_Sheets.png","width":1024,"height":576,"caption":"how to make an organizational chart in google sheets"},{"@type":"WebPage","@id":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#webpage","url":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/","name":"How to Make an Organizational Chart in Google Sheets (2026) - Venngage","isPartOf":{"@id":"https:\/\/venngage.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#primaryimage"},"datePublished":"2024-03-28T10:15:09+00:00","dateModified":"2026-01-08T10:17:16+00:00","author":{"@id":"https:\/\/venngage.com\/blog\/#\/schema\/person\/d528dbe67dda467d0f1f072045370471"},"description":"Learn how to create an Org Chart directly within your Google Sheets with our simple step-by-step guide.","breadcrumb":{"@id":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/venngage.com\/blog\/create-org-chart-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/venngage.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Beginner Guides","item":"https:\/\/venngage.com\/blog\/category\/beginner-guides\/"},{"@type":"ListItem","position":3,"name":"How to Make an Organizational Chart in Google Sheets (2026)"}]},{"@type":"Person","@id":"https:\/\/venngage.com\/blog\/#\/schema\/person\/d528dbe67dda467d0f1f072045370471","name":"Danesh Ramuthi","image":{"@type":"ImageObject","@id":"https:\/\/venngage.com\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/974bae41a46326e57c489213f9ea2cd4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/974bae41a46326e57c489213f9ea2cd4?s=96&d=mm&r=g","caption":"Danesh Ramuthi"},"description":"Danesh Ramuthi is a freelance content writer at Venngage, specializing in crafting detailed guides and tutorials on a variety of design and marketing topics. His expertise covers flyer design, flowchart creation, the use of generative AI in design, and marketing presentations. Through his clear, informative writing, Danesh helps readers master complex concepts and enhance their creative skills, making him a go-to resource for actionable design insights.","url":"https:\/\/venngage.com\/blog\/author\/danesh-ramuthi\/"}]}},"_links":{"self":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/85160"}],"collection":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/users\/156"}],"replies":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/comments?post=85160"}],"version-history":[{"count":42,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/85160\/revisions"}],"predecessor-version":[{"id":109395,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/85160\/revisions\/109395"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/media\/85174"}],"wp:attachment":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/media?parent=85160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/categories?post=85160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/tags?post=85160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}