SWOT Analysis: How to Do It, Example & Free Excel Template

A SWOT analysis helps you understand what is happening inside your business and which external changes could help or hurt its performance.

It is not simply about filling four boxes with general ideas. To make a SWOT analysis useful, you need to work with specific information, separate internal and external factors, prioritize what matters most, and connect the findings to possible decisions.

In this guide, you’ll learn how to conduct a SWOT analysis step by step, identify strengths, weaknesses, opportunities and threats, prioritize the most important factors, and turn the analysis into possible strategies using a TOWS matrix. You’ll also find a practical small-business example and a free Excel SWOT analysis template to organize the process.

A SWOT analysis is a strategic diagnostic tool that combines a business’s internal strengths and weaknesses with external opportunities and threats. Its purpose is to understand the current situation, establish priorities, and identify possible responses before creating an action plan.

Table of Contents

• What Is a SWOT Analysis?
• What Is a SWOT Analysis Used For?
• Define What You Are Analyzing
• Internal vs. External Factors
• How to Conduct a SWOT Analysis in 8 Steps
• SWOT Analysis Example
• How to Interpret the Results
• How to Build a TOWS Matrix
• How to Choose the Best Alternatives
• Common SWOT Analysis Mistakes
• SWOT Analysis Checklist
• What to Do After a SWOT Analysis
• Frequently Asked Questions
• Free SWOT Analysis Excel Template

What Is a SWOT Analysis?

A SWOT analysis organizes four types of factors that can influence a business:

Factor	Origin	What It Represents
Strengths	Internal	Capabilities that help the business perform
Weaknesses	Internal	Limitations that reduce performance or increase vulnerability
Opportunities	External	Favorable conditions the business may be able to use
Threats	External	External changes that could negatively affect the business

Its primary purpose is to organize a business diagnosis.

For example, a neighborhood bakery may have a loyal customer base as a strength, outdated product costs as a weakness, growing demand for office breakfast delivery as an opportunity, and increasing ingredient prices as a threat.

The value of the analysis comes from looking at these factors together and determining which ones deserve the most attention.

Strengths

Strengths are internal resources, capabilities, or conditions that help the business achieve better results.

• Strong local reputation.
• Experienced employees.
• Fast order fulfillment.
• High margins in an important product category.
• A strong base of repeat customers.

Weaknesses

Weaknesses are internal conditions that limit sales, margins, operations, or growth.

• Undocumented processes.
• Excessive owner dependency.
• Poor inventory control.
• Limited production capacity.
• Insufficient customer information.

Opportunities

Opportunities are favorable external conditions the business may be able to take advantage of.

• Growth of a digital sales channel.
• Unmet demand in a local market.
• New payment options.
• Favorable changes in customer behavior.
• Potential business partnerships.

Threats

Threats are external factors that could reduce sales, margins, operating capacity, or growth.

• New competitors entering the market.
• Rising input costs.
• Regulatory changes.
• Loss of a critical supplier.
• Lower-priced substitutes.

SWOT Analysis vs. SWOT Matrix vs. TOWS Matrix

Concept	What It Means
SWOT Analysis	The process of gathering, classifying, evaluating, and interpreting information
SWOT Matrix	The four-quadrant visual where strengths, weaknesses, opportunities, and threats are organized
TOWS Matrix	A matching process that connects internal and external factors to generate strategic alternatives

The SWOT analysis creates the diagnosis. The SWOT matrix organizes it visually. The TOWS matrix helps move from diagnosis toward possible strategic responses.

What Is a SWOT Analysis Used For?

A SWOT analysis provides an organized view of a business situation before important decisions are made.

• Review the overall position of a business.
• Evaluate a new product launch.
• Analyze an area with recurring problems.
• Prepare for expansion.
• Understand a decline in sales.
• Evaluate a new sales channel.
• Anticipate business risks.
• Assess whether the business can take advantage of an opportunity.

At the strategic level, SWOT helps identify where growth potential exists and which limitations could prevent the business from capturing it.

At the management level, it helps organize problems and establish priorities.

At the operational level, it can reveal specific weaknesses in inventory, customer service, production, purchasing, sales, or staffing.

When Should You Conduct a SWOT Analysis?

