skip to Main Content

Automatic Organization Chart Maker – Basic Version

4.27 (11 reviews)

Create Org Charts in Excel easily! Automated spreadsheet template for business people who don’t want to waste time on creating org charts.


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


For all types and scales of organizations, it is indispensable to illustrate the reporting lines. Especially, at growing small and medium scale organizations having max. 40 employees, keeping organizational schemes up to date may become a puzzling situation. Because, in case of each organizational change, you have to deal with boxes, connections, levels and so on. We have built this Excel Organization Chart Maker to ease this process.

Automatic Organizational Chart Maker – Basic Version provides generating an organizational chart for small organizations in JUST 2 STEPS:


  1. Put employees, their roles and who reports to whom in Excel
  2. Click the button!

It basically works like this:

Let’s look closer to the sections:


In Dashboard you will simply fill the blank fields with your org structure. Once you type in the names, you will be able to select “Reports to” people from the drop-down.


Please note that there should be one empty cell at “Reports to” column that will be the head of organization. Because in relational database, the template is designed to display one-to-many relationships in the organogram.

The another point you need to be careful, if there are more than one person with the same name, put a little sign like dots, commas etc. You cannot use duplicate names.

Thankfully, if there is a problem with your Org Structure table, message will appear in the Message Box. So you will be able to figure out the problem and create your chart after fixing the issue.

The last section of Dashboard is the Org Box Format. You can put the format (colors, lines) you would like to see here, so whatever you apply there, will be transferred to the family tree automatically.


Org Chart

After apply all procedures above, you can create a diagram for your organization and Export to PDF with from the button on the page.

Need to increase the box size? You can arrange the width or height of the cells to increase their size. 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 easily adjust the column and the row structure of the Chart!

Hope this helps!


1. You Save Money
Someka Auto Org Chart Generator is a cheaper option compared to the other organization chart generator tools.

2. You Save Time
This tool provides you to keep your reporting line data and prepare your organization chart, both in Excel. No need to deal with data transfer..

3. It’s User Friendly
If you don’t like the order and layout, just edit your employee table and re-create the chart again. You can also change the box colors. Moreover, Someka Auto Org Chart Generator warns you about possible errors like illogical reporting lines.

Automatic Organization Chart Maker – Basic Version Features:

  • Recommended for small organizations which have 30 – 40 employees max (For larger organizations, please check: Someka Auto Org Chart – Advanced Version)
  • Organizational Chart Template in Excel
  • Clear on sheet instructions (with turn on/off function)
  • Works on both Windows and Mac
  • Compatible with Excel 2007 and later versions.
  • No installation needed. Ready to use.
  • Includes VBA code and macros (don’t forget to enable macros after you get it)
  • Easy to use and nice design
  • Box design can be changeable
  • Export to PDF feature
  • Print Ready

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

Someka Organizational Chart Generators Comparison

Someka Org Chart Generators Comparison Table

Links to Versions:


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



11 reviews for Automatic Organization Chart Maker – Basic Version

  1. Darren

    This was working GREAT when I first got it
    But now it seems to be broken
    I cut the top layer and put the Role tag anywhere randomly. Can you help me?

    • Someka

      Hi Darren,

      Did you delete anything from the template? It has to be totally related to that otherwise it should work properly as you say. It would be better to send your file to In that way, our customer support team can see the exact reason for the issue and help you to solve it asap.

      Best wishes,

  2. Alexia Lazar

    We are looking at a new platform to create our org charts and see your template. wanted to know if I could have a quick demo and/or to have a powerpoint presentation with the cost.

    • Someka

      Hi Alexia,

      Thanks a lot for your interest!

      Unfortunately, we don’t have a demo or trial version for our premium templates. But, we have prepared a detailed product description and product video to show all the features of the template. Did you visit the video section above?

      Besides that, when you create an org chart you can save it as pdf file as well. In that way, you can use your chart on your presentations easily.

      Hope that helps!

  3. Natalie Tolson

    I am using the template but just have some questions. When you export the chart it is not printable on A3. Tried setting the print area, and set the page up correctly. Also tried to print directly from the excel. We have a large organization. How do I print this?

    • Someka

      Hi Natalie,
      All the arrangements about printing can be done by Excel printing options, on the Letter section. So you can choose the A3 option from there.
      If you have a large organization and want to print all of them, the chart that you will be able to print is limited with the Excel printing options. So, when the size of the organization chart is too big, it won’t be printed on just one page.

      Hope that helps!
      Kindly regards,

  4. Harpreet Dhillon

    I just purchased the chart builder. I am not happy with Export options as it only gives Pdf as option.Pdf only option is very limited for what we would like to accomplish. Am trying to cancel this subscription unless other (e.g., jpeg, png, docx) useful options are available.

    • Someka

      Dear Harpreet,

      First of all, thank you for taking your time to leave this review. All ideas are welcomed on our side! We create all of our templates to be used in Microsoft Excel so the compatibility of the template is limited with the Excel features. Because of this, it is not possible to convert the file format to jpeg, png or docx but our developer team has contacted you via e-mail regarding a quick solution for your issue so please check your mailbox.

      Hope this helps!

  5. robert cohen32

    very good customer support. haven’t tried premium version yet but it looks great , thank you very much. For those who want to try this: I very satisfied customer with even basic one.

  6. mark sandhu

    Easy-to-use org charting tool. Satisfied Customer.

  7. Paul Lund

    While this might have been a good solution at one time, it’s not any more. Very slow, very cumbersome after 2500 employee

  8. Jose


    I purchased the Org Chart Generator Excel template which I thought I’d love.

    I like that all you need to do is enter names and who they report to and voila.

    What I don’t like is that when I export to pdf, there’s no way to make boxes bigger to make it easier to ready.
    Am I missing something? Is there a way to change the size to make this a lot easier to read. My org chart is only about 20 people.


    • Someka

      Hello Jose,
      Thanks for your purchase. The sizes of boxes are adjusted automatically to fit the page. What you can do is increase the font of your Org Box at Dashboard. Like this:
      Org Chart Box Format
      Hope this helps!

  9. Duygu Bencikli

    Hey this is fantastic! I am really content of getting rid of changing organization schemes all the time!!!

  10. Leira Gonzalez

    We purchased it !!
    One question: My org file is very broad (the GM has over 20 direct reports) How can i move the boxes vertically so it’s easier to read?
    Thanks for your feedback and patience!

    • Someka

      Thanks for feedback Leira!
      Automatic Org Chart Basic Version spreadsheet places the same depth level connections horizontally, not vertically.

      For vertical structure, you can check out Automatic Org Chart Advanced and Automatic Org Chart Premium versions. You will find 4 different sub-layout options!

  11. Emily Lyons

    Simple solution! I received the password many thanks but can not unprotect worksheets and books??

Leave a customer review

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