How to use Excel to make a questionnaire

Written by frank luger Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to use Excel to make a questionnaire
For a random sample, hand out your questionnaire to anyone who passes. (Jupiterimages/Goodshoot/Getty Images)

According to research analyst Ian Brace, a questionnaire is a “medium of communication,” between researcher and subjects. A questionnaire allows you to gather data to find patterns and trends. However, the data collected will only be as good as the questionnaire allows it to be. The acronym “GIGO,” meaning garbage in, garbage out, was coined to reflect this.

Skill level:
Moderately Easy

Things you need

  • Word processing application
  • Excel
  • Subjects

Show MoreHide


  1. 1

    Follow Microsoft’s advice and plan your questionnaire, or survey, on paper first. The data collected from a well-designed survey is much easier to interrogate and is therefore more reliable. Think of clear and distinct questions and answers to avoid confusion in your results.

  2. 2

    Use a word processing application to create your question sheet. Add the name of the survey and other details, if you wish, such as your name, today’s date and instructions. Enter your survey questions together with all the possible answers. Number the answers to make it easier to enter your results numerically later.

  3. 3

    Print your sheets and hand them out to people included in the survey. Explain any questions, if necessary, on request. Give people as much time as they need to complete your questionnaire, unless the questionnaire is designed to test the response times of your subjects.

  4. 4

    Run Excel when you have collected all the completed question sheets. In the first row, type field names. These are identifying labels relating to each question, such as: “Colour,” “Type,” and “Number.” In the columns below each field name, enter the numbers that relate to the answers given on your question sheets.

  5. 5

    Select all the cells when you have inputted all the data. Click “Insert” then “Table.” Click “My table has headers.” Click OK. Excel will make a table of the data. Filter or sort the table by clicking the header row arrows.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.