How to Do Thematic Analysis in Excel

Wading through open-ended survey responses, interview transcripts, or product reviews can feel like searching for a needle in a haystack. Thematic analysis is the process of turning that mountain of qualitative text into clear, actionable themes, and you don’t need special software to get started. This guide will walk you through, step-by-step, how to perform a robust thematic analysis using a tool you already have: Microsoft Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is Thematic Analysis?

Before we jump into spreadsheets, let's quickly clarify what we're doing. Thematic analysis is a method for identifying, analyzing, and reporting patterns (or "themes") within qualitative data. Essentially, you’re looking for the common threads in people's responses to understand the bigger picture.

It’s perfect for answering questions like:

• What are the top three frustrations our customers have with our app?
• What common suggestions for improvement come up in employee feedback?
• What are the main reasons people love our new feature?

While dedicated tools like NVivo exist, Excel is surprisingly powerful for this task, especially if your dataset isn't massive. It’s accessible, familiar, and with a bit of setup, it can handle the job beautifully.

Step 1: Set Up Your Excel File for Success

A little organization upfront will save you a world of pain later. Don't just dump your text into a single column and hope for the best. A structured file is the foundation of a good analysis.

Create Your Data Structure

Open a new Excel workbook. The first sheet will be your "Raw Data." Set up your columns like this:

• Response_ID: A unique number for each individual response (e.g., 1, 2, 3...). This is crucial for tracking and ensuring you don't lose your way.
• Raw_Data: This is where you'll paste the actual text feedback. One full response per row.
• Notes: A scratchpad column for your initial thoughts as you first read the data. Don't overthink this, it's for gut reactions.
• Codes: We'll get into this in a moment, but this column is for short labels that summarize a specific point in the text.
• Theme: This is for the broader category your codes will eventually fall into.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Transform Your Data into an Excel Table

Once you have your columns and you’ve pasted in your raw data, click anywhere inside your data range and press Ctrl+T (or Cmd+T on a Mac). This turns your data into an official Excel Table.

Why is this a big deal?

• Automatic Formatting: The table looks neat and is easy to read.
• Easy Filtering and Sorting: You’ll get filter dropdowns on each header automatically, which is essential for our analysis.
• Formulas are Easier: Formulas will automatically fill down the entire column as you add new rows.

Step 2: The Six Phases of Thematic Analysis in Excel

With your file set up, you can now begin the analysis, which generally follows six phases. This isn't a rigid, one-way street, you'll likely bounce between these steps as insights emerge.

Phase 1: Familiarize Yourself with the Data

You can't analyze what you don't understand. Before you start labeling anything, read through every single response at least once. Your goal here is to simply immerse yourself in the data. What are people talking about? What's the overall tone? Use that "Notes" column to jot down any interesting initial observations or repeated ideas that pop out at you.

Phase 2: Generate Initial Codes

This is where the real work begins. Go through your data again, this time row by row, and assign short, descriptive labels - or "codes" - to specific pieces of text. A code is a concise summary of an idea.

For example, imagine a user-feedback response:

"I love how quick the app is to load, but I find the checkout process really confusing because there are too many steps."

In your "Codes" column for this row, you might enter: positive app speed, confusing checkout.

Tips for Coding:

• Be granular: Code everything that seems relevant. You can always combine codes later.
• Use a consistent format: Separate multiple codes in a single cell with a semicolon (,) or a comma. This keeps your data clean.
• Create a "Codebook": Make a new tab in your Excel file called "Codebook." List every code you create and a brief definition. This ensures you apply codes consistently across the entire dataset, especially if the project is large or involves multiple analysts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Phase 3: Search for and Collate Potential Themes

Once you’ve coded all your data, it's time to zoom out from the individual codes and look for larger patterns. Themes are the broader ideas that your codes collectively point to. For example, codes like confusing checkout, hard to find search bar, and unclear menus might all point to a broader theme of "Poor Usability."

This is where your Excel Table's filter function comes in handy:

1. Click the filter arrow in your "Codes" column heading.
2. Use the "Text Filters" > "Contains…" option.
3. Type in a keyword from one of your codes (e.g., "checkout").

This will show you all the responses that mention the checkout process. By reviewing them together, you can see the overarching story. As you identify themes, start filling in the "Theme" column. A single row could relate to multiple themes.

Phase 4: Review and Refine Your Themes

Now, take a step back and look at your list of potential themes. Ask yourself a few critical questions:

• Do these themes accurately represent the data?
• Are there themes that overlap too much and should be merged? (e.g., "Usability" and "Navigation" might be combined).
• Is there a large, complex theme that needs to be broken down into sub-themes? (e.g., "Customer Support" could be split into "Support Wait Times" and "Support Helpfulness").

This is an iterative process. Feel free to rename, merge, split, or discard themes until you have a set that feels distinct, comprehensive, and meaningful.

Phase 5: Define and Name Your Final Themes

With a refined set of themes, it's time to formalize them. In your "Codebook" tab, finalize the names of your themes and write a clear, concise definition for each one. This helps solidify your understanding and makes it easier to communicate your findings to others.

For example:

• Theme Name: Positive Performance
• Definition: Encompasses all mentions related to the speed, responsiveness, and lack of bugs or crashing within the application.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Visualizing and Reporting Your Findings with PivotTables

You’ve done the hard work of coding and theming. Now it's time for the payoff: turning your analysis into easy-to-understand insights. Excel's PivotTables are your best friend here.

A PivotTable can quickly summarize your data, helping you quantify your themes. For example, you can instantly see how many times each theme was mentioned.

How to Create a Simple Theme Frequency Chart:

1. Click anywhere inside your main data table.
2. Go to the Insert tab and click PivotTable. Excel will automatically select your table range. Click OK. Excel will create the PivotTable in a new sheet.
3. In the "PivotTable Fields" pane on the right:

Voilá! You now have a table that shows a count for each theme. To make it even clearer, click inside your new PivotTable, go to the Insert tab, and choose a bar chart or column chart to visualize the theme frequency. This provides a powerful, at-a-glance view of what matters most to your audience.

Final Thoughts

Conducting a thematic analysis in Excel transforms messy qualitative data into clear, structured insights that can drive decision-making. By following a structured setup and systematically coding your data, you can uncover powerful patterns using a familiar tool, without needing to learn complex new software.

Of course, as your analysis needs grow, managing data from multiple marketing and sales platforms in spreadsheets becomes tedious. That’s why we built Graphed — to eliminate the manual drudgery of data reporting. We help you connect all your data sources in one place and use simple, natural language to build real-time dashboards and get answers in seconds, giving you back the time to focus on strategy, not spreadsheets.