Excel Web Survey vs Google Form

Which number formats are most popular in pivot tables? I have my guess, but wanted to see what other people thought.

So, I decided to create a survey in SkyDrive, using the new survey builder feature. Well, it’s new to me – I can’t remember how long it’s been available. Things didn’t go well, but the survey is included at the end of this article.

Build the SkyDrive Survey

I logged into Skydrive, and found the commands to build the survey. You can start one from the main panel, which is handy.

skydrivesurvey

Or, start a survey from the Excel Web app.

skydrivesurvey03

It was easy to create the questions – the survey builder has a clean layout, with the question setup opening at the side.

skydrivesurvey02

In a few minutes, my survey was ready to share.

Share the Survey

There was a button to create a link to the survey, so I entered that in Firefox, to test the survey.

skydrivesurvey01

It worked well, but the results aren’t date stamped, and there’s no built in charting of the results. Half the fun of taking a survey is in clicking that button, to see how other people have responded.

Also, I couldn’t see a way to create embed code, to put the survey on a blog. There might be a way to do that, but it’s not obvious to me.

So, that SkyDrive survey attempt was a disappointment!

Back to Google Docs

I headed over to Google, where I had created surveys before, and built the same survey in a couple of minutes.

To the Excel Web Survey’s credit, I did find it slightly easy to follow the flow of setting up the survey, and making edits to the questions.

Share the Google Survey

After building the survey, you can create a link, or get the code to embed it in a website. So, I followed the link, and filled in a survey, to make sure it was working correctly.

When you complete the survey, you’re offered the chance to see the results. Nice!

googlesurvey02

And, back in Google Docs, I can see the survey results, and each record has a date/time stamp.

googlesurvey01

I hope they add these features to the Excel Web survey tool soon, because they are deal breakers for me!

Please Take the Number Format Survey

Anyway, here is the completed survey form, so please answer the 3 questions to help me see which number formats are most often used in pivot tables. Thanks!

And here is the link, in case you can’t see the embedded form below.

______________

One thought on “Excel Web Survey vs Google Form”

  1. These are great tips. I started using these drives in the cloud last week. I subscribed to Google Drive, Sky Drive, Amazon Cloud Drive, DropBox and Smartsheet at the same time. This is funny to see where tech is going. Amazing things can be done using these features.
    I did not know about the survey form from SkyDrive. This is excellent!

    Thank you Debra.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.