Flowchart in Excel ClickUp Blog

How to Create a Flowchart in Excel (With Templates & Examples)

Microsoft Excel is a spreadsheet software program generally used to organize and format large amounts of data, but it also packs a diverse shapes gallery to make flowcharts!

A SmartArt graphic is the go-to illustration to create any diagram in Excel. However, you need a more compelling flowchart for collaboration and communication

In this guide, we’ll walk through the function of flowcharts, how to create a flowchart in Excel, and two Excel alternatives to make your flowcharts come to life. (Spoiler: the two alternatives are in the same software!)

What is a flowchart?

A flowchart is a diagram made of shapes connected by arrows to visualize a workflow, process, or any decision-making procedure. Flowcharts are for everyone because unlike text-heavy documents, they condense information so the audience can digest the information faster. 

Flowcharts turn ideas into thought-out actions to solve problems and ultimately, increase productivity because things run smoothly. Think about any event you’ve encountered at some point at your organization, for example. It could be new hire onboarding, requesting PTO, or organizing a project kickoff meeting. These events have a process in place so everyone consistently takes the right steps towards success. Flowcharts help the person creating these processes visualize the scope, sequence, stages, and stakeholders involved.

Bonus: Diagram software!

Basic shapes used in flowcharts

It’s not necessary to be well-versed in flowchart programming. All you need to know are the basic building blocks to make your flowchart easy to understand. The four main flowchart shapes we’ll use for this tutorial are:

use the smartart graphic dialog box or build custom shapes to create flowcharts in excel
Created in Microsoft Excel
flowchart digram symbols and definitions
SymbolFunctionHow to Add
OvalTerminal: the start point and end point of a flowchartInsert tab > Illustration > Shapes > Flowchart > Terminator
RectangleProcess: represents a single step in the procedureInsert tab > Illustration > Shapes > Flowchart > Process
DiamondDecision: represents a decision actionInsert tab > Illustration > Shapes > Flowchart > Decision
ArrowArrow: connects shapes to show the relationshipInsert tab > Illustration > Shapes > Flowchart > Arrow

Ready to create a flowchart of your own? Choose one of your ideas or tasks and follow along with our step-by-step guide to create this flowchart! ⬇️ 

create flowcharts in excel
Created in Microsoft Excel

How to create a flowchart in Excel with custom shapes

Note: In this tutorial, we use Microsoft Excel for Mac Version 16.60. The steps and features may look different if you’re on another version.

Excel is a large application with hundreds of functions. The two most important functions to use and speed up your flowchart build are: copy and paste. So rather than adding shapes one by one to your spreadsheet, we’ll format the shapes first. Then you can copy and paste the shapes into your flowchart process. Here we go!

Related: Learn how to create a flowchart in Google Docs.

1. Add the terminator, process, and decision flowchart shapes 

Go to the Insert tab > Illustration > Shapes > Flowchart > select a shape > click at the top of the spreadsheet to add.

access more flowchart shapes in the illustrations group to create a standard flow chart
Created in Microsoft Excel

2. Adjust the flowchart shape sizes

We want to add text inside the shapes, so let’s make them bigger. Select one of the shapes > press Command + A on your keyboard to select all shapes > hold Shift > go to a shape’s corner and drag to expand all three flowchart shapes. 

edit multiple shapes in a flow chart by selecting all the shapes and adjusting the size
Created in Microsoft Excel

3. Customize each flowchart shape

We’ll use the copy and paste function to customize the shapes, but there’s a handy Format icon to help us with this! 

  1. Double click inside the Process shape to reveal a cursor, label the shape Process, and center the text
  2. Change the font name and font size to your preference
  3. Select the Process shape > click the Format icon under the Home tab > click on the other shapes to paste the format
  4. Label the diamond shape Decision and the oval shape Terminator
open a text box in the first shape to format and copy to the next shape
Created in Microsoft Excel

Next, select background and font colors for each shape. Click on a shape > go to the Shape Format tab > Shape Fill and Text Fill

edit the shape styles in the flow chart under the shape format tab
Created in Microsoft Excel

Pro Tip: To remove the shape outline for a cleaner look, select all shapes > Shape Format tab > Shape Outline > No Outline

use the shapes tool to edit the flowchart symbols
Created in Microsoft Excel

4. Begin adding your flowchart steps

With your fully customized (and consistent) shapes, copy and paste the Excel flowchart shape to map out your steps!

add shapes to the flow chart and build your process
Created in Microsoft Excel

