Value Stream Mapping Template Excel – 3 Free Versions

Home › Operations, Inventory & Logistics › Value Stream Mapping Template Excel

value-stream-mapping-template-excel.xlsxSample data
Value stream mapping template Excel with a current state value stream map showing supplier, production control and customer boxes, process data boxes, inventory, a timeline, production lead time, value-added time, process cycle efficiency and a chart of cycle time versus takt time

Previewing: Version 1 · Current State Map. Pick another version on the right.

Instant download · No sign-up · No email

Your numbers stay in your file. Nothing is uploaded and nothing is tracked.
3 free Excel templatesUpdated Nov 2026

Download these free value stream mapping templates for Excel to see where time is lost between a customer order and delivery. One version draws a current state map for a production line, one is a value stream dashboard for office and service processes with a kaizen plan, and one is a one-page A3 that compares the current state with the future state and shows the cash released.

Choose your version

File
.xlsx · 25 KB · 2 sheets
Works with
Microsoft Excel (.xlsx)
Macros
None · formulas only
Price
Free

Map a value stream in an Excel spreadsheet

Value stream mapping is a lean method that follows a product or a service from the supplier to the customer and records every step, with its cycle time, its changeover time, its inventory and the waiting between steps. The map shows how much of the total lead time is real work and how much is waiting, and so it points to the waste that is worth removing first. It is usually drawn with sticky notes or on a large sheet, but the numbers behind it (the cycle time, the takt time, the uptime, the yield) are easy to enter in a spreadsheet, which then does the arithmetic and draws the map.

These Excel templates give you three ways to use the method. The first is a current state map for a production line: you enter the customer demand, the suppliers and the data of up to seven processes, and the sheet draws the map with the inventory triangles and the timeline, and calculates the production lead time, the value-added time, the process cycle efficiency, the rolled throughput yield and the constraint. The second is a value stream dashboard for an office or a service process, with the activity ratio, the full-time equivalents, the annual labor cost, a current and a future state and a kaizen plan that ranks the improvements by impact and effort. The third is a one-page A3 report that puts the current state and the future state side by side, with the kaizen bursts, the takt time and the impact: the lead time reduction, the inventory cash released, the carrying cost saved and the operators redeployed.

Best for

  • Lean, continuous improvement and operations teams in manufacturing
  • Managers of service, office and healthcare processes that want to cut waiting time
  • Students, consultants and Six Sigma practitioners who learn or teach lean tools

Maybe not for

A dedicated lean software or a large wall map made together with the team. These templates are Excel files: they do the calculations and draw the map, and you can use them for the first draft or to keep the data of a map that you drew on paper.

Which version is right for you?

All three are free, formula-driven Excel files with sample data you can replace. They are independent, so you can download more than one.

Version 1

Current State Map

Value stream mapping template Excel with a current state value stream map showing supplier, production control and customer boxes, process data boxes, inventory, a timeline, production lead time, value-added time, process cycle efficiency and a chart of cycle time versus takt time

Enter the demand and the data of up to seven processes and the workbook draws the current state value stream map with a timeline, and calculates lead time, cycle efficiency, yield and the constraint.

Current State MapVSM Data

.xlsx · 25 KB

Version 2

Value Stream Dashboard

Excel value stream mapping template with a value stream dashboard showing lead time, process time, activity ratio, rolled percent complete and accurate, FTE, annual labor cost, kaizen progress and charts of lead time and process time by step

A value stream dashboard for office and service processes with a current and a future state, an automate, improve or eliminate action for every step and a kaizen plan with impact, effort, savings and payback.

DashboardValue StreamKaizen Plan

.xlsx · 32 KB

Version 3

Current vs. Future State A3

Excel value stream mapping template with an A3 one-page report comparing the current state and the future state with takt time, kaizen bursts, lead time reduction, cash released from inventory, carrying cost savings and operators redeployed

A one-page A3 with the current state and the future state maps, the kaizen bursts, the takt time and an impact summary with the lead time reduction, the inventory cash released and the operators redeployed.

VSM A3VSM Data

.xlsx · 21 KB

What is inside the value stream mapping Excel templates

Version 1: Current State Map

The Current State Map sheet draws the value stream from the supplier on the left to the customer on the right, with a production control box, the process boxes with their data, the inventory between them and a timeline of the waiting and the processing time at the bottom. Measures show the production lead time, the value-added time, the process cycle efficiency, the rolled throughput yield, the constraint, the cash that is tied up in inventory and the bottlenecks, and a chart compares the cycle time of each process with the takt time. On the VSM Data sheet you enter the customer, the demand, the available working time, the suppliers, and for each of up to seven processes the name, the cycle time, the changeover time, the uptime, the yield, the number of operators and the inventory before it.

Version 2: Value Stream Dashboard

