Solutions Engineering

Excel Questionnaire Template: How to Build One in Excel

Use this Excel questionnaire template layout and learn how to create a questionnaire in Excel with dropdowns, checkboxes and locked cells. See the steps.
Shrivarshini Somasekhar
RFP Process Insights Lead
Last Updated:
November 16, 2026
Blog Hero Image
AI Summary
  • An Excel questionnaire template is a worksheet with one question per row and fixed columns for ID, section, question, answer, comments and owner.
  • Excel's template gallery has no business or security questionnaire template, so you build the layout yourself.
  • The guide gives a nine-column layout and seven steps: headers, questions, Data Validation dropdowns, checkboxes, conditional formatting and sheet protection.
  • Sheet protection stops accidental edits but is not a security feature, per Microsoft.
  • It also covers tallying responses with COUNTIF and PivotTables, and when Microsoft Forms is a better fit.
  • SiftHub is an AI RFP software that drafts answers inside a buyer's Excel questionnaire from your approved content.
  • An Excel questionnaire template is a worksheet with one question per row and fixed columns for ID, section, question, answer, comments and owner.
  • Excel's template gallery has no business or security questionnaire template, so you build the layout yourself.
  • The guide gives a nine-column layout and seven steps: headers, questions, Data Validation dropdowns, checkboxes, conditional formatting and sheet protection.
  • Sheet protection stops accidental edits but is not a security feature, per Microsoft.
  • It also covers tallying responses with COUNTIF and PivotTables, and when Microsoft Forms is a better fit.
  • SiftHub is an AI RFP software that drafts answers inside a buyer's Excel questionnaire from your approved content.

Search for an Excel questionnaire template and you mostly find customer surveys. Rate us from 1 to 5. Would you recommend us?

Business teams need something else. A vendor review, a client intake or a security questionnaire has to collect answers someone can stand behind, plus comments, evidence and an owner. And it has to come back clean.

Yes, you can create a questionnaire in Excel. Excel's template gallery has no business or security questionnaire template, so you build the layout yourself. It takes a few features most people already have: dropdowns, checkboxes and sheet protection.

An Excel questionnaire template is a worksheet with one question per row and fixed columns for the question ID, section, question, answer, comments and owner. You build one with Data Validation dropdowns or checkboxes for answers, then lock the question cells and protect the sheet so people can only edit the answer column.

In this guide:

What is an Excel questionnaire template?

An Excel questionnaire template is a reusable worksheet that holds a fixed set of questions and a structured place for each answer. Teams use one for surveys, client intake forms, vendor reviews and security questionnaires.

There are two very different kinds. A survey template counts opinions. A business questionnaire template collects answers you have to defend later, so it needs room for comments, evidence and the name of the person who answered. Most free templates online are the first kind. This guide builds the second.

Can you create a questionnaire in Excel?

Yes. Excel gives you a grid for questions, Data Validation for fixed answers and sheet protection to stop people changing the questions. That covers most business questionnaires.

Excel fits when you need to sort, filter, score or hand sections to different people. Microsoft Forms fits better when you want a simple form for many respondents and are happy to see the answers in a workbook afterward. More on that choice below.

What columns should an Excel questionnaire template have?

Here is the questionnaire template Excel layout we recommend. Use it as your template: copy the headers into row 1 of a blank sheet.

ColumnWhat goes in itAnswer type
Question IDAC-01, AC-02, DP-01Fixed, formatted as Text
SectionAccess control, Data privacyFixed
QuestionOne question per rowFixed, locked
AnswerYes, No, Partial, N/ADropdown
CommentsContext or exceptionsFree text
EvidenceLink to a policy or reportHYPERLINK formula
OwnerWho answeredDropdown of names
StatusOpen, In review, DoneDropdown plus color
Last reviewedDateDate validation

