Skip to main content

Excel Surveys

This post is brought to you by Harrison Gordon, a PM on the Excel Services team.

I love making music. It’s one of my passions, and it’s a passion I know many of my friends share as well. The problem is that it can be challenging to schedule time and get us all together, and what’s worse is I don’t know what instruments everyone plays.

In the past, we’d have long email threads, complicated scheduling tactics, and a lot of headaches. Using Excel surveys, I can easily collect everyone’s info and figure out exactly how to plan out our next jam session.

Creating a survey in SkyDrive

I log into my SkyDrive and click “Create -> Excel survey”:

Create Excel Survey
 
SkyDrive asks me to name my survey, and drops me into the survey designer in Web Excel:

The survey designer in Web Excel


 
The survey designer is a breeze to work with. I can add questions, change the type (text, multiple choice, date, etc), and move them around. I can also show a default answer or make it so a question is required before sending a response to the survey.

The survey designer is a breeze to work with

Once it’s ready, I just click “Share Survey”. I will get a link that I can then email to my friends:

Get a link that you can use to email friends
 
When they click on the link, they don’t have to sign in – they just go straight to my survey:

Filling out the survey
 
Getting Results

Now comes the best part – when you create a survey in Web Excel, we automatically generate a table to store all of your results. Here’s what it looks like:

A table to store all of your results
 
As my friends fill out the survey, I can watch the results show up in real time in Web Excel:

Results start appearing in Excel
 
Once everyone has responded, I can quickly make sense of the data. From the table above, I can already tell that 12/1 is going to be the best day to get everyone together. For further analysis, I can use the full power of Excel to learn more about the responses. A handy feature is “Recommended Charts” (find it under the Insert tab). It will recommend useful visualizations of your data.


 
 I’m a bit of a data nerd, so I went ahead and made a few more charts to get a better understanding of the data:

Understanding the data
 
Now I can see that we have a few guitar players amongst my friends! Perfect, one can play lead and the other can play rhythm. I can also see that 12/1 works for most people, so I can go ahead and send an invite to everyone for 12/1.

How else can I use Surveys?

The possibilities are endless, but here’s a small list of things you can do with Excel surveys:

  1. Plan out when your friends are free for a vacation (or if they’re free to just grab food downtown).
  2. Quickly poll your coworkers about who they want to win the Super Bowl (and don’t invite the ones rooting for the other team to your party).
  3. Help arrange ride sharing so you can take advantage of carpool lanes (and save the environment, of course).

To recap:

  1. Create surveys directly in Web Excel, with results stored inside a table in the workbook.
  2. Share your survey with anyone – no Microsoft Account required.
  3. Your surveys will always look sleek, modern, and professional.
  4. See survey responses added to the workbook in real time.
  5. Use the full power of Excel on the desktop to analyze and chart your new data once it’s all there.

Let us know what you think!

We’ve only just scratched the surface with what our new survey feature can do, and we’d love to hear what you think!
And while you’re at it – care to fill out my survey? Let me know what you thought of this post and Excel surveys!

Harrison Gordon
Program Manager, Excel Services

You may also like these articles

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…

Image for: A woman sitting on a couch using her PC laptop.

Introducing Money in Excel, an easier way to manage your finances

Today, with the launch of Money in Excel, we are embarking on a journey to simplify your day-to-day money decisions to help you stay on track of your longer-term financial goals.