How to Find and Use Excel's Free Flowchart Templates

Make a Flowchart in Excel from a Template

 Geralt / Pixabay

Microsoft has a large number of Excel templates available online that make it easy to quickly create a good-looking and functional worksheet for any number of purposes. However, the easiest type of template to use to create a flowchart in Excel is SmartArt.

Instructions in this article apply to Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

How to Make a Flowchart in Excel

There are several flowchart designs available in Excel. The key is to look in the SmartArt Process category.

  1. Open the Excel worksheet where you want to add a flowchart.

  2. Go to the Insert tab.

    Screenshot of Excel with Insert tab selected
  3. In the Illustrations group, select SmartArt to open the Choose a SmartArt Graphic dialog box.

    Choose a SmartArt Graphic window in Excel
  4. Choose Process in the left pane.

    Screenshot of Process category in Excel SmartArt
  5. Select the flowchart template you want to use.

    Flowchart template example in Excel
  6. Select OK. A new basic flowchart appears on the spreadsheet.

Customize the Flowchart

Once you have the basic template, make changes to it and create the flowchart you need.

To change the appearance of the SmartArt flowchart:

  1. Select a blank area of the flowchart to activate the SmartArt Tools tabs.

  2. To change the color, go to SmartArt Tools Design and select Change Colors.

    Screenshot of Change Colors in SmartArt Tools
  3. To add text to the shapes, select a shape, type the text, then press Enter.

    Screenshot of text in flowchart
  4. To add more shapes, select the shape to which you want to connect a new shape, go to SmartArt Tools Design, select the Add Shape dropdown arrow, and choose where you want to insert a new shape.

    Screenshot of Add Shape

    Not all Add Shape options are available for all flowcharts.

  5. To change the layout of the flowchart, go to SmartArt Tools Design and choose a option from the Layouts group.

    Screenshot of Layouts in SmartArt Tools
  6. To change any shape in the flowchart, right-click the shape, point to Format Shape, and choose the shape you want to apply.

    Screenshot of Change Shape in Excel flowchart
  7. Save the worksheet when you are happy with the changes you've made.