A few rules make this layout work:

  • One question per row. Never put two or three questions in one cell. Whoever answers will skip one, and whoever reads the answers will not know which part was answered.
  • Always pair a dropdown with a comments column. A Yes/No/Partial cell with nowhere to explain is a frequent complaint from people who answer questionnaires.
  • Keep the section in a column, not in merged header rows. Merged cells break sorting later.
  • Use HYPERLINK for evidence. =HYPERLINK(link_location, "SOC 2 report") shows a readable label instead of a long URL.

Excel has plenty of room. A cell holds up to 32,767 characters, and a sheet can hold up to 65,530 hyperlinks.

What does a security questionnaire template in Excel look like?

A security questionnaire uses the same layout with one more column: a framework mapping, such as the SOC 2 criterion or ISO 27001 control each question supports.

Many standard security questionnaires ship as workbooks, and they are useful security questionnaire examples to study:

  • SIG. Shared Assessments says the SIG Manager is built in Excel, and the Lite and Core versions use a single-worksheet, password-protected structure. The SIG is licensed, and Shared Assessments says its web version, SIG EV, is the long-term primary method. Our SIG questionnaire guide covers it.
  • CAIQ. The Cloud Security Alliance's CAIQ is a spreadsheet of yes or no questions mapped to its Cloud Controls Matrix. CCM v4.1, released in January 2026, includes CAIQ v4.1. See our CAIQ questionnaire guide.
  • HECVAT. EDUCAUSE's HECVAT 4.1.6 is one multi-tab file with a Start Here tab.

For a full question set to start from, see our vendor security assessment questionnaire template. For the topics most buyers cover, see our information security questionnaire guide.

How do you create a questionnaire in Excel, step by step?

Here is how to create a questionnaire in Excel in seven steps, with no macros. The steps are the same if you want to know how to create a questionnaire survey in Excel, or how to make a questionnaire in Excel for a vendor review.

Step 1: Set up the sheet and headers

Type the column headers from the layout above into row 1. Choose View, then Freeze Panes, then Freeze Top Row, so headers stay visible as people scroll.

Select your headers and data and press Ctrl+T to format it as a table. Tables make filtering and formulas easier. Set wide columns for Question and Comments and turn on Wrap Text so long text stays readable.

Step 2: Write the questions

Put one question in each row. Give each one a short ID, such as AC-01 for the first access control question. If you prefer numbers like 1.10, format the column as Text first, or Excel will show 1.1. Type the section name in the Section column on every row, rather than in a merged heading.

Write each question so it can be answered with the answer type you choose. "Do you encrypt data at rest?" works with Yes/No. "How often do you run backups?" needs free text or a dropdown of frequencies.

Step 3: Add dropdown answers with Data Validation

Dropdowns keep answers consistent. To add one:

  1. Select the Answer column cells.
  2. Go to Data, then Data Validation.
  3. Under Allow, choose List.
  4. In Source, type Yes,No,Partial,N/A, or point to a range.

For lists you reuse, such as owner names or status values, put them on a separate Lists tab and point the Source to that range or a named range. You can hide that tab once it is set up.

Data Validation also has an Input Message tab, which shows a hint when someone selects the cell, and an Error Alert tab, which controls what happens when someone types a value that is not on the list.

Building in Google Sheets instead? Use Insert, then Dropdown, or Data, then Data validation. You can choose to reject or warn on values that are not on the list.

Step 4: Add checkboxes where a tick is enough

Some questions only need a tick, such as "I have read the policy" or a list of controls that apply. In Excel for Microsoft 365, select the cells and choose Insert, then Checkbox. A checked box is TRUE and an unchecked box is FALSE, so formulas can count them. Press the spacebar to toggle a box.

On Excel 2016 to 2024 without a subscription, use the Developer tab, then Insert, then a Form Controls check box linked to a cell.

Our rule of thumb: use a checkbox when the only answers are yes and not yet. Use a dropdown when "Partial" or "N/A" is a real answer.

Step 5: Add follow-up logic and color

Make "No" and "Partial" answers stand out. Select the Answer column and choose Home, then Conditional Formatting, then Highlight Cells Rules, then Text That Contains. Pick a color for each value.