5. Add the connectors to show each shape relationship 

Go the Insert tab > Shapes > Lines > Arrow. 

add lines to connect shapes in the flow chart
Created in Microsoft Excel

Use the green circles as a guide to draw the arrows and connect the shapes.

connect shapes with arrows to show the relationships between each step in the flow chart process
Created in Microsoft Excel

6. Add a title to your flowchart

Delete the shapes at the top of your spreadsheet and add a title.

Tip: For a cleaner look, remove the gridlines in your Excel flowchart. Go to the Page Layout tab > uncheck the View box under Gridlines

open the page layout tab to hide the gridlines in the flow chart
Created in Microsoft Excel

Bonus: Best Flowchart Software Tools for Mac

8. Save your Excel flowchart as a template

Go to File > Save as Template. Name your flowchart template and click Save. (Double check the File Format is set as Excel Template.)

save a flowchart template in excel
Created in Microsoft Excel

There you have it! You now know how to make a flowchart in Excel! We have other Microsoft Office resources and recommendations if you’re looking for other alternatives to improve your planning needs. ⬇️ 

Limitations of Excel flowcharts

While it’s handy to know how to create flowcharts in a popular tool like Microsoft Excel, spreadsheets are not collaboration-friendly. People who are less familiar with Excel navigation will have a harder experience and longer learning curve to complete work. 

As we all know (and experience), projects change daily. So while you’re busy manually creating flowcharts in Excel, the data, people, and circumstances might change, and you’ll have to start over. However, that’s not ideal for creative brainstorming workshops! 

This inevitable situation is why it’s essential to use an intuitive flowchart software tool to remove the manual work and update in real-time. With ClickUp, a powerful Microsoft Excel alternative, you won’t need to create multiple versions of flowchart templates!

Design flowcharts in ClickUp instantly 

ClickUp is an all-in-one productivity platform where teams come together to plan, organize, and collaborate on work using tasks, Docs, Mind Maps, Goals, Whiteboards, and more! Easily customized with just a few clicks, ClickUp lets teams of all types and sizes deliver work more effectively, boosting productivity to new heights.

Flowcharts in ClickUp do what Excel spreadsheets cannot: turn processes into actionable tasks

Flowcharts aren’t made to be built and stored somewhere in a shared drive. They’re meant to be a usable solution or workflow. With ClickUp, tasks are created directly from the flowchart so everyone is aware of roles, tasks, and deadlines!

Related: Show dependencies in Excel & make a waterfall chart in Excel

Mind Maps in ClickUp 

Mind Maps in ClickUp are perfect to offload a stream of consciousness or planned information. With Mind Maps, you won’t have to stress over the formatting details of each shape or step. You’ll have more brainpower saved for the actual work.

save a mind map as a flowchart template in clickup
Rearrange work to create logical paths and connect to workflows with Mind Maps in ClickUp

It’s easy to create a Mind Map in ClickUp and get started on your projects, ideas, and even existing tasks for the ultimate visual outline. To kick things off, download the Mind Map template with two different types of mind maps:

  • Task Mode Mind Map: map out your ideas and turn them into trackable ClickUp tasks
  • Blank Mode Mind Map: create free-form diagrams to organize your ideas

Whiteboards in ClickUp 

Earlier we mentioned Excel spreadsheets are not ideal for creative brainstorming workshops. So, what’s the alternative? Whiteboards in ClickUp!

Similar to Mind Maps, the Whiteboards feature offers more functionalities like freehand drawing, rich text formatting, images, and web links to create more context while you’re planning. Whiteboards are the fastest way to collaborate with your team and bridge the gap between brainstorming and getting work done. 

create and save a flowchart template with whiteboards in clickup
 Visualize processes and relationships with Whiteboards in ClickUp 

A blank canvas and blinking cursor might be intimidating if you’re new to visual collaboration tools. Whiteboards in ClickUp also come with templates to jumpstart your brainstorming sessions! For a step-by-step walkthrough with Whiteboards, check out the video below! ⬇️ 

Create memorable flowcharts in ClickUp

Spreadsheets serve the purpose of storing data. However, you need intuitive software to keep track of your evolving tasks and projects. The collaboration and customization features in the ClickUp platform are all you need in one place.

Take Mind Maps or Whiteboards for a spin for free today and bring your best ideas to life! 

Questions? Comments? Visit our Help Center for support.

Sign up for FREE and start using ClickUp in seconds!
Please enter valid email address