Windows 10: OneDrive - Create an online Excel survey with free Office Online

Discus and support OneDrive - Create an online Excel survey with free Office Online in Windows 10 Tutorials to solve the problem; How to: OneDrive - Create an online Excel survey with free Office Online [img] Information Office Online is a collection of free web based... Discussion in 'Windows 10 Tutorials' started by Brink, Jan 19, 2017.

  1. Brink
    Brink New Member

    OneDrive - Create an online Excel survey with free Office Online


    How to: OneDrive - Create an online Excel survey with free Office Online

    OneDrive - Create an online Excel survey with free Office Online [​IMG]
    Information Office Online is a collection of free web based applications available to all Microsoft email account users (outlook.com, live.com, hotmail.com, msn.com). It offers basic versions of Microsoft's Office suite of desktop applications. Signing in to any Microsoft online service like outlook.com or onedrive.live.com you'll find the web app selection on top left:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]

    All documents you create with Office Online will be saved to OneDrive and can be accessed and worked with from any networked PC or mobile device. Saving to a local computer is not possible but files can be made locally available with OneDrive selective sync (see tutorial). You can download a copy of the survey to local PC but that will not be refreshed when new answers to survey will be submitted.

    Although surveys are created in Office Online, when done and published you can open them with desktop version of Excel if you so prefer.

    An Office Online survey is totally safe, you as a creator can only get the information people taking your survey will give and submit. No IP addresses, names, locations and such are submitted if you don't specifically ask them in survey.

    This tutorial is about online surveys and polls, how to create them using Office Online, OneDrive and Excel Online. More advanced Excel functions and formulas are not covered but feel free to post all your questions in this thread.

    The survey made in this tutorial looks like this when embedded to your website or blog:



    Of course you don't have to post the results; you can for instance simply email the link to survey to your family and friends in front of your birthday party to ask if they come, alone or avec, do they need accommodation, do they want meat / fish / vegan-gluten free-lactose free-save the whales meal, anything.



    Contents:
    Part One: Create a survey / poll
    Part Two: Customize output table
    Part Three: Share and publish a survey / poll
    Part Four: Add survey / poll to your website or blog




    Part One [/i] Create a survey / poll 1.1) Sign in to https://onedrive.live.com, select New > Excel Survey:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.2) Excel Online opens, showing Survey Wizard. To start creating your survey enter a title (#1 in screenshot), optional description (#2), first question (#3). When done add more questions (#4):

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.3) In next screenshot I have already added a title, description and a few questions. Adding a new question I enter the question itself (#1), optional subtitle (#2), type of answer (response) (#3), decide if answering this question is required or not, and in case of some response types set a default answer (#5), for instance if asking if people are coming to my party I would set default answer to No so only those really coming would change it to Yes:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.4) Available response types:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]

    - Text = any text, all text in one paragraph- Paragraph text = Answer can be given dividing it to paragraphs- Number = only numeric answers will be accepted- Date = only correctly formatted dates will be accepted- Time = only correctly formatted time will be accepted- Yes/No = dropdown selection with Yes and No shown, one must be selected- Choice = a list of user specified choices will be shown as dropdown selection

    1.5) An example of Default Value for response:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.6) When done, click / tap Save and View at bottom left of the wizard:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.7) You can now review the survey and test answering the questions:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.8) Click Submit to submit your test answers:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.9) You will see that your answers were submitted:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.10) Excel Online will show each question in its own column in first row. Each subsequent row contains answers from one person. If you want to delete someone from survey, delete that specific row:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.11) By default the survey is named Survey and placed on root of your OneDrive. Click / tap File at top left corner of Excel Online ribbon and select Save As > Rename to rename your survey as you wish:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]



    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    1.12) To save survey on another location select Save As:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]





    Part Two [/i] Customize output table
    2.1)
    The survey sheet must be left as it is, do not modify or edit it. Instead click / tap the + sign in status bar to create a new sheet for customised output. Rename your survey and output sheets simply by right clicking them and selecting Rename.

    In this example I named the survey sheet as Answers and output sheet as Table:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    2.2) This not being an Excel tutorial I will only show an example of what can be done. In below screenshot I have customised the table I will later embed in a post, the blue outline showing the area that will be shown in my post (cell range A2 to E27):

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    2.3) #1 in screenshot in step 2.2 = Cell E21 counts and shows how many of those answering the survey are using Windows 10 Insider builds.

    To do that I use COUNTIF function in a formula, which checks the Answers (survey) sheet column D from row 2 to row 1001 (if this poll will be popular I can always change it to 2000, 5000, whatever *Wink), column D being the one where answers about Windows version are stored, cell D1 being the question and answers starting from D2:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    2.4) #2 in screenshot in step 2.2 = To count how many answers survey has I use "help cells" (term I use, not official!); again using COUNTIF function I count in cell G6 how many answered Yes when asked if a Windows Insider, H6 counts how many answered No. As answering this question is required, everyone taking the survey must answer either Yes or No. Cell I6 then does the simple maths G6 + H6 (Yes answers + No answers) with formula SUM(G6+H6) to get grand total, which is then send to cell B6

    2.5)
    #3 in screenshot in step 2.2 = The same with row 18. For not using Windows 10 I had two options in this example survey, number of those who have used but not using anymore is counted in cell G18, those not using at all in cell H18, and total in I18, which is then sent to E18

    2.6) #4 in screenshot in step 2.2 = also for primary Windows 10 information source I had two "other" options, simple Other and Another Windows forums. I count these in G27 and H27, total in I27 and send this value to E27



    Part Three [/i] Share and publish a survey / poll
    3.1)
    When done, click the Survey button on Excel Online ribbon and select View Survey:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.2) Click Share Survey:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.3) Click Create link:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.4) Copy the link, paste it in Notepad and save in a safe place for instance your Documents folder in OneDrive. When saved, click Done:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.5) You can test your survey now and see how it looks by pasting the link in any browser:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.6) Anyone with link can open the survey and answer it, seeing a privacy warning before clicking Submit. In surveys like this example where no names and other personal details are asked, the warning is a bit unnecessary but better safe than sorry:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    3.7) A polite thank you note is shown when answers have been submitted:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]





    Part Four [/i] Add survey / poll to your website or blog
    4.1)
    Sign in to https://onedrive.live.com, browse to your survey, select it and click Embed:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    4.2) Click Generate:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    4.3) Click Customize how this embedded workbook...:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    4.4) In small Preview, select the sheet you want to embed:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    4.5) Click Select a range, enter 'Table'!XX:YY where XX is the top left and YY the bottom right cell of the region you want to embed (in step 2.2 you can see that I want to embed region from A2 to E27). When done press TAB key to activate range selection. Bottom left of the page, select Embed code or JavaScript, for instance for WordPress or BlogSpot blogs select Embed code. Copy the code and paste it in your website editor.:

    OneDrive - Create an online Excel survey with free Office Online [​IMG]



    That's it. You have created an online survey. In addition to embedding it to your website, you can simply post the link, email the link to your friends; anyone with the link can see and answer the poll.

    You can see this survey in action here: A Windows 10 Survey - Windows 10 Forums


    Kari

    :)
     
    Brink, Jan 19, 2017
    #1

  2. Survey

    I have created a survey form in office 365 which I am very happy with. the part I don't like is that i have to

    send a link to my customer. Is there not away to send the survey so they do not have to open a link? i want them to

    be able to open there email, answer my questions and submit the form in one signal step.

    its very hard to get people to fill out surveys, I want to make it as easy as possible.
     
    AnnieWiebe1, Oct 26, 2019
    #2
  3. Kari Win User
    A Windows 10 Survey



    OneDrive - Create an online Excel survey with free Office Online [​IMG]
    Information Hi geeks!

    Please give a minute of your time and answer this short and small Excel Online survey: Windows 10 Survey

    Survey is totally anonymous, no IP, location or other personal information is sent, no name or email asked. You don't have to be a TenForums member to take the survey, nor do you need any Microsoft or other accounts.

    This survey was done as an example for tutorial OneDrive - Create an online Excel survey with free Office Online which was published a few minutes ago. It was posted here to give tutorial readers a live example of how Office Online surveys and polls works.

    However, the survey is not only for instructional purposes. It is also a serious attempt to find out a bit more about how many of you geeks use Windows 10, where do you use it and what version you are using.

    Live results:



    Some questions have an option to comment. I will occasionally post best comments in this thread, positive and negative.

    Thank you for taking the survey!
     
  4. Kari Win User

    OneDrive - Create an online Excel survey with free Office Online

    Excel and OneDrive


    Turn AutoSave off (top left corner), screenshot from Excel 2016:


    OneDrive - Create an online Excel survey with free Office Online [​IMG]


    Excel will now prompt to save or discard changes, also for files on OneDrive.
     
  5. Windows 10 - OneDrive

    Right click on the app and one of the properties has an option to not automatically start it. Uncheck, restart the computer, and it should stop. If you want to go another step further, find the OneDrive app in the start menu, right click on it and uninstall.

    If that is still insufficient, there is a batch uninstaller for OneDrive available online. I can copy the code here if you need it.
     
    FordGT90Concept, Oct 26, 2019
    #5
  6. A. User Win User
    Excel 2016 Drop down lists

    Hi, SQRLR,

    This document from 2012 shows how to use Macro in dropdown menu.

    https://answers.microsoft.com/en-us/office/foru...

    Step by Step Tutorial with photos on creating the dropdown menu.

    https://www.lifewire.com/create-drop-down-list-...

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised
    on the site before you decide to download and install it.
     
    A. User, Oct 26, 2019
    #6