Then add a helper column that flags rows that need an explanation. If the answer is in column D and comments are in column E, this formula in a new column shows a prompt until someone explains a "No":

=IF(AND(D2="No",E2=""),"Explain required","")

You get simple follow-up logic without macros.

Step 6: Lock the questions and protect the sheet

In Excel, all cells are locked by default, but locking does nothing until you protect the sheet. So:

  1. Select the cells people should fill in: Answer, Comments, Evidence, Owner, Status and Last reviewed.
  2. Press Ctrl+1, open the Protection tab and clear Locked.
  3. Go to Review, then Protect Sheet. Choose what people may do, such as select unlocked cells. A password is optional.

Do two things before you protect. Add all the rows you need, because a table cannot grow while the sheet is protected. And sort the questions the way you want them, because sorting does not work on ranges with locked cells.

If different teams own different sections, set up Review, then Allow Edit Ranges, before you protect the sheet. It unlocks ranges with a range password, or for named people on domain-joined Windows computers.

One caveat from Microsoft: "Worksheet level protection isn't intended as a security feature." It stops accidental edits, not a determined user. If you forget the password, Microsoft cannot recover it.

Step 7: Share it and collect answers

To let several people answer at once, save the file to OneDrive or SharePoint Online with AutoSave on. Co-authoring needs Microsoft 365 and an .xlsx, .xlsm or .xlsb file. It does not work on SharePoint on-premises.

Avoid the legacy Shared Workbook feature. Microsoft calls it "an older feature" replaced by co-authoring, and it does not support tables, conditional formatting, data validation or sheet protection.

For reviewer notes, use threaded comments rather than notes. Threaded comments take replies and can be marked resolved, so you can see which questions still need a decision.

How do you tally and score questionnaire responses in Excel?

Once answers are in, a few formulas give you a summary. These examples assume the table runs from row 2 to row 101, with answers in column D and status in column H.

  • Count each answer: =COUNTIF(D2:D101,"Yes"). Repeat for No, Partial and N/A.
  • Percent complete: =COUNTIF(H2:H101,"Done")/COUNTA(C2:C101), formatted as a percentage.
  • Simple score: give Yes 1 point, Partial 0.5 and No 0, then =(COUNTIF(D2:D101,"Yes")+0.5*COUNTIF(D2:D101,"Partial"))/(COUNTA(D2:D101)-COUNTIF(D2:D101,"N/A")). Blank answers are left out, so read the score next to percent complete.
  • Count checkboxes: if you add a checkbox column, say column J, =COUNTIF(J2:J101,TRUE) counts ticked boxes, since a checked box is TRUE.

For a summary by section, insert a PivotTable with Section in rows, Answer in columns and Question ID in values, set to Count. It shows at a glance which sections have the most "No" answers.

Should you use Excel or Microsoft Forms for a questionnaire?

Both work. They suit different jobs.

Excel workbookMicrosoft Forms
Works offlineYes, in the desktop appNo, needs a browser
Comments and evidence columnsYes, any layoutText questions; file upload has limits for outside respondents
Layout controlFullFixed form layout
Respondent experienceA spreadsheetA simple web form
Where answers landIn the same fileIn a workbook via Open in Excel
Best forReviews, vendor and security questionnaires, sections with ownersSurveys and intake forms with many respondents

Forms offers question types such as Choice, Text, Rating, Date, Ranking, Likert, file upload and Net Promoter Score, and lets you group questions into sections. Responses open in Excel through Open in Excel, and the data keeps syncing. Recent versions of Excel for Microsoft 365 can also create a linked form from inside a workbook.

If you need an Excel survey template for a quick poll, Forms is usually faster. If the answers need evidence, owners and review, stay in Excel.

What goes wrong with Excel questionnaires?