A SWOT analysis can be particularly useful when:

• Sales are changing and the cause is unclear.
• The business has many ideas but no clear priorities.
• A new competitor enters the market.
• You are considering a new location.
• You plan to launch a new sales channel.
• Operating costs are increasing.
• The business depends heavily on a small number of customers or suppliers.
• You need to review the performance of a specific area.
• A new planning cycle is beginning.

You can also update the analysis when an important change occurs in the market, technology, regulation, customer behavior, or competitive environment.

What SWOT Cannot Do by Itself

A SWOT analysis does not replace other types of business analysis.

It does not prove that an opportunity will be profitable, predict what will happen, or automatically turn findings into an executable plan.

SWOT helps organize the diagnosis. The decisions that follow still require evaluation of resources, responsibilities, costs, timelines, risks, and performance indicators.

Before You Start: Define What You Are Analyzing

One of the most common mistakes is trying to analyze the entire company, every problem, and every future project in a single SWOT matrix.

Before filling the four quadrants, define the scope of the analysis.

Define the Business, Area, or Decision

You might analyze:

• The entire company.
• The sales department.
• Operations.
• The management team.
• A product or service.
• A potential new location.
• A sales channel.
• An expansion decision.

The more specific the scope, the more useful the result is likely to be.

For example, analyzing “the situation of a bakery” is much broader than asking whether “the bakery has the capacity to expand breakfast deliveries to nearby offices over the next six months.”

The second version gives the analysis a clearer direction.

Create an Analysis Question

A useful question should define the decision and, when possible, include a time frame.

What internal and external factors could affect the opening of a second location during the next 12 months?

What capabilities and risks could affect the restaurant’s ability to expand delivery operations?

What conditions could support or limit the store’s online sales during the next six months?

How to Separate Internal and External Factors

Correct classification is one of the foundations of a useful SWOT analysis.

Type	Categories	Control Question
Internal	Strengths and Weaknesses	Does this factor depend primarily on the business?
External	Opportunities and Threats	Does this factor come primarily from the market or external environment?

Factor	Classification	Why
Experienced team	Strength	It is an internal capability
Slow operating process	Weakness	It can be addressed through internal management
Growing demand for online orders	Opportunity	It is a market change
New low-price competitor	Threat	It originates in the competitive environment

A company usually has more direct influence over its strengths and weaknesses. Opportunities and threats cannot normally be controlled directly, but the business can prepare for them, respond to them, or adapt.

How to Conduct a SWOT Analysis in 8 Steps

A useful SWOT analysis should be supported by real information. Avoid building the entire matrix from opinions generated during a single meeting.

1. Gather Information About the Business and Its Environment

Start with internal information such as:

• Sales.
• Margins.
• Most profitable products or services.
• Inventory turnover.
• Returns.
• Customer complaints.
• Delivery times.
• Operating costs.
• Team capacity.
• Customer concentration.
• Supplier dependency.

Then review external information such as:

• Competitor activity.
• Market prices.
• Customer buying behavior.
• New technologies.
• Regulatory changes.
• Economic conditions.
• Emerging sales channels.
• Industry trends.

2. Identify Strengths

A strength should represent an internal capability that helps the business sell, operate, protect margins, or differentiate itself.

Useful questions include:

• What do we do particularly well?
• Why do customers recommend us?
• Which resource allows us to perform better?
• Which products or services generate attractive margins?
• Which capability would be difficult for competitors to copy?
• Which part of the operation performs consistently?

A useful strength should have some connection to results.

“We provide good quality” is too general.

Our return rate is low because every order is inspected before shipping.

3. Identify Weaknesses

A weakness is an internal condition that reduces results or increases vulnerability.

• Where are sales being lost?
• Which processes create delays?
• Which tasks depend on only one person?
• Which costs are poorly controlled?
• What information is missing when decisions are made?
• Which customer complaints keep repeating?
• What limits the business’s ability to grow?

Do not confuse a weakness with an outcome. “Low sales” describes a result. The underlying weakness might be low conversion, poor follow-up, inventory shortages, or an unclear value proposition.

4. Identify Opportunities

An opportunity is a favorable external condition that the business may be able to use.

