Free Excel Flowchart Templates

By Kate Eby | April 25, 2024

In this guide, we’ve gathered the most useful flowchart templates in Excel. You’ll also learn how to create a flowchart using a template and how to create a flowchart in Excel from scratch.

On this page, you’ll find a cross-functional flowchart template, a swimlane flowchart template, a decision flowchart template, a yes/no flowchart template, and more.

Excel Basic Flowchart Template

Basic Flowchart Template

Download the Basic Flowchart Template for Excel
 

When to Use This Template: This basic flowchart template for Excel is good for documenting or planning a process using straightforward, linear steps. It's perfect for tasks that require clear and simple workflow visualization without complex branching. 

Notable Template Features: This template highlights each step of a process, big or small, making it easier to identify areas of improvement. Its simple design provides experts and beginners a clear picture of how work flows.

 
Check out these free flowchart templates in different formats to effortlessly map out your processes, making complex tasks simpler and more understandable. 

Excel Cross-Functional Flowchart Template

Cross Functional Flowchart Template

Download the Cross-Functional Flowchart Template for Excel  


When to Use This Template: This cross-functional flowchart template shows how different teams or departments are working on a project and how they fit into the big picture. 

Notable Template Features: This template uses defined columns to easily identify which team is responsible for work. The clear layout stops confusion about who's responsible for each part of a project.

Excel Swimlane Flowchart Template

Swimlane Flowchart Template

Download the Swimlane Flowchart Template for Excel


When to Use This Template: This swimlane flowchart template is your top choice for quickly identifying who's doing what at each phase of a big project. 

Notable Template Features: This template sorts tasks into lanes for different team members or departments. 

Excel Decision Flowchart Template

Decision Flowchart Template

Download the Decision Flowchart Template for Excel
 

When to Use This Template: Turn to this flowchart template to map out the potential results for a decision you’re trying to make.  

Notable Template Features: This template simplifies complex decision-making processes by dividing them into straightforward yes or no options divided by decision level, so you can see how your choices at one point affect all those that follow. You can see the potential results of various decisions at every level of the process, clearly illustrating the outcomes of each choice.

Excel Yes/No Flowchart Template

Yes No Flowchart Template

Download the Yes/No Flowchart Template for Excel  
 

When to Use This Template: Use this yes/no flowchart template to make clear-cut decisions fast. It breaks down complex questions into manageable yes or no choices. 

Notable Template Features: The decision path on this template starts with a yes or no question and guides you to the right outcome. It also plots how different answers lead to different results.

Excel Data Flowchart Template

Data Flowchart Template

Download the Data Flowchart Template for Excel
 

When to Use This Template: Pick this data flowchart template to track how data moves and changes across a system or process. Use the template when setting up new systems or trying to improve existing ones. 

Notable Template Features: This template is designed specifically for data flow mapping, using distinct symbols to represent the collection, processing, storage, and sharing of data. It highlights each step of data interaction, making it easier to identify potential inefficiencies or security risks.

How to Create a Flowchart in Excel Using a Template

By creating a flowchart in Excel using a template, you streamline laying out processes or decisions. The elements you would use in a flowchart are already formatted and placed in the spreadsheet, making it easier to complete.

Follow these steps to use a template for efficient and clear flowchart creation: 
 

  1. Define Objectives
    Identify what to map out with your flowchart. You could use a flowchart to visualize a new project workflow, improve an existing process, or understand the steps involved in a task.
     
  2. Identify Key Steps
    Outline the main actions, decisions, and outcomes involved in your process. Consider the start point, the end point, and what happens in between in order to break down the process into manageable pieces. 
     
  3. Gather Necessary Information 
    Collect any details (understanding responsibilities, timeframes, or decision criteria, etc.) that need to be included in each step of the flowchart.
     
  4. Use an Existing Flowchart Template 
    Download a basic flowchart template for Excel , then rename and save the document.
     

    Basic flowchart template for excel

  5. Name the Process Flow
    Open the template and click on the BLANK - Basic Flowchart tab. In the template’s header fields, enter the name of the process you want to chart, the flowchart’s author, and the creation date.
     

    Basic flowchart template excel process author date

  6. Map Out the Process 
    Mark the start of your process with the beginning shape (usually an oval). Click the START oval, select and highlight the existing text, and type the first step in your flowchart process.

    Repeat the same steps to change the content of each existing element in the flowchart. Use rectangles for actions or tasks, diamonds for decision points, and arrows to show the flow from one step to the next. 

    Pro Tip: Access flowchart shapes in your Excel file by clicking on the Insert menu and clicking Shapes.

