Create Surveys with Excel Online hosted in Office365

excel-icon-lgYou can quickly create surveys with Excel and make them available online with all results saved in the spreadsheet hosted in Office365. Just create an Excel spreadsheet in Office365 and choose the Survey item on the ribbon to design it.

A link is provided to share with people to respond. They don’t need to have Excel or Office365. Just a web browser. Try our sample by clicking the image below:

survey

Shorten the URL

Excel provides a very long URL to share your survey. By using a site like bit.ly, you can create a shorter one to email to your contacts. This is important to avoid problems when URLs get word wrapped in emails. For instance, this survey is shortened to https://bit.ly/2qmSweG.

Results in Your Spreadsheet

The results go directly into your spreadsheet with each submission as a separate row:

response

Having the ability to create a survey and see the results in a spreadsheet in minutes, is a terrific tool to help your projects!

Leave a Reply

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