• Which customer needs are not being served well?
• Which sales channels are gaining relevance?
• Which changes make it easier to sell or collect payments?
• Which market segments are growing?
• Which partnerships could increase reach?
• Which trends match capabilities the business already has?

Not every favorable market change is automatically an opportunity. It should have a reasonable connection to the business’s capabilities.

For example, growing online demand may be attractive for a retailer with products that are easy to ship. It may be much less useful for a company that still struggles with inventory accuracy, fulfillment, or delivery capacity.

5. Identify Threats

A threat is an external condition that could negatively affect sales, margins, cash, operations, or growth.

• What could reduce demand?
• What could increase operating costs?
• Which external dependency creates significant risk?
• Which competitors are gaining ground?
• Which regulatory changes could require additional investment?
• Which technologies could make the current offer less attractive?
• What could interrupt operations?

Threats should be written specifically. “The economy” is not a useful threat.

Rising imported ingredient costs could reduce the margin of our best-selling product category.

If increasing costs are a major concern, review your fixed and variable costs separately so you can determine which expenses are changing and how they affect profitability.

6. Write Specific Factors

Each factor should describe a situation that can be understood and, ideally, verified.

Too Vague	More Specific
Good service	45% of sales come from repeat customers
Poor management	There is no weekly cash review
Too much competition	Two competitors opened locations in the same area
Social media	Purchase inquiries from social channels increased during the last quarter
Suppliers	One supplier provides the company’s best-selling product

A useful structure is:

Factor + evidence or consequence.

This makes prioritization easier and reduces discussions based only on perception.

7. Remove Duplicates

Review whether several factors are describing essentially the same problem.

• Low sales.
• Slow growth.
• Not enough customers.
• Weak demand.

These may share the same underlying cause. Keeping them as four independent factors can exaggerate their importance.

Group related observations and keep the wording that explains the situation best. Also avoid treating a cause, symptom, and consequence as three separate factors when they describe the same issue.

8. Prioritize by Impact and Urgency

Not every SWOT factor deserves the same level of attention.

One simple management method is to rate each factor from 1 to 5 for impact and urgency, then calculate:

Priority Score = Impact × Urgency

Impact estimates how strongly the factor could help or hurt the business.

Urgency estimates how quickly the factor deserves attention.

Factor	Impact	Urgency	Score
Dependence on one critical supplier	5	5	25
High repeat-purchase rate	4	3	12
Incomplete digital catalog	3	2	6

A simple interpretation for the worksheet is:

Score	Priority
16–25	High
8–15	Medium
1–7	Low

This scoring method is a practical prioritization aid used in the downloadable template. It is not a required component of the standard SWOT framework and should not replace business judgment.

You should also examine relationships between factors. A medium-priority weakness can become much more important if it increases the effect of a critical threat.

SWOT Analysis Example for a Small Business

Consider a neighborhood bakery and café that wants to increase breakfast orders from nearby offices during the next six months.

Analysis Objective

Evaluate whether the bakery can increase office breakfast orders without reducing margins or disrupting in-store service.

Information Collected

The business reviews sales, order volume, preparation times, customer feedback, product costs, and local competitors.

• Repeat customers represent an important share of sales.
• Production starts early in the morning.
• Online orders are currently recorded manually.
• Several product costs have not been updated recently.
• Nearby offices have asked about breakfast options.
• A new competitor offers delivery.
• Flour and dairy prices have increased.

SWOT Matrix

Strengths	Opportunities
Strong reputation among local customers	Nearby offices are looking for breakfast options
Production is available early in the morning	Digital order inquiries are increasing
Repeat customers already trust product quality	Potential partnerships with offices and local events
Can prepare small orders quickly	Customers are using digital payments more often

Weaknesses	Threats
Online orders are recorded manually	New competitor offers delivery
Costs are outdated for several products	Flour and dairy prices are increasing
Digital menu is incomplete	Business customers are price sensitive
Owner dependency for coordinating orders	Peak-hour orders could exceed capacity

Prioritizing the Factors

Factor	Category	Impact	Urgency	Score
Nearby offices are looking for breakfast options	Opportunity	5	4	20
Online orders are recorded manually	Weakness	4	5	20
Flour and dairy prices are increasing	Threat	5	4	20
Strong local reputation	Strength	4	3	12
Digital menu is incomplete	Weakness	3	3	9

