#Excel Online Survey… Never heard about that!?

How to create an online survey with #Excel?

Did you know that we can conduct online survey by using Excel?  Yes, you heard me right.  I said: Excel!  I am not talking about setting up questionnaire in Excel and then send the Excel file to respondents.  Of course we can do that, but are you sure you want to do the consolidation afterwards.  I do not for sure!

What I am talking about is to create an online survey and then send a link to respondents to collect their responses.  (Access to internet is, of course, required)

Excel Tips - Online Survey7

And the cool thing is… all the responses submitted will be loaded into an Excel table stored in your One Drive.  You can imagine how many hours could be saved from consolidating the responses.  😛

So, how to create an online survey in Excel? 

1. Sign in your Microsoft account (e.g. Hotmail)

Excel Tips - Online Survey0.PNG

Note: Create one if you don’t have one yet.

2. Go to Excel

Excel Tips - Online Survey

3. Start a New blank workbook

Excel Tips - Online Survey1

4. Let’s rename the filename to ExcelOnlineSurvey

(Optional but always a good practice to name your file)

Excel Tips - Online Survey2

5. Home tab –> Survey –> New Survey

Excel Tips - Online Survey3

5.1  This is where we start to create our survey

Excel Tips - Online Survey4

5.2 Continue edit the survey by inputting title and description

(although this is optional, I recommend you do input something meaningful to you and your respondents)

5.3 Enter questions

Excel Tips - Online Survey5

  1. Question: Highly recommend you use short but meaningful description here as this will become the column header of your resulting table
  2. Question Subtitle: Here you may enter a longer qualitative question that is meaningful to your respondents
  3. Response Type: Text, Paragraph text, Number, Date, Time, Yes/No, Choice.  This is indeed quite straight forward.  See demo below for different types.  Excel Tips - Online Survey
  4. Required: If this box is checked, it means that respondent cannot leave it blank in order to submit the survey successfully.
  5. Default answer: Optional

5.4 Add New Question and repeat step 5.3 above

See below for demonstration:

Excel Tips - Online Survey1

5.5 When finished, click Save and View

This is the moment to check your questions and answer options.

Excel Tips - Online Survey6

I’d checked the “required” box for the second question.  That’s why I cannot leave it blank…

Excel Tips - Online Survey8

Let’s see what is happening when I submitted an answered survey:

Excel Tips - Online Survey2

WOW…. did you see?  The responses were captured instantly:

Excel Tips - Online Survey9

Tip: See the column headers?  These are what we input in “Question” and that’s why I recommended to use short terms.

6.  Let’s share the survey

Excel Tips - Online Survey10

Note: you may continue edit the survey if needed

7. Copy the link and send it to respondents for input

Excel Tips - Online Survey11

Note: You may “Stop sharing this survey” any time by clicking that… 🙂

8. To view/edit the responses, go back to Online Excel and open the corresponding file

Excel Tips - Online Survey12

(Note: You won’t find the “SAVE” command in Excel Online as it is always saved.) 

Yeah!  As simple as this.  🙂

Let’s create your own online survey using Excel next time.

Use cases discussion

When there are so many online survey providers on the Internet, why do we still use Excel Online to conduct survey?  Please share your views in comments.

Advertisements
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s