Short answer: yes, Excel can build a real flow chart — and you don't need to download anything special to start. The grid you already stare at every day works as a layout canvas, and Excel ships with two flowchart tools most people never touch. The first is SmartArt, which drops a ready-made Process layout onto the sheet in two clicks. The second is the Shapes gallery under the Insert tab, which gives you the proper flowchart symbol set: process rectangles, decision diamonds, terminator rounded boxes, document shapes, manual input parallelograms, and the connector lines that snap between them.
Here's the thing. Excel isn't Visio. It isn't Lucidchart. But for most of what knowledge workers actually need — a hiring workflow, a refund approval path, a software release process, a swimlane that shows who hands what to whom — Excel handles it just fine, and the file opens on every machine in your company without a license fee.
This guide walks through every method. You'll see the SmartArt shortcut for quick diagrams, the manual Shapes approach for full control, the grid tricks that make alignment painless, and the free downloadable templates worth bookmarking. We'll cover swimlane (cross-functional) charts, value stream maps, decision trees, and a working understanding of BPMN basics. Then we'll look at where Excel hits its limits and when to graduate to a dedicated tool. By the end you'll have a reusable excel template saved to your machine.
One more thing before we dig in. If you're brand-new to the program, you might want a quick refresher on how to use excel — ribbon basics, cell references, the difference between a workbook and a worksheet. That foundation makes the rest of this guide click faster.
Ready? Let's build a flowchart.
Excel beats Word, PowerPoint, and most free online tools for one simple reason: the grid. Snap to Shape + Snap to Grid keep boxes aligned without measuring, and you can resize the whole diagram by adjusting row heights. Files open on any computer with Office or LibreOffice. Free. No login. No watermark. No export limits.
SmartArt is the fastest way to get a flowchart on the page. Insert → SmartArt → Process. That's it. You'll see roughly eight ready-made Process layouts plus another dozen related options under Hierarchy and Cycle. Pick one, click OK, and Excel drops it onto your sheet with placeholder text bubbles ready to type into.
The Process category covers most everyday workflows. Basic Process gives you a left-to-right chain of arrows. Step Up Process climbs diagonally for showing escalation. Continuous Block Process produces tidy stacked rectangles. Vertical Process flows top to bottom for printable documents. Picture Accent Process slots photos beside each step — useful for onboarding diagrams. Funnel narrows the visual emphasis toward the end of the chain.
To edit the text, you can type directly into each shape or open the text pane (the little arrow on the left edge of the SmartArt frame). The pane is faster — type, press Enter to add a sibling shape, press Tab to demote it to a sub-step. The diagram updates as you type. To add more steps, hit Enter from the last bullet. To remove steps, delete the bullet.
Styling lives under the SmartArt Design tab that appears on the ribbon when the graphic is selected. Color schemes follow your workbook theme by default, but you can override them — useful when you want red for warnings or green for approvals. Layout switching is non-destructive: pick a new layout from the gallery and your text moves with you. That alone makes SmartArt worth trying first before you commit to manual Shapes.
The catch? SmartArt struggles with anything non-linear. Branching, parallel paths, decision diamonds with two outputs — those don't really work. If your workflow has more than one possible path from any single step, skip ahead to the Shapes method below.
Horizontal chain of arrows. Best for simple A → B → C workflows with 3-6 steps. Default choice for new users.
Top-to-bottom flow. Prints well on a single letter-size page and reads naturally for documentation.
Diagonal climb showing escalation or growth. Use for tiered support levels or promotion pathways.
Each step pairs with a photo or icon. Add screenshots, profile pictures, or product images beside text.
Stacked rectangular blocks without arrows. Cleaner look for parallel or simultaneous activities.
Wide top narrowing to a point. Common for sales pipelines, recruitment funnels, and qualification stages.
When SmartArt runs out of road, the Shapes gallery picks up. Click Insert → Shapes and scroll past the basic rectangles to the section labeled Flowchart. You'll find the proper symbol set there. Each shape has a specific meaning in standard flowchart notation, and using them correctly makes your diagram readable to anyone who's seen one before.
The Process rectangle represents any action or step — "send invoice," "approve request," "update database." The Decision diamond marks a branching point with yes/no or multiple outcomes — "is amount over $500?" or "is the customer a member?" The Terminator rounded box marks start and end points. The Document shape (rectangle with wavy bottom) signals a printed or generated document. The Manual Input parallelogram shows a step where a human types something in. The Predefined Process rectangle (with double side bars) means "call this other sub-process I documented elsewhere."
Pick a shape, click on the canvas, and Excel draws it at your default size. Hold Shift while dragging to keep proportions. Right-click any shape and select Edit Text (or just start typing) to add the step description. Keep labels short — 2 to 5 words. "Approve request" beats "Manager approves the customer's request before processing."
For connector lines, head back to Insert → Shapes and pick a line under the Lines section. The Elbow Arrow Connector is the workhorse — it snaps to anchor points on each shape and bends automatically around obstacles. When you hover over a shape, you'll see four green dots: those are the anchor points. Click one, drag to the next shape's anchor point, and Excel routes the line for you. Move a shape later and the connector follows.
Rectangle. Represents an action, task, or step in the workflow. The most common shape in any flowchart. Examples: "Send email," "Review document," "Update spreadsheet," "Notify manager." Keep the verb-first wording for clarity.
Diamond. Marks a branching point. The shape should always contain a yes/no question or a short choice. Two arrows leave the diamond — one labeled Yes, one labeled No. Examples: "Is total > $500?", "Is customer verified?", "Has the deadline passed?"
Rounded rectangle (pill shape). Marks start and end. Every flowchart needs one Start and at least one End. "Start" goes at the top or far left. "End" goes at the bottom or far right. Don't skip these — they signal where to begin reading.
Rectangle with wavy bottom edge. Indicates a document is produced or required at this step. Use for printed forms, generated PDFs, signed contracts, or invoices. Pairs well with a Process step that says "Generate document."
Parallelogram (slanted to the right). Shows that a person enters data manually — typing into a form, scanning a barcode, filling out a paper sheet. Distinguishes human-entered data from automated system data.
Rectangle with double vertical bars on each side. Refers to another flowchart or sub-process documented separately. Useful when the same series of steps appears in multiple workflows — document it once, then reference it.
Small labeled circle. Used to continue a flowchart across pages or to reduce crossing lines on a complex diagram. Both ends use the same letter or number. Skip these unless your chart genuinely needs them — they often confuse more than they help.
Here's where Excel quietly outclasses dedicated diagram tools for everyday use. The grid is already there. The cells are already aligned. You just have to tell Excel to respect them.
First, turn on Snap to Grid and Snap to Shape. Both live under Page Layout → Align → Snap to Grid / Snap to Shape. With Snap to Grid on, every shape you drag locks to the nearest cell boundary. With Snap to Shape on, shapes snap to the edges and centers of other shapes nearby. Hold Alt while dragging to override the snap if you need precise placement.
Second, resize columns and rows before you start. A flowchart with 7-cell-wide columns and 5-row-tall rows looks proportional and prints beautifully. Set them once, then build inside that grid. Compare this to drawing on a blank canvas where you constantly fight to keep things lined up.
Select multiple shapes by Ctrl-clicking each one, or draw a marquee around them. Then go to Shape Format → Align → Distribute Horizontally (or Vertically). Excel spaces them at equal intervals between the leftmost and rightmost shapes. The same menu has Align Top, Align Middle, Align Bottom — invaluable for keeping decision diamonds and process rectangles on the same row.
When you're ready to print or screenshot, hide the cell gridlines so only your flowchart shows: View → uncheck Gridlines. The shapes stay; the grid disappears. Re-enable it whenever you need to edit.
For a related skill that pairs well with flowchart layouts, the technique for how to freeze a row in excel is worth knowing — freezing a header row keeps the flowchart title and legend visible while you scroll through a long vertical diagram.
Not every diagram is a simple A-to-B chain. Real workflows branch, loop, cross departments, and chase value through long supply chains. The shape vocabulary is the same — process rectangles, decision diamonds, terminators — but the layout changes for each type.
The default. A linear or lightly branching diagram of how something gets done. Good for documenting your excel templates library workflow, an SOP, or a customer journey. Start with a Terminator (Start), chain Process boxes with arrows, add Decision diamonds where outcomes diverge, end with another Terminator (End).
Picture horizontal lanes — each one labeled with a department or role: Sales, Operations, Finance, Customer. Place each process step inside the lane that owns it. Arrows cross lane boundaries to show handoffs. Swimlanes are the single best way to make accountability visible. Build them in Excel by widening rows to lane height, freezing the leftmost column for labels, and dropping shapes into the appropriate rows.
Borrowed from lean manufacturing. A VSM tracks material and information flow from raw inputs to finished output, with time and quantity data on each step. Excel suits VSMs well because you can put the diagram on rows 1-20 and the supporting numbers (cycle time, inventory, defect rate) in cells below each step. Tools like vlookup excel formulas can pull values from a master data table into the VSM annotations.
Top-down branching diagram. Used for troubleshooting guides, eligibility calculators, and choose-your-own-adventure customer service scripts. Start with a single Decision diamond at the top. Each Yes/No path splits into another Decision or terminates in a leaf — usually a Process box with the recommended action.
Business Process Model and Notation adds a richer symbol vocabulary on top of basic flowcharts: events (circles), gateways (diamonds with internal symbols), and activities (rounded rectangles). Pure BPMN is best done in Visio or a BPMN-specific tool, but Excel handles BPMN-lite — enough for governance documentation when you don't need machine-readable XML.
Linear or lightly branching workflow. Default choice for documenting standard operating procedures.
Cross-functional flowchart with horizontal lanes for each department or role. Makes handoffs visible.
Lean manufacturing diagram showing material and information flow with cycle time data.
Top-down branching diagram for troubleshooting, eligibility checks, and decision support.
Business Process Model and Notation with richer symbol set. Use Excel for documentation only.
A flowchart without color is harder to read than one with. Two or three minutes of color coding turns a wall of gray boxes into something a reader can scan in seconds. The rule: pick a small palette, assign meaning to each color, and stay consistent.
Assign one color per team. Sales gets blue. Operations gets green. Finance gets amber. Customer-facing steps get teal. Anyone reading the chart immediately sees which team owns which step. Don't pick more than five colors — beyond that, the brain stops grouping and starts noticing each shape individually.
Color by what kind of step it is, not who does it. Process boxes in light gray. Decision diamonds in yellow (decisions need attention). Terminators in dark gray (start/end are visual anchors). Document shapes in light blue. Manual input in pale pink. This works well for SOPs where the same person does most steps.
If the flowchart represents a live workflow, color steps by their state: green for completed, yellow for in-progress, red for blocked, gray for not yet started. Update colors as the work moves forward. This turns a static diagram into a status dashboard.
To apply color, right-click any shape and choose Format Shape. The Fill tab has Solid Color, Gradient, Pattern, and Picture options. Solid Color is the right answer 90% of the time — gradients muddy the visual hierarchy. For consistency across shapes, format one shape the way you want, then right-click and choose Set as Default Shape. Every new shape you add will inherit that style.
If you need to recolor a lot of shapes at once, hold Ctrl, click each shape you want to change, then apply the fill color once — all selected shapes update together. The Format Painter (the paintbrush icon on the Home tab) does the same job: click a shape with the style you want, then click the brush, then click any shape you want to match.
Building from scratch is fine if you enjoy the work, but most people want a head start. Several sites host high-quality free templates that open directly in Excel. Bookmark these three.
Open Excel, click File → New, type "flowchart" in the search box. Microsoft serves up around a dozen first-party templates including process diagrams, organization charts, and decision trees. All free, all open inside the program you're already using. The quality varies — some are excellent, others look stuck in 2010 — but Microsoft's offerings come without third-party watermarks or attribution requirements.
Vertex42 has been making excellent free Excel templates since the early 2000s. Their flowchart templates use clean color palettes, real flowchart symbols (not just rectangles), and include instruction tabs explaining how to customize each diagram. The site is donation-supported, so no signup required for downloads. Their swimlane and decision tree templates are particularly strong.
Template.net hosts thousands of flowchart templates across industries — HR onboarding, manufacturing QA, IT incident response, customer service escalation. The free tier requires you to download in Excel or Word format only (PDF and editable image formats are behind the paywall). Search filters let you narrow by industry, color scheme, and flowchart type. Watch for upsells — some templates labeled "free" want you to subscribe.
Both tools offer limited free accounts with Excel export. Draw the diagram in their interface, export to Excel, and you get a flat image embedded in a worksheet. You can't edit the shapes natively in Excel after export, but it's a workable path if you started in another tool. SmartDraw's free tier limits the number of diagrams per month; Lucidchart's free tier caps shapes per diagram and adds a watermark.
Three things separate a good template from a bad one. First, real flowchart symbols (decision diamonds, terminators) not just colored rectangles. Second, editable shapes — not flattened images. Right-click a shape; if you can change its color and text, you're good. Third, instructions. Templates without a brief "how to use this" tab assume too much and frustrate first-time users.
Once you find a template that fits, save your customized version as your house style. The next section covers exactly how to do that. For users new to file management in Excel, the basics of excel spreadsheet handling — save formats, file extensions, version compatibility — make this easier.
Excel handles 80% of flowchart work fine. The remaining 20% — large enterprise process documentation, BPMN 2.0 compliance, real-time multi-author collaboration, machine-readable diagram exports — pushes most teams to a dedicated tool. The good news: you don't have to abandon your Excel diagram to move up.
Microsoft Visio reads Excel data directly. If you've built a flowchart in Excel as a list (Step number, Step description, Next step, Owner), Visio's Data Visualizer can import that table and auto-generate a Visio diagram from it. Open Visio, choose Data Visualizer → Basic Flowchart, point it at your Excel file, map the columns. Visio builds the diagram in seconds and stays linked to the Excel source — edit the spreadsheet, refresh in Visio.
Lucidchart publishes an Excel add-in (available in the Office Add-Ins store) that embeds Lucidchart diagrams inside Excel worksheets. The diagram itself lives in Lucidchart's cloud; what you see in Excel is a live preview. Change the diagram in Lucidchart and the Excel embed updates. Useful for teams where some members live in Excel and others live in Lucidchart — both see the same source of truth.
Three signals tell you it's time. First, your flowchart file has grown past 100 shapes and Excel is sluggish to scroll. Second, two or more people need to edit the same diagram simultaneously. Third, you need to export to a standard format (BPMN XML, UML, archive-quality SVG) that Excel doesn't produce. Hitting any one of these regularly means a dedicated tool will pay for itself in time saved.
Google Sheets has improved its Insert → Drawing canvas, but for flowcharts it's still behind Excel. There's no SmartArt equivalent, the shape gallery is smaller, and connector lines don't anchor as cleanly. For collaboration-heavy teams already living in Google Workspace, draw diagrams in Google Drawings (drive.google.com — New → More → Google Drawings) and insert them into Sheets as images.
Open Excel. Page Layout → Align → enable Snap to Grid and Snap to Shape. Set columns A–J to width 9, rows 1–30 to height 25.
List 4-8 steps in order. Mark decision points where the path branches. Identify the start and end.
For linear flows, Insert → SmartArt → Process → Basic Process. For branching flows, Insert → Shapes → Flowchart section.
Drop a rounded rectangle at the top labeled Start. Drop another at the bottom labeled End. These anchor the diagram.
Drag rectangle shapes for each action step. Type the verb-first label ("Approve request") into each one.
Insert diamond shapes wherever the path forks. Label each with a yes/no question. Two arrows leave the diamond.
Insert → Shapes → Elbow Arrow Connector. Click anchor point on one shape, drag to anchor point on the next.
Right-click → Format Shape → Fill. Apply 2-3 colors max. Decisions in yellow, process in light gray, terminators in dark gray.
Select all shapes (Ctrl+A on canvas), then Shape Format → Align → Distribute Horizontally and Align Middle.
View → uncheck Gridlines for a clean look. File → Save As → choose .xltx (Excel Template) to reuse later.
Build it once, use it forever. Excel templates carry the .xltx extension (.xltm if you have macros) and behave differently from regular .xlsx workbooks. When you open a template, Excel creates a fresh copy — your original stays clean. That's exactly what you want for flowchart skeletons you'll customize repeatedly.
With your flowchart open, click File → Save As. In the file type dropdown, scroll to Excel Template (*.xltx). Excel automatically suggests the default template folder (usually C:\Users\YourName\Documents\Custom Office Templates on Windows, or ~/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized on macOS). Save there and your template appears in File → New → Personal next time you launch Excel.
One template per common flowchart type works best. Name them clearly: Process-Map-Template.xltx, Swimlane-4-Lanes-Template.xltx, Decision-Tree-Template.xltx. Inside each, leave placeholder text — "Step 1," "Step 2," "Decision point" — so users know where to edit. Add a small instruction tab at the top of the worksheet explaining the template's purpose and any conventions (color scheme, lane labels, etc.).
Store team templates in a shared SharePoint folder, OneDrive Business folder, or network drive. In Excel options, point the workgroup templates path to that shared location: File → Options → Save → Default personal templates location. Now every team member sees the same templates under File → New. Update the master file, every new diagram inherits the change.
Keep a version number in the filename: Process-Map-Template-v2.1.xltx. When you make changes, increment the version. Old diagrams stay readable — Excel templates aren't backwards-incompatible the way some other formats are — but anyone starting a new diagram uses the latest skeleton. For teams using Git or another version control system, .xltx files are binary, so plain-text diffing won't work; use the file modification date and version number in the filename to track changes.
If you find yourself copying the same flowchart over and over into different workbooks, save it as a separate .xltx and link from those workbooks rather than embedding. Insert → Object → Create from File → check Link to file. Update the template once and every workbook that links to it refreshes automatically. That's how documentation libraries stay current without anyone manually copy-pasting diagrams ten times. For deeper template skills, see the dedicated guide on the excel budget template approach — same .xltx workflow, different content.
Yes. SmartArt Process layouts produce clean, presentation-ready diagrams in under five minutes. For more complex flows with branching, the Shapes gallery has the full standard symbol set — process rectangles, decision diamonds, terminators, documents, and connectors. The result rivals dedicated diagram tools for everyday workflow documentation.
SmartArt gives you 8+ pre-built Process layouts that you populate by typing into a text pane — fast for linear A-to-B flows. Shapes gives you individual flowchart symbols you place and connect manually — slower but supports branching, swimlanes, and any layout you can imagine. Start with SmartArt for simple flows. Switch to Shapes when paths branch.
Yes. The best free sources are the built-in Microsoft template gallery (File → New → search "flowchart"), Vertex42.com (no signup required), and Template.net (free tier limited to Excel/Word formats). All three offer process maps, swimlanes, decision trees, and organizational charts that open directly in Excel.
Use the Elbow Arrow Connector from Insert → Shapes (under the Lines section). Hover over a shape to reveal four green anchor dots, click one anchor, then drag to the target shape's anchor dot. The line locks to both shapes and follows them around. Avoid straight-line shapes for this — they float and don't anchor.
Yes. Widen 4-6 consecutive rows to about 100 pixels each. Label the leftmost column with department names (Sales, Operations, Finance). Place each process step inside the row that owns it. Draw connectors that cross row boundaries to show handoffs. Freeze the leftmost column so labels stay visible when you scroll.
Use Excel when your diagrams stay under 50 shapes, you don't need real-time multi-author editing, and BPMN export isn't required. Use Visio when you've outgrown those limits — large enterprise processes, audit-grade documentation, BPMN compliance, or when your team already has Microsoft 365 with Visio included. Excel handles 80% of typical office flowcharts.
File → Save As → choose Excel Template (*.xltx) as the file type. Excel saves to your personal templates folder. Next time you open File → New, your template appears under Personal. Opening it creates a fresh copy automatically, so your original stays untouched as the master skeleton.
For PDF: File → Save As → choose PDF, set print area to just the diagram. For PNG or JPEG: select all shapes, right-click → Save as Picture (right-click works on grouped shapes too). For higher quality, copy the shapes, paste into a new PowerPoint slide, then right-click the pasted image and choose Save as Picture for a cleaner export at any resolution.