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)

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)

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

2. Go to Excel

3. Start a New blank workbook

4. Let’s rename the filename to ExcelOnlineSurvey

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

5. Home tab –> Survey –> New Survey

5.1 This is where we start to create our survey

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

Question: Highly recommend you use short but meaningful description here as this will become the column header of your resulting table

Question Subtitle: Here you may enter a longer qualitative question that is meaningful to your respondents