How to Analyze Google Forms Responses in Excel

You’ve sent out a Google Form, and the responses are pouring in. That’s the easy part. The real challenge is turning that pile of raw data into something you can actually use. Making sense of dozens or hundreds of form responses can feel overwhelming, but Excel has the tools you need to slice, dice, and visualize your data to find meaningful insights. This guide will walk you through how to export your Google Forms data and analyze it in Excel, step by step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Getting Your Data from Google Forms into Excel

First things first, you need to get your form responses out of Google's ecosystem and into an Excel file. This is a straightforward two-step process.

Step 1: Link Your Form to a Google Sheet

If you haven't already, your first move is to connect your Google Form to a Google Sheet. This creates a live spreadsheet where every new form submission appears as a new row automatically.

• Open your Google Form and go to the "Responses" tab.
• Click the green spreadsheet icon labeled "Link to Sheets."
• You'll be prompted to either create a new spreadsheet or link to an existing one. For a clean start, choose "Create a new spreadsheet."

Google will automatically open a new tab with your linked Google Sheet. You'll see a timestamp column followed by columns for each of your form questions. All your existing and future responses will now live here.

Step 2: Download Your Google Sheet as an Excel File

Once your responses are in Google Sheets, getting them into Excel is simple. Keep in mind that doing this creates a static snapshot of your data. If you get more form responses later, you’ll need to download a new file to include them in your analysis.

• In your Google Sheet, click on File in the top menu.
• Hover over Download.
• Select Microsoft Excel (.xlsx) from the dropdown menu.

Your browser will download the file, and you can now open your Google Forms data in Excel.

The Essential First Step: Cleaning and Preparing Your Data

Before you start analyzing anything, you need to clean up your data. This is the single most important step for getting accurate results. Raw data exported from any tool is rarely perfect, and spending a few minutes tidying it up will save you hours of headaches later.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Remove Duplicate Submissions

Sometimes users might accidentally submit a form twice. These duplicates can skew your results.

• Select all of your data by clicking on the top-left corner of the sheet (or pressing Ctrl+A).
• Go to the Data tab and click Remove Duplicates.
• A dialog box will appear. Check "My data has headers" if it isn't already selected, and then select all the columns. Clicking OK will remove any rows that are perfect duplicates across all fields.

Standardize Your Text Responses

This is crucial for questions where users can type in their own answers. For example, if you ask for a user's country, you might get responses like "USA," "U.S.," "United States," and "America." To Excel, these are all different values.

The simplest way to fix this is with Find and Replace.

• Select the column you want to clean up.
• Press Ctrl+H (or go to Home > Find & Select > Replace).
• In the "Find what" box, type the variant you want to change (e.g., "U.S.").
• In the "Replace with" box, type the standardized term you want to use (e.g., "United States").
• Click Replace All. Repeat this for all variations until the column is clean.

Check for Blanks and Errors

Scroll through your data to look for any blank cells where there shouldn't be any. How you handle these depends on the context. Sometimes a blank means zero, and other times it means the user skipped the question. Decide on a consistent rule and apply it to your dataset.

Format Your Data Correctly

Make sure Excel is treating your data types correctly. A column of numbers shouldn't be formatted as text, and dates should be formatted as dates. Select a column, right-click, choose Format Cells, and pick the appropriate category (Number, Date, etc.). This ensures calculations and sorting will work as expected.

Core Analysis Techniques for Google Forms Data

With your data clean and tidy, you can start digging for insights. Let’s start with some of the most common and useful functions.

Summarizing Categorical Data with COUNTIF

The COUNTIF function is perfect for tallying responses to multiple-choice questions. Let's say you asked, "Which social media platform do you use most?" with options for Twitter, Instagram, and Facebook.

• Create a small summary table off to the side with your options listed.
• In the cell next to "Twitter," type the following formula. Let’s assume your responses are in column C, from row 2 to row 101:

=COUNTIF(C2:C101, "Twitter")

This formula counts how many times the exact text "Twitter" appears in column C. Drag this formula down for Instagram and Facebook (making sure to edit the criteria text for each), and you’ll have a quick summary of your most popular platforms.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Analyzing Numeric Data with Basic Functions