The Dashboard sheet shows the lead time, the process time, the activity ratio, the rolled percent complete and accurate, the full-time equivalents, the annual labor cost, the progress of the kaizen actions and the next deadlines, with two charts. On the Value Stream sheet you list the steps of the process with the current and the future time, the wait, the percent complete and accurate, the people, and an action for each step: automate, improve or eliminate. The Kaizen Plan is a register of the improvements with the impact, the effort, a priority, the owner, the deadline, the status, the savings and the payback.

Version 3: Current vs. Future State A3

The A3 sheet has the current state map above and the future state map below, drawn from the same data, with the takt time, the kaizen bursts that mark the improvements and an impact summary: the lead time reduction, the cash released from inventory, the savings in carrying cost and the operators who can be redeployed. On the VSM Data sheet you enter the customer demand and the data of up to six processes, with the current and the future cycle time, changeover, inventory and operators.

How to use a value stream mapping template in Excel

  1. Download
    Pick the version you want and open it in Excel. The files have a sample value stream, so you can see how each sheet works.
  2. Define the value stream
    Enter the product family or the service, the customer demand, the working time and the suppliers, and work out the takt time.
  3. Enter the process data
    For each process enter the cycle time, the changeover time, the uptime, the yield, the number of operators and the inventory before it.
  4. Read the map and the timeline
    Look at the production lead time, the value-added time, the process cycle efficiency and the constraint. Compare the cycle times with the takt time.
  5. Plan the improvements
    List the kaizen actions, estimate their impact, and build the future state map to see the lead time and the cash that you can release.

Replace the sample data with your own. The map, the timeline, the measures and the charts update on their own.

Which value stream mapping template do you need?

Current State MapValue Stream DashboardCurrent vs. Future State A3
ForA production line from supplier to customerOffice, service and healthcare processesA one-page report for the improvement team
Best forManufacturing and lean teamsService and administrative teamsManagers and kaizen workshops
Data you enterUp to 7 processesSteps with current and future timesUp to 6 processes
Main outputsLead time, value-added time, cycle efficiency, yield, constraint, inventory cashLead time, activity ratio, FTE, annual labor cost, kaizen planCurrent and future map, kaizen bursts, takt time, cash released, savings
Sheets232
ChartsYesYesNo

They are separate files, so you can use more than one.

Tips for a good value stream map

  • Map one product family or one service at a time, so that the map stays readable.
  • Walk the process yourself and write down what you see. Do not rely on the procedures alone.
  • Start with the customer. Work out the takt time from the demand and the available time.
  • Measure the waiting between steps. Inventory and queues are usually most of the lead time.
  • Compare each cycle time with the takt time to find the constraint.
  • Draw the future state before you launch actions, and mark each improvement with a kaizen burst.
  • Review the map after each improvement cycle and keep the old versions to show progress.

Frequently asked questions

Are these value stream mapping templates for Excel free?

Yes. All three versions are free to download as .xlsx files. You do not need an account or an email address.

Which version should I choose?

Choose the Current State Map (Version 1) to map a production line with its processes, inventory and timeline. Choose the Value Stream Dashboard (Version 2) for an office or service process with a kaizen plan. Choose the Current vs. Future State A3 (Version 3) for a one-page report that compares the two states and shows the savings.

What is value stream mapping?

Value stream mapping is a lean tool that shows the flow of material and information from the supplier to the customer. It records the time that each step takes and the time that the product waits, so that you can see the waste and decide what to improve.

What is takt time?

Takt time is the pace of production that matches the customer demand. You work it out by dividing the available working time by the demand in the same period. If a process takes longer than the takt time, it cannot meet the demand and it is a constraint.

What is process cycle efficiency?

Process cycle efficiency is the value-added time divided by the total lead time. A low figure means that the product spends most of its time waiting. Version 1 calculates it, and Version 2 shows a similar activity ratio.

Can I use value stream mapping for a service or an office process?

Yes. The method works for any process that has steps, waiting and a customer. Version 2 is made for office and service work and measures the time in hours or days instead of seconds.

What is a kaizen burst?

A kaizen burst is a mark on a value stream map that shows where an improvement is needed or planned. Version 3 shows the bursts on the future state map, and Version 2 lists the improvements in a kaizen plan with their impact and effort.

Does the template work in Google Sheets?

The files are made for Microsoft Excel and use standard formulas with no macros. You can upload them to Google Drive and open them with Google Sheets, but some formatting or charts may look different.

Is my information stored online?

No. The templates are plain Excel files, so the names, addresses, dates and amounts you type stay in your own file on your own computer.

These templates are documentation tools with made-up sample content. Review every SOP with the people who do the work and with your quality, safety and legal teams before you rely on it. Excel is a trademark of Microsoft Corporation; Excel Corner is not affiliated with Microsoft.