Microsoft forms vs google forms

Microsoft and Google both have free forms software, with a lot in common but each does certain things better than the other. I go through both and contrast dozens of features across both to give a full picture. Google has searchable dropdowns, better spreadsheet linkages, allows response editing/autosave for recipients whereas Microsoft has a Ranking question type, analyses rating questions better, has better theming & re-colour text and has more branching capabilities.
Depending on your needs you may want to choose one of the other, and this video can help you decide.
00:00 - Introduction
00:46 - Question types
04:58 - Analysing answers
10:59 - Collaboration
11:50 - Results spreadsheet
13:09 - Comparing settings
15:28 - Collecting responses
17:15 - Creating questions

[@user-sw8if6mw2x]

fantastic!

[@learnspreadsheets]

Glad you liked it!

[@barttitulaerexcelbart9400]

Thanks David, very interesting. One question: if you want to analyze a question with multiple answers in Excel, you get all different answer combinations in one column. I had this issue to divide all possible answers in a separate column, this was done with a few tricks with Power Query. Do you know a trick to do this easy or have a video you know? Thanks.

[@learnspreadsheets]

Hiya yes… analysing multi select isn’t easy in excel & use of power query/power pivot is required, I have two videos which should help here: Try these videos on my channel: Clean survey data with Excel's Power Query
th-cam.com/video/A85t3b5Zn5Q/w-d-xo.html & Analyse Excel survey ratings with Power Query, Power Pivot & slicers
th-cam.com/video/3ffJzC5AR2Q/w-d-xo.html

[@davidgruty]

If I have a form, and different people fill it out every 3 months, is there a way to see the evolution of each participant in time?

[@learnspreadsheets]

Good question! This is possible with analysis on the connected spreadsheet. I have another video on analysing survey data which you may find useful

[@davidgruty]

@@learnspreadsheets could you direct me to the video?

[@CeliaAlvesSolveExcel]

Great video, David. Not being able to send files from outside the organization in Microsoft forms has been a pain.
I like to initiate the form from within Excel so that I know exactly where the answers spreadsheet is located in my sharepoint.

[@learnspreadsheets]

Thanks Celia! Yes they advertise it has free but you can’t collaborate, with the personal forms… that’s a good idea to initiate from excel yeah, google just lets you choose the spreadsheet output which is much better & download as a csv whenever you like. I also get annoyed when someone shares a form with me & I can’t access the results as the spreadsheet isn’t available. Microsoft’s branching & ranking questions are great though!

[@palashhaldar1605]

Not able to create group froms

[@learnspreadsheets]

Hello, if you have a business account then you should be able to but you have to navigate to the m365 group within the Microsoft forms homepage first, scroll down to the bottom of the page & you should see your groups