skip to Main Content

Automatic Org Chart Maker – Premium Version

4.75 (20 reviews)

Turn your Excel employee list into an Org Chart with photos! This Org Chart Maker is a great Excel template for business people.


Learn more about License Types

Someka 30 days refund icon


Someka one time payment Icon


Someka direct download icon


Payments are processed by our partner company


An org chart is a crucial tool for all types of organizations, since it answers the questions “Who is who?” and “Who does what?”. Correspondingly, it clearly illustrates the roles of the employees and relationships between employees. On the other hand, preparing an org chart and keeping it updated might bring a redundant workload. Especially if you want to put photos together with lines and boxes, it may become a nightmare! That’s why we have created this Org Chart Template in Excel!

Automatic Org Chart Maker – Premium Version makes the process very easy with unique “Photo Upload” feature. All you need to do is to follow 3 basic steps:


  1. Type employee names, roles, reporting lines, and select sub-layout in Excel. (If needed, you can add extra info in this step)
  2. Select who you want to upload a photo of and insert his/her photo from your computer
  3. Click the “Create Org Chart” button and your organizational chart will be ready within a few minutes!

It basically works like this:


Start filling your employee Names and Roles to the table on the Dashboard (Org Chart Data). Reports To column has a dynamic dropdown and more people will appear as you add more employee names. By the way, this tool is designed according to one-to-many organizational relationship so there should be only one empty cell at “Reports to” column (who will be the head of organization.)


Extra Info column is optional. You can select whether to show it or not from the Control Panel at the side of Dashboard. (Show Extra Info)

Sub Layout column defines how will the sub employees will be placed in the chart. If you have a large chart, play with this option to fit employees better to the area. (You can click on “Default Layout” button below for quick default setup.)

If you have any problems with your data structure, you will see the Error Messages in the Control Panel. For example if there are more than one person with the same name you will get an error message. Here, you can also change the box formatting, chart type and insert/delete photos for employees.


Once you are done after you make any changes don’t forget to click the create button again. Lastly, you can clear all info with button at the bottom of the panel.

Org Chart

Finally, your Org Chart is ready!

Another great advantage of using Excel Template is ability to modify the output as you wish. After you unprotect your sheet (How can I unlock the sheets? What is the password?) and make the headings visible (I can’t see column headings. How to display them?) you can change the box, photo sizes or adjust the column and row structure to see them bigger.

Benefits of Someka Org Chart Maker:

  • Cheaper compared to other org chart tools on web.
  • Very practical, as whole operation is done in Excel.
  • User-friendly thanks to the unique “Photo Upload” and optional “Sub-Layout” features.

Premium Version Features:

  • Works both on Mac and Windows.
  • No installation needed, ready to use.
  • Excel Org Chart Maker with employee database
  • Recommended for all types of organizations
  • Unique “Photo Upload” feature
  • 4 sub-layout options: Below-Horizontal, Below-Vertical, Side-Horizontal, Side-Vertical
  • Extra info may be added optionally
  • Clear on sheet instructions (with turn on/off function)
  • Compatible with Excel 2007 and later versions.
  • Easy to use and nice design
  • Box design can be modified
  • Export to PDF feature
  • Print ready

This Org Chart Template is prepared with VBA macros. Don’t forget to enable macros after you get it. If you need customization on your charts or more complex schemes, just contact us via

Someka Org Chart Generators Comparison:


Links to versions:


