Pinterest Stumbleupon Whatsapp
Ads by Google

Are you tired of having to manually collect and consolidate data, from various people, into your Excel spreadsheet? If so, chances are you have yet to discover Excel Survey.

Microsoft introduced Excel Survey a few years ago along with Office Online Don't Pay For Word! 5 Reasons You Should Use Office Online Don't Pay For Word! 5 Reasons You Should Use Office Online Office Online is the free and cloud-connected version of Microsoft Office. Limitations are compensated by features, useful even to users of desktop Office. Best of all is its Read More . However, you may not have noticed it if you haven’t ventured outside of the desktop version of Office. The survey feature is only available in the online version, which makes sense considering you will need your survey to be available to users via the Internet.

What Is an Excel Survey?

An Excel Survey is a Web form, that you design to collect and store structured data, into an Excel spreadsheet. You have many options when it comes to Web surveys or forms. Alternatives such as Google Forms 5 Awesome Reasons To Use Google Forms 5 Awesome Reasons To Use Google Forms If you've ever tried to make an online survey, you've probably tried a few tools here and there. You've no doubt enjoyed some features of one product, and some of another, while being frustrated at... Read More and SurveyMonkey Make Free Professional Online Surveys With Survey Monkey Make Free Professional Online Surveys With Survey Monkey Read More  may have more robust features, but when you have a need for collecting simple datasets from several people, this tool will do the job seamlessly in the Microsoft ecosystem.

Create an Excel Survey

If you don’t already have a personal or business Microsoft Online account The Pros and Cons of Using a Microsoft Account with Windows The Pros and Cons of Using a Microsoft Account with Windows A single Microsoft Account allows you to log into a wide range of Microsoft services and apps. We show you the pros and cons of using a Microsoft Account with Windows. Read More , you will need to create one in order to log into OneDrive. From there you have two ways to create a survey:

1. Create a New Survey from OneDrive

From the menu, select New > Excel Survey

newSurvey

Ads by Google

 

2. Add a Survey to an Existing Excel Spreadsheet

From within an existing Excel Online spreadsheet, select Home > Survey > New Survey

newSurvey2

Design Your Survey Form

You will want to give your survey a good title and description, so your responders will understand quickly why they are being asked to provide data. Next, you will add a question for each piece of information you will require.

Questions from your survey will correspond to columns in your spreadsheet, and each response will be represented as a row.

Excel Survey Design

Explore Your Options

It’s important to  be clear how you will want to use the results before setting up the question types. If you have data that you will need to sort or filter, you most likely should use a “choice” field in order to control the input. A “text” field should be used for dynamic information that cannot be predefined, such as a person’s name.

surveyDesign2

Look through the available types of fields and select the best one for each column. Then decide if you want the question to be required or optional, and if you want a default value to be displayed automatically on the form.

  • Text – A short text field.
  • Paragraph Text – A long text field.
  • Number – Numerical data.
  • Date – Date values.
  • Time – Time values.
  • Yes/No – Dropdown box that only allows a “Yes” or “No” choice.
  • Choice – Dropdown box with choices defined by you.

Know the Limitations

As you can see, Excel Survey is a very basic tool that will likely get the job done for a majority of situations. However, it has some limitations to take into consideration. If any of these are a deal breaker, then you might want to look at some alternative solutions The Finest 14 Google Forms Alternatives You Should Try The Finest 14 Google Forms Alternatives You Should Try There's a world outside of Google and some pretty great Google Forms alternatives. Find out if these web apps and tools are as effective for you as Google Forms is. Read More .

  1. Anonymous Access – You have no way to require a login or limit the access to a survey once it’s shared. If you have the link, you can submit a response.
  2. Branching aka Skip Logic – What you see is what you get. You cannot present different information to user based on the answers they provide to a question.
  3. Input Validation – You cannot validate data that is entered into the form outside of using one of the “choice” field types.

Preview Your Survey

Now that you have completed the design, you should preview your work to see how it will display when you send it. To do this, select the Save and View button on the bottom of the form.

surveyPreview

This is what your survey recipients will see when you share the link with them:

surveyPreview2

 

Share Your Survey

Once you are happy with how everything looks, it’s time to share! Click the Share Survey button and you will be presented with a link that you can send to your target audience.

surveyShare

You have the option to shorten the link. This is optional, but if you want to do this, just click on Shorten link.

surveyLink

View Your Responses

After your survey link has been sent, you can start monitoring your spreadsheet for responses and analyzing the results How to Use an Excel Pivot Table for Data Analysis How to Use an Excel Pivot Table for Data Analysis The pivot table is one of the single most powerful tools in the Excel 2013 repertoire. It is frequently used for large data analysis. Follow our step-by-step demonstration to learn all about it. Read More . The data will be stored in the spreadsheet that the survey is linked to.

surveyResults

The survey in this example is gathering data to help plan an office party, but the possibilities for how you can use it are endless. You could create a survey to have your team track their time on a particular project, gather feedback on performance, or even to have your family help decide on the location of your next reunion!

Have you used Excel Survey before? What creative uses do you have for this tool? Please share in the comments.

Image Credits:Market Research Survey by Pixsooz via Shutterstock

Leave a Reply

Your email address will not be published. Required fields are marked *