The growth opportunity looks attractive, but two issues deserve attention before the bakery promotes the new service aggressively: manual order processing and outdated product costs.

The lesson is not simply “start selling more breakfasts.” The business first needs to improve the operating process and verify margins.

How to Interpret a SWOT Analysis

Interpreting SWOT does not mean counting how many items appear in each quadrant.

Look for relationships, concentrations, and dependencies:

• Which strengths can help capture an opportunity?
• Which weaknesses make an opportunity harder to pursue?
• Which threat becomes more dangerous because of a weakness?
• Which strength can reduce exposure to a threat?
• Which factor appears connected to several other problems?
• Which issues combine high impact with high urgency?

In the bakery example, demand from nearby offices is an opportunity. But manual order processing could create mistakes and delays.

The conclusion should therefore be more specific than “sell online.” The company should first organize the order process and update its costs so that growth does not create operational or margin problems.

To interpret a SWOT analysis, prioritize the most important findings and then examine how internal strengths and weaknesses interact with external opportunities and threats.

How to Build a TOWS Matrix From Your SWOT Analysis

A TOWS matrix connects internal and external SWOT factors to generate possible strategic alternatives.

Match	Combination	Purpose
SO	Strengths + Opportunities	Use strengths to capture opportunities
ST	Strengths + Threats	Use strengths to reduce exposure to threats
WO	Weaknesses + Opportunities	Correct weaknesses that prevent the business from capturing opportunities
WT	Weaknesses + Threats	Reduce weaknesses that increase exposure to threats

SO Strategy

Question: How can we use an existing strength to capture an opportunity?

• Strength: strong reputation among local customers.
• Opportunity: nearby offices are looking for breakfast options.
• Possible SO strategy: offer a breakfast trial to repeat customers who work at nearby offices.

ST Strategy

Question: How can a strength help reduce the effect of a threat?

• Strength: production is available early in the morning.
• Threat: a new competitor offers delivery.
• Possible ST strategy: differentiate through earlier delivery windows and shorter preparation times.

WO Strategy

Question: What weakness should we correct so we can capture an opportunity?

• Weakness: online orders are recorded manually.
• Opportunity: digital order inquiries are increasing.
• Possible WO strategy: create one standard order and confirmation process before promoting the channel more aggressively.

WT Strategy

Question: What weakness should we reduce because it increases exposure to a threat?

• Weakness: product costs are outdated.
• Threat: flour and dairy prices are increasing.
• Possible WT strategy: update product costs and define a minimum margin before publishing new breakfast packages.

The TOWS alternatives are still options to evaluate. They are not automatically final decisions.

How to Choose the Best Strategic Alternatives

You do not need to implement every idea generated by the analysis.

Compare alternatives using criteria such as:

• Expected impact.
• Effort.
• Cost.
• Time required.
• Risk.
• Current capabilities.
• Ease of testing the idea on a small scale.

Alternative	Impact	Effort	Initial Decision
Create a standard order process	High	Low	Prioritize
Test breakfast delivery with three offices	High	Medium	Run a pilot
Open another location	High	High	Do not prioritize yet
Update product costs	High	Low	Prioritize

In this example, the bakery should update its costs, organize the ordering process, and test the opportunity on a small scale before considering a larger expansion.

Common SWOT Analysis Mistakes

Confusing Internal and External Factors

Limited production capacity is an internal weakness. Rising ingredient prices are an external threat.

A useful control question is: Can the business directly change this factor?

Writing Factors That Are Too General

Words such as “quality,” “competition,” “technology,” or “customers” do not describe a specific business situation. Add evidence or a consequence.

Confusing an Opportunity With an Action

“Sell online” is an action. The opportunity might be increasing online demand or insufficient competition in a digital channel.

Confusing a Weakness With an Outcome

“Low sales” is an outcome. The weakness could be low conversion, poor follow-up, inventory shortages, or an unclear offer.

Including Too Many Factors

A long list makes prioritization difficult. For an initial analysis, focus on the factors that are most relevant and best supported by evidence.

Giving Every Factor the Same Weight