Thema:

OneDrive - Create an online Excel survey with free Office Online

Loading...
  1. OneDrive - Create an online Excel survey with free Office Online - Similar Threads - OneDrive Create online

  2. onedrive not syncing with onedrive online

    in Windows 10 Network and Sharing
    onedrive not syncing with onedrive online: do i need the business OneDrive app or the grooze.exe i have windows 10 20h2 dell inspiron 15 the files from my onedrive folder don't sync to onedrive.com website unless i drag and drop or upload individually....
  3. OneDrive not loading Excel files in the online browser

    in Windows 10 Ask Insider
    OneDrive not loading Excel files in the online browser: I use the browser version of OneDrive. When I click on an Excel file, it opens a new tab but just sits there and tries to load the page. The attached image is what it does, never loads any further than that. This means that if I want to view an Excel file, I need to download...
  4. OneDrive - How to save Office 365 documents online only?

    in Windows 10 Network and Sharing
    OneDrive - How to save Office 365 documents online only?: Saving files to OneDrive will usually result in a copy in the \OneDrive folder on the HDD. I am seeking a way to store Word/Excel documents within a OneDrive folder but only online, no copy on HDD. Within (for example) Excel, with an open document, I would go for File > Save...
  5. Cannot login to OneDrive on PC or online at Office 365

    in Windows 10 Software and Apps
    Cannot login to OneDrive on PC or online at Office 365: I cannot login to OneDrive on both online site and on PC. Get message "Sorry, there is a problem with the OneDrive servers" Error Code 0x8004def5 What is problem?...
  6. free live TV online

    in Microsoft Windows 10 Store
    free live TV online: Free live TV online stopped working on my desktop and two laptops all with windows 10. Please advise https://answers.microsoft.com/en-us/windows/forum/all/free-live-tv-online/1adccdaa-fff7-4773-8b38-afe1a5bb6c90"
  7. ESET free online scanner problems ?

    in AntiVirus, Firewalls and System Security
    ESET free online scanner problems ?: Hello, I have ESET online scanner installed and run it once a week or so as a second line of defence. I also have MalwareBytes installed which does automatic updates/scans. Both of these have run perfectly for ages but yesterday ESET started behaving oddly. When I run it the...
  8. Free and Premium Online Courses (with Certificate)

    in Windows 10 Network and Sharing
    Free and Premium Online Courses (with Certificate): willing to learn an additional skill and improve the knowledge in programming, security, emergency management, etc... Online Courses 137432
  9. Are there any FREE online virtual PC's

    in Windows 10 Support
    Are there any FREE online virtual PC's: not sure if this is the place to ask this, but are there any FREE online virtual PC's. Specifically something you could setup to play a mouse/keyboard recording on infinite, then come back months later, and it would still have been doing that task. 131488
  10. Get chatting on Skype from Office Online and OneDrive

    in Windows 10 News
    Get chatting on Skype from Office Online and OneDrive: At Skype, we are always looking for ways for you to stay in touch more easily with your friends, family, classmates and colleagues. A big part of that promise is by bringing your Skype experiences together with activities, like email and other online services, so that you can...