Skypoint Logo - AI platform for industries
Close this search box.

Free Public Surveys with SkyDrive

Stay up to date with the latest customer data news, expert guidance, and resources.

The Survey

The Dashboard


Have you ever wanted to easily collect some data but didn’t want to bother learning new tools? Then today’s blog post is for you! Recently I discovered a cool feature of SkyDrive that I am very excited about. You now have the ability to generate a public URL that will take users to a form they can fill out without logging in. Once they submit their answers, their responses will automatically be inserted into your Excel document in SkyDrive. How neat is that?!

The Discovery

A few weeks ago some friends of mine introduced me to bowling. I’d bowled before, who hasn’t? But I admit I still wished it was socially acceptable for adults to use bumpers. That’s how bad I was. Until my friends took me and my wife out and gave us some simple coaching. We were quickly able to increase our average scores, which quadrupled the fun factor (by my early estimates).

I wanted an easy way for us to keep track of our scores over time to see how we are improving. Enter SkyDrive. Within 20 minutes of discovering this new feature, I had a fully functional bowling score tracker. However, in this post I’ll be creating a new survey that’s specific to Christmas.

Creating a Survey

If you don’t have a Microsoft account (aka Live ID), go ahead and sign up for one along with a free SkyDrive account over at

Browse to a folder where you want to create your new Excel file. Click Create > Excel workbook and give your new file a name.

Create the survey by clicking Survey > New Survey

Create the survey questions, it’s pretty self-explanatory.

Click the Save and View button to make sure it behaves correctly.

Then click the Share Survey button to create a public URL that you can send to whomever!

When someone fills out your survey, it will automatically be inserted as another row in a table on a sheet called Survey1.

I must say, nicely done Microsoft… Nicely done.

Share This:

More Resources


Your Unified Data, Analytics & AI Partner

Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.