If you have questions with numerical answers, like a rating scale ("On a scale of 1-10, how satisfied are you?") or a question about age, you can use basic math functions to understand them better.

Let's assume your satisfaction scores are in column D. You can quickly find key statistics:

• Average Score:

=AVERAGE(D2:D101)

• Highest Score:

=MAX(D2:D101)

• Lowest Score:

=MIN(D2:D101)

Sorting and Filtering for Quick Insights

Don't overlook the power of sorting and filtering. This is one of the fastest ways to explore your data without writing a single formula.

• Select your header row.
• Go to the Data tab and click Filter.
• Dropdown arrows will appear on each of your column headers.

Now, you can click the arrow on any column to sort it A-Z or filter to see only specific responses. For instance, you could filter to see only the responses from users in a particular country, or only see the feedback from people who gave you a satisfaction score of 9 or 10.

Level Up Your Analysis with PivotTables

When you want to cross-reference data and answer more complex questions, it's time to bring in Excel's most powerful tool: the PivotTable. A PivotTable lets you quickly summarize large amounts of data by dragging and dropping fields.

Creating Your First PivotTable

• Click anywhere inside your cleaned data range.
• Go to the Insert tab and click PivotTable.
• Excel will automatically select your data range. Just click OK to create the PivotTable in a new worksheet.

Understanding the PivotTable Fields Pane

You’ll see a pane on the right side of the screen with a list of all your columns (or "fields"). Below that are four boxes that are the heart of a PivotTable:

• Rows: Fields you drag here will appear as rows down the left side of your table. (Example: Drag "Country" here to list each unique country).
• Columns: Fields you drag here will create columns across the top of your table. (Example: Drag "Gender" here to create a column for Male and Female).
• Values: This is where you put the field you want to calculate. It’s typically a numeric field to be summed or averaged, or a text field to be counted. (Example: Drag a "Participant ID" field here and it will default to "Count of Participant ID" to show you the number of responses).
• Filters: This lets you apply a filter to your entire table. (Example: Drag "Date Submitted" here to filter the report for only a specific month).

By dragging different fields into these boxes, you can answer questions like, "How many responses did we get from each country?" or "What is the average satisfaction score broken down by age group?" without touching any formulas.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Bringing Your Data to Life with Charts and Graphs

Numbers in a table are great, but a chart can make trends and comparisons instantly obvious.

Creating Basic Charts

You can create a chart from your raw data table or from a summary table (like the one you made with COUNTIF).

• Highlight the data you want to visualize. For a pie chart, just highlight your summary table of social media platforms and their counts.
• Go to the Insert tab and choose a chart type from the "Charts" section.

A few general guidelines:

• Bar/Column Charts: Best for comparing counts across different categories (e.g., number of users from each country).
• Pie Charts: Good for showing parts of a whole (e.g., percentage of users on each social media platform). Use them sparingly, and never for more than 5-6 categories.
• Line Charts: Ideal for showing a trend over time (e.g., number of form submissions per day).

Visualizing with PivotCharts

One of the best features of PivotTables is that they can be instantly turned into a chart. Click anywhere inside your PivotTable, go to the PivotTable Analyze tab, and click PivotChart. Your chart will be directly linked to the PivotTable. If you change a field or filter in your table, the chart will update automatically, making it a fantastic tool for dynamic data exploration.

Final Thoughts

Analyzing Google Forms responses in Excel transforms your collected data from a simple list into a powerful decision-making asset. By cleaning your data, applying functions like COUNTIF, and using tools like PivotTables, you can uncover key insights that might otherwise stay hidden. It takes a bit of practice, but these skills allow you to understand feedback, spot trends, and make smarter, data-informed choices.

That manual process of downloading CSVs, cleaning data in spreadsheets, and building reports is exactly what we wanted to automate for marketers, founders, and agencies. We built Graphed because we believe getting insights shouldn't require so many tedious steps. Instead of exporting data, you can connect your Google Sheets directly to our platform, along with other tools like Google Analytics or your CRM. From there, you just ask questions in plain English—like "Show me a pie chart of my form responses by country"—and dashboards and charts are instantly created and always kept up-to-date.