Basic flowchart template excel insert shapes

  1. Customize the Template
    Use Excel's drawing tools to adjust the size, color, and placement of shapes.

    Pro Tip: To change font color and text formatting in a flowchart shape:
     
    • Select the Shape: Click the flowchart shape containing the text you want to modify. 
    • Change Shape Format and Size: Right-click the selected shape, and choose Format Shape. Click the Text Options tab in the formatting pane, and click the Text Box icon. Adjust the font, size, and color by selecting your preferences from the drop-down menus. 
       

      Basic flowchart template excel customize text

    • Change Shape Size: Click a shape. Click and drag the sizing handles on the corners or sides of the selected shape to resize.

      Basic flowchart template excel customize template date

  2. Review and Refine
    Once your flowchart is complete, review it for accuracy and clarity. Make sure it correctly reflects the process and is easy to understand. Adjust the layout or text as needed. 
     
  3. Share Your Flowchart 
    Save your completed Excel flowchart and share it with team members or stakeholders. You can export it as a PDF for easy sharing or print it for discussions and presentations.

How to Manually Create a Flowchart in Excel

You can create a flowchart in Excel by using the shapes feature to draw boxes and arrows to map your process. Making a flowchart in Excel is like drawing a guide to each step. It's helpful for understanding different tasks.

Follow these steps to make a flowchart in Excel:
 

  1. Open a Blank Excel Document
    Open Excel and click Blank Workbook. Name the workbook, choose a place to save it, and click the Save button.
     

  2. Start with Shapes
    In the Excel workbook, click the Insert tab, click the Shapes drop-down arrow, and scroll to Flowchart options. Click on a shape, then click in your Excel spreadsheet to add the  shape. Repeat for each shape you want to add to the flowchart.
     

    Excel flowchart insert shapes


    Tip: Pick shapes, such as the square (for processes), diamond (for decisions), and circle (for start/end points) for your flowchart. 
     

    Excel flowchart insert shapes flowchart


     

  3. Make Shapes Bigger 
    To provide enough room to write inside the selected shapes, you’ll need to make them bigger. Click a shape, and click Ctrl + A (on a PC and Command + A on a Mac) to select all the shapes. Click a corner on one of the shapes, and drag it to resize all the shapes together. 
     

    Excel flowchart resize shape


     

  4. Personalize the Shapes 
    After enlarging the shapes, double-click a shape to label it (e.g., Start, Task 1, Process, etc.). 
     

  5. Adjust Font Size as Needed
    Highlight the text in the shape, and click the Home tab. Change the text size and color using the font collection and font size drop-down menus, respectively. 
     

    Excel flowchart change font size


     

  6. Connect the Dots
    Add arrows to the flowchart to draw connections between the shapes. Click the Insert tab, click the Shapes drop-down arrow, and scroll to the Arrow options. Click an arrow, then click the Excel workbook. Resize and re-orient the arrow, and drag it to where it should go in the flowchart.  
     

    Excel Flowchart insert arrows


     

  7. Title the Flowchart
    Click the Insert tab, and click Text Box in the toolbar. Click where you want the title to appear on the flowchart and enter a title. 
     

  8. Save and Share the Flowchart 
    Once you've completed your flowchart, save and share it with others. 

Related Flowchart Templates

These templates offer extra functionality for creating flowcharts and additional formats. Use any of these templates to improve organization, make decisions, or identify how processes and teams work together.

Free Workflow Templates for PowerPoint

Basic Process Workflow by Phase Powerpoint Template

Dive into our selection of PowerPoint workflow templates to show how your workflows boost productivity and enhance team collaboration.

Free Process Mapping Templates

New Employee Training Process Map Template

These process mapping templates can help you outline every phase of your business operations clearly for better insight and refinement.

Free Workflow Templates

Project Management Workflow Template

Explore our workflow templates and use them to improve task ordering and the overall flow of business activities.

Free Business Organizational Chart Templates

Check out these organizational chart templates for small businesses, designed to depict company structure, roles, and reporting lines with clarity.

Free Decision Matrix Templates

Decision Matrix Weighted Template

Complete one of these unique decision matrix templates to make informed decisions by evaluating various options and their possible outcomes. 

Free SIPOC Template

SIPOC Diagram Template

See this  suppliers, inputs, process, outputs, customers (SIPOC) diagram template to capture a high-level overview of business processes, from suppliers to customers, in a concise format.

Free Gantt Chart Templates

Simple Gantt Chart Template

These Gantt chart templates are ideal for visually organizing project schedules, tasks, and deadlines in a clear, concise format.

Free Project Timeline Templates

Example Project Timeline Template

Use one of these project timeline templates to present the key phases and milestones of your project from start to finish in an easy-to-understand format.

Get the Most Out of Your Flowcharts with Smartsheet

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.

 

 

Improve your marketing efforts and deliver best-in-class campaigns.

Try Smartsheet for Free Get a Free Smartsheet Demo