The same problems come up again and again.

  • Pasting over dropdowns. Pasting into a cell replaces its validation, and Excel has no setting to block it without code. One user on Microsoft's community forum described people who "overwrite the drop down list by copy pasting the data." Tell respondents to type or pick from the list, and check answers before you rely on them.
  • Protection that blocks honest answers. Tim Callan, co-host of Sectigo's Root Causes podcast, listed the classics: "The field is locked, and you can't put things in it," and dropdowns that are simply wrong for the question. Test the file by answering it yourself.
  • No place to explain. The same podcast described "other/explain and there's no explain." Add the comments column.
  • Macros. Macros make respondents enable content and trigger security warnings. The steps above need none.
  • Merged cells and hidden rows. Merged cells break sorting, and hidden follow-up rows confuse anyone who imports the file.
  • Version sprawl. Emailed copies drift apart, and merging them back is painful. Keep one shared file with co-authoring.

What if you are answering an Excel questionnaire, not building one?

Many teams meet Excel questionnaires from the other side. A buyer sends its own workbook and wants it back completed, in the same format.

Each buyer's file is different. One buyer asks about access control in a single question, and the next splits it into ten. Volume adds up too. SecurityPal, drawing on the security reviews it handles, says the average security questionnaire now has nearly 100 questions. Whistic's 2025 survey put the average vendor at 37.3 assessment requests a month. Both are vendor data.

The usual workaround is an answer book and copy-paste. It works until different people answer the same question in different ways. For a better process, see how to respond to a security questionnaire and how to reuse security questionnaire responses. If you also build comparison sheets for vendor selection, our RFP comparison template in Excel uses a similar layout.

How does SiftHub help with Excel questionnaires?

SiftHub is an AI RFP software that automates RFP, RFI, DDQ, and security questionnaire responses for B2B SaaS presales, solutions engineering, and bid teams.

When a buyer sends an Excel questionnaire, SiftHub drafts answers inside their workbook from your approved content. SiftHub auto-fills 80% of answers on the first pass, and your team reviews the rest. Read more about security questionnaire automation.

See how SiftHub fills a buyer's Excel questionnaire from your approved answers.

Frequently Asked Questions

Does Excel have a built-in questionnaire template?
Microsoft's Excel template gallery does not include a business questionnaire template. You can build one with the column layout in this guide, or use Microsoft Forms if you only need simple survey answers that sync to a workbook.
Can you create a questionnaire in Excel?
Yes. Put one question per row, add Data Validation dropdowns or checkboxes for answers, add a comments column, then lock the question cells and protect the sheet. You do not need macros.
Is Excel or Word better for a questionnaire?
Word works for a form people read and fill in once, like a printed intake form. Excel is better when you need to sort, filter, score and track answers, or when many people answer different sections of the same questionnaire.
How do I stop people editing the questions in Excel?
Unlock the answer cells first with Format Cells, then Protection, and clear Locked. Then go to Review and choose Protect Sheet. People can only edit the unlocked answer cells. Microsoft notes that sheet protection is not a security feature.
Can I add checkboxes to an Excel questionnaire?
Yes. In Excel for Microsoft 365, select the cells and choose Insert, then Checkbox. A checked box is TRUE and an unchecked box is FALSE, so formulas can count them. In Excel 2016 to 2024, use a Form Controls check box from the Developer tab.
How do I share an Excel questionnaire with several people?
Save the workbook to OneDrive or SharePoint Online and turn on AutoSave. Everyone with a Microsoft 365 subscription can then edit it at the same time. Avoid the old Shared Workbook feature, which does not support data validation or sheet protection.
What format works for a security questionnaire in Excel?
One question per row, with an answer dropdown, a comments column and an evidence column. Add owner, status and last-reviewed columns so the file stays current. Standard questionnaires such as the SIG and CAIQ follow a similar row-based pattern.

Get updates in your inbox

Stay ahead of the curve with everything you need to keep up with the future of sales and AI. Get our latest blogs and insights delivered straight to your inbox.

Respond where your team already works

Close deals 2x faster with AI workflows

Book a Demo