A threat that could interrupt operations should not receive the same attention as a low-impact improvement with little urgency.

Copying a Generic SWOT From Another Company

A list copied from another business does not represent your own reality. Your factors should come from your data, observations, customers, competitors, suppliers, and operating conditions.

Stopping With Four Lists

The matrix should lead to interpretation. After classifying the factors, prioritize them, connect them, and identify possible responses.

Treating Every TOWS Alternative as a Final Decision

An SO, ST, WO, or WT strategy is an option to evaluate. Before committing resources, review cost, capacity, risk, expected impact, and available evidence.

SWOT Analysis Checklist

• Is the objective of the analysis clearly defined?
• Is the scope limited to a specific business, area, or decision?
• Are strengths and weaknesses truly internal?
• Are opportunities and threats external?
• Is each factor written specifically?
• Is there evidence supporting the most important factors?
• Have duplicate observations been removed?
• Have the factors been prioritized?
• Have internal and external factors been connected?
• Have SO, ST, WO, and WT alternatives been considered?
• Have you selected only a few alternatives for deeper evaluation?
• Is the next step clearly defined?

What to Do After a SWOT Analysis

A SWOT analysis helps organize the diagnosis and generate alternatives, but it is not a complete strategic plan by itself.

The next step is to evaluate the alternatives, choose priorities, and convert them into:

• Objectives.
• Actions.
• Owners or responsible people.
• Resources.
• Deadlines.
• Performance indicators.
• Follow-up routines.

SWOT helps you understand and organize the situation. Strategic planning turns selected priorities into execution and follow-up.

When the English strategic-planning guide is available, this section should become one of the strongest internal links from this article.

Frequently Asked Questions About SWOT Analysis

What does SWOT stand for?

SWOT stands for Strengths, Weaknesses, Opportunities, and Threats.

What are the four parts of a SWOT analysis?

The four parts are strengths and weaknesses, which are internal, and opportunities and threats, which come from the external environment.

How many factors should a SWOT analysis include?

There is no mandatory number. For a small business, starting with three to five important factors in each category can make the analysis easier to interpret. The quality and relevance of the factors matter more than creating a long list.

How often should a SWOT analysis be updated?

You can review it periodically as part of strategic planning, but it should also be updated when an important change occurs, such as a new competitor, a major cost increase, regulatory changes, expansion plans, or a significant shift in customer behavior.

What is the difference between SWOT and TOWS?

SWOT identifies and organizes strengths, weaknesses, opportunities, and threats. TOWS uses those same factors to create possible strategies by matching internal and external conditions through SO, ST, WO, and WT combinations.

Is SWOT analysis only for large companies?

No. Small businesses can use SWOT to evaluate growth opportunities, new locations, sales channels, operational problems, competitive changes, and other important decisions.

Download the Free SWOT Analysis Excel Template

A basic four-box worksheet can help you brainstorm, but a more structured template makes it easier to document evidence, prioritize factors, and turn the diagnosis into possible actions.

The free SWOT Analysis Excel Template includes a complete example that you can replace with your own business information.

The workbook includes:

Feature	What It Helps You Do
Analysis objective and question	Define the business, area, or decision being evaluated
Factor and category	Record and classify Strengths, Weaknesses, Opportunities, and Threats
Evidence	Support each factor with specific information
Impact and Urgency	Evaluate importance and timing
Score and Priority	Automatically prioritize factors
Include and Matrix Order	Select which factors appear in the visual SWOT matrix
SWOT Matrix	Display the selected factors in the four quadrants
TOWS Matrix	Connect internal and external factors using SO, ST, WO, and WT combinations
Alternative Evaluation	Compare strategic options using Impact, Effort, Balance, and Initial Decision

The workbook includes Instructions, Glossary, Factors, SWOT Matrix, and TOWS Matrix sheets, plus a complete bakery and café example that you can remove and replace with your own analysis.

Download Free SWOT Analysis Template

Excel .xlsx format. Keep an original copy before replacing the example so you can preserve the workbook structure, formulas, dropdowns, and validation rules.

Start by entering factors supported by real information. Then prioritize the most important findings and use the TOWS section to develop two or three alternatives worth evaluating further.