20 reviews for Automatic Org Chart Maker – Premium Version

  1. Orlando

    Great product, really easy to use and comes across as well designed and solid. Would give it 5 stars if there was an easy way to add more than 1 extra field to what can be displayed

  2. Prerna Kashyap

    Very good template and user friendly too… Quick customer support is the best part..

  3. JA

    Great template and I found it easy to use. It would also be useful to have an option to add a dotted-line for indirect reporting.

    • Someka

      Hello there! Thanks a lot for your such a great feedback. We will consider your request and if we update it, we will send you for free. Until then we can offer you a quick manual solution for drawing dotted-line:

      Open Format cells with right click -> Border Options -> Select Dotted Line Style


      Hope that helps!

  4. Mostafa Mohamed

    Very good

  5. Susan King

    I had a need to use the ” chat “function with Someka for some assistance with a problem I was having and it was very helpful . They were very patient , asked me questions and we worked through it together and I was able to send them my file and there were able to fix the error and send it back in a timely manner so I could get on with my task that had a deadline. I really appreciated their efforts .

  6. Jane Ewing

    This was my very first paid template here on Someka, customer support is super awesome and tech guys are very open and friendly.

  7. tony23

    Good but not beginner friendly. It was hard for me to understand how to use sub-layout options at first. It goes well after you get used to.

  8. Thomas

    Template designed for small-medium companies (<1000 employees). Great job for small-medium structures, especialy in the positioning of the employees.

    * The more employees you add, the more it weight due to the recalculation in the file.
    * Adding the 1001 employee, you will need to unlock the whole file to adjust all the formulas…. and it's quite long and painfull…

    • Someka

      Thank you Thomas for taking time to write your review.
      In the near future, we are planning to upgrade the codebase and algorithms in the template so that it will work much faster even after 1000 employees.
      We will be sending the updated version to previous customers as well.
      Kind regards

  9. Ankush Rana

    I’m working on an org chart and so far it worked well. Just one thing, I wish to add an assistant position and want to appear it sideways (not below)

    • Someka

      Thanks for feedback! We plan to add assistant feature for the upcoming versions! You will receive it for free, when it gets published.

  10. F. Shah

    Great template but some confusion how many employees can add.

    • Someka

      Thanks for your feedback! Actually default limit for number of employees is 1000. But, if you wish, you can edit the template to add more. However, please keep in mind that, it will be impractical to see that many employees in one sheet.

  11. Erik W

    I searched a long time for a tool to generate an org chart for a > 850 person R&D organization. I was really happy to find someka. There’s no better way to generate an org chart than this. The value of the time it saved me far exceeded the cost of the tool. The org chart tools in MS Office and Visio are really awful in comparison. One really nice benefit is the error checking of the org chart. If there are inadvertent duplications of names, you will find them easily. The ability to perform conditional formatting is really useful (change colors based on org data, for example). When I had a question, someka turned around a solution in less than 24 hours, and solved the problem. I didn’t waste any time wading through “general” outsourced tech support that so many companies have these days. Thanks for an outstanding product!

    • Someka

      Hi Erik. Thanks a lot for your nice comments and really happy that the tool was helpful for you.
      It is so important to get this feedback from such a professional like you!

  12. milena-wood

    Like flexibility

  13. Anniegetyourgun

    This works perfectly for us! It’s saved me hours creating org charts. Great customer support too. Well worth the $!

  14. Griere Fox

    This tool is really great and does what it says! One time payment and immediate download options make life easier indeed! Thanks again.

  15. Pierce Sreshthaputra Coverdale

    Easy to use to make quick organization chart. Very handy item to have in office

  16. niko98

    Just used this template. I have no prior knowledge before , customer support is fast enough.

  17. Demi Purnato

    I’m so content that I’ve purchased your Org Chart Maker tool! Great customer support and very useful tool. Worths its price!


    Works great! Thanks

  19. Mohammed Ahmed

    It’s great full template for us thanks someka

  20. Özgür

    I’think it’s perfect template for our company.
    Thank u Someka’s team

Leave a customer review

Your email address will not be published. Required fields are marked *

Microsoft Excel® is registered trademark of Microsoft Corporation. Someka Excel Solutions is an active member of Microsoft Partner Network (MPN).

Someka SSL Certificate Icon

Someka Excel Solutions Ltd. Co.
© 2015-2019 All rights reserved.

Someka Bilişim Teknolojileri Ltd. Şti.   |   Address: Mansuroğlu Mah. 286/3 Sk. No:14B Bayraklı Tower 35030 BAYRAKLI / İZMİR   |   Tel: +90 (0232) 700 1883   |