Properly Create Surveys with Microsoft Forms & Export to Excel

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@shimaaal_harbi4155]

Hi, I have question let say I have a question to upload excel file, now how to heve this uploaded files into my excel as Data rows it's shown as links I want a way to read from upload and insert as rows

[@ishrashad]

As usual, thanks again, Leila. When I come to KZbin to explore and learn about a new topic - in this case, MS365 and MS apps - it should be confusing because there are (literally) hundreds (if not thousands) of quality tutorials. But there are only a handful of educators who are of platinum+++ standard, whose tutorials I know will give me exactly what I need. Every time, without fail. You are right the top of the tree, and thank you for the obvious effort you put into this. if I sound extra-grateful today, it is because MS Forms is maybe their poorest documented product, and many non-MS tutorials only regurgitate the basics. It is so rewarding to arrive here and listen to your crystal clear presentation on the Forms-Excel relationship and link. Just brilliant. ☮🙏

[@biggeekreview]

Thank you so much for making this tutorial! My organization has been using a system of paper surveys for over ten years and this is going to save HUNDREDS of hours of work transferring them into excel and is infinitely simpler to use!

[@t3geek]

I love and appreciate the timeliness of your videos, Leila. Sometimes I feel like we're on a similar learning journey, but that you're just ahead of me, so that I (and obviously everyone else) reaps the benefits of your willingness to share what you know and have learned. Greatly appreciated, and don't stop learning and sharing!

[@LeilaGharani]

There will be more :)

[@hannesjohne4622]

5:33 copy and paste multi-row data as individual answer options - such a time saver! In this example a list of countries is easily transported to MS forms - without the need to individually copy & paste each country name (=cell).

[@TylerStanczak]

I have had to learn this in the past on my own so this is great to see a well designed tutorial on this. Thank you! :)

[@LeilaGharani]

Great to hear! Thank you!

[@imangoli1224]

@@LeilaGharani Hi, I'm from Iran 🇮🇷 I have a problem I want to know how can we convert the Xlsm file to Exe or something like that Others can use this app without Excel. I searched for this about 8months Can you help us??

[@deitragomez7365]

I've recently had to create more and more forms to collect opinions/preferences, basic data and have had so much trouble getting this accomplished. After watching a couple of hours worth I can across this one and it is a time saver! The tutorial is so easy to follow at a nice pace with great explanation. Thank you, thank you!

[@ricdonato4328]

Thank you for your explanation. Other videos explain how to make forms, how they function, all their features, they did not explain where the data goes, how to use the collected data, where it connects to anything least of all Excel. When I first saw MS Forms I thought "ah-hah similar to Google Forms which ties into Google Sheets." Nobody explained the use of Excel, at least the videos I watched. Your explanation is a breath of enlightenment. Yes, yes, I first should have looked for your video. Thank you!

[@cthru2k]

I am currently moving our company to Teams and using these apps to connect our organization. Your videos have been such a huge asset for me! Thank you!

[@miguelencanarias]

This has been the closest thing to a revelation I have ever had. Fantastic feature!! Thank you, Leila. You rock, as always!

[@LeilaGharani]

Glad it was helpful Miguel! Thanks for dropping by.

[@williambell4591]

Now Leila!, You know you should have SELECTED 20 for the answer about your Excel skills!! 😁😋 I agree with the comments below - here I am needing to create my first survey form, and (as always), here you are boosting my knowledge level on the subject! I appreciate you, Leila, WE ALL appreciate you - you're SAVING LIVES out here on these Microsoft Office streets - PROPS!

[@ciruzzi7]

As a novice I was able to follow along and create my first MS Forms document. Now that it's created it has to go to multiple administrators for approval. I'm off to see if there's a video, by you of course, to automate the flow of approvals. Fingers Crossed

[@florin1504]

Leila, unbelievable well presentations. I didn’t learn anything in school, despite thousands owed in student loans, compared with what I learned from you. Thank you much!!!

[@vishalmathur8624]

I started watching your video from yesterday and I'm just loving all of them....... You're doing just great work Keep it up Good bless you 👍

[@gracemark5995]

still watching your videos leila i'm not getting bored about microsoft forms in this pandemic situation and learning a lot more thank you so much ....... hope you do more and more videos further ..and i can't wait to watch it................... thank you once again 👍👍🙏🙏

[@nipunkavinda8254]

It is very useful to get responses from people via Microsoft Forms in secure manner. Users also have good options to analys the data through Excel. That make easier for selection of better responses. Thanks for the tutorial Leila.

[@LeilaGharani]

You're very welcome!

[@bajanbear]

I tried it on my own yesterday (8 Dec) for the first time and I did it from Forms first, I couldn't get it shared to who I wanted it to go to. I thank you for this video, good job.

[@MathematicsClasses001]

I had learned a lot from you. You are the best in explaining things. Your presentation skills and ability to put important points in a concise manner, that what I admire a lot. We can try it to take online quiz as well.

[@LeilaGharani]

Thank you, I appreciate that!

[@olga.m1162]

Thank you very much. You are a wonderful expert in what you are doing, you understand the needs of common users, and you are an amazing trainer.

[@vijayarjunwadkar]

Every time I watch your video, I end up learning something new and today was no exception! Just when I thought, I knew Forms enough, I was surprised by some things I never noticed! Thanks for enlightening! 😊👍 BTW, up next is what? a video on Grid documents? Would love to learn that from you!

[@rajangm9072]

Thank you, I have 365 account, but creating forms directly, not from excel. Then I downloaded the responses in excel, copy and paste them in my master excel. I was not aware of crating forms from excel itself. Thanks for sharing.

[@samuelkodjoe1645]

just conducted an experiment and it was really fantastic!!!. Thanks Leila....Such a darling!!

[@tech_obsessed]

Thank you! Note that the Forms option in Excel is only available for Work and/or School accounts.

[@called7bn]

I love this tutorial! So concise and organized in the explanation and all the steps. Thank you!

[@LeilaGharani]

Glad it was helpful!

[@odelakumar06]

Thank you very much.. i am into market research domain and working with other survey platforms but today because of you i came to know this an another beautiful option.. thank you..

[@MM-nr8nf]

Was using Office 365 E5 from past 4 years but never knew this was there!! And we were using manual entry forms all along 🙃 Thanks Liela !!

[@LeilaGharani]

Hope it will come in handy for you.

[@anillpatel]

Wow, this is so amazing. Just what I was looking for to create a survey. You made it look so easy. Thank you Leila.

[@LeilaGharani]

You're very welcome!

[@sriharim1596]

Thanks Leila... now I'm aware on Form functionalities much better than earlier..

[@LeilaGharani]

Great to hear!

[@pooyannaghsh6274]

What a useful concept! thank you, Leila! It was my nightmare for more than 3 years that started in 2012 in the computer world for my small business.

[@XcelGuruSayantan]

This is a very good video for beginners who don't have any idea about Microsoft Forms.

[@bbashur]

A great session by excellent instructor! Thank you Leila. Greetings from Vienna...

[@moeeeeeeeekdkdkd]

I am a BIG fan of yours!! Incredibly amazing presentation and I NEVER get bored of the topics you share and teach!! BEST OF LUCK to you because you deserve all the best!!

[@LeilaGharani]

Thank you! You too!

[@adenigba]

You are such a blessing to humanity....Thank you

[@revingmsto6980]

Dear Madam, Thank you for making this video. Your videos are always perfect

[@juvyboiser2241]

Thank you so much for your tutorial videos! It's so easy to understand and apply on my own.

[@cherhan2674]

Thank you Leila! would you please help to find "insert form" button? my insert ribbon don't have form button

[@cliffmorgan9120]

I have been learning from your videos for some time now....thank you for what you do!

[@LeilaGharani]

You are so welcome, Cliff!

[@chaiyya345]

Another great sharing Leila! I guess, im not the only whom didnt get Forms from the tab from Excel Online.

[@foxyb8153]

Thank you, that was really informative. The way you explain is simple and very much understandable ❤️

[@LeilaGharani]

You are so welcome!

[@dkarthikr123]

Your Excel skill is 7!! thats so humble.. loved the video as always:)

[@LeilaGharani]

Thank you so much!!

[@mohammedalbaqaawi8548]

Many thanks Dear Leila for sharing I'm learning so much from you, you are AMAZING

[@MrEagle1982]

Wow, creating Forms from Excel online is really a neat trick! I am going to use it for my next project.. Thanks a lot!

[@caselcortez8071]

I love the way you discuss in this video.

[@andreaschunzel4672]

Das war einmal wieder perfekt erklärt, und obwohl ich Forms gut kenne habe ich wieder etwas gelernt! Vielen Dank!

[@banderdammam9068]

Thank you, Leila. your video is great and to the point

[@Choroidal]

Excellent presentation Leila, thank you. I had no idea this was available in Excel so opted to use Google Sheets instead for a survey.

[@LeilaGharani]

Glad it was helpful!

[@DavidVoran]

I have a Microsoft 365 Family account but do not see the integrated Forms option when opening up Excel Online. I was able to create forms, get replies, view, and download them but not the integrated one you demonstrated. It appears this feature should be available in all versions, not just Business and Education. Is there a way to turn it on for the rest of us individual or family MS365 account holders?

[@gerardozuccala]

hi, i have the some problem

[@shalini2000]

I've the same problem.

[@hamedriyahyzadeh8414]

fantastic/concise/ informative Great video! Your explanations were clear and easy to understand. Keep up the excellent work!

[@swaminathannarayanan2639]

This time, before you I have learned ms forms.. Expecting Power Automate complete course from you.. Thanks for this video

[@TsuDenom]

Thanks for sharing this Leila - it was well presented! One would be also interested in how best or smartest to analyze the data towards presenting from the created survey via say pivot or otherwise?

[@CeliaAlvesSolveExcel]

This is great! I had not realized the automatic connection when we use Excel online.

[@TheRWD82]

Thank you for your videos, it helps me to stay up to date with excel. I've the paid version of Office 365 and I didn't find "Forms" in excel, any hints?

[@chrism9037]

I’ve never used Forms before, this was great info. Thanks Leila!

[@LeilaGharani]

You're so welcome Chris!

[@diegoloredobecerra7124]

Great video, it was brief and very easy to understand.

[@bluescream7463]

Very good presentation, please continue doing the things you do !! Full appreciation !

[@drdentrepair5530]

Thank you for your time in putting this video together. Many helpful tips. My question is let's say that one of the lines asked for their phone number. Is there a way to have their response automatically come up as (xxx) xxx-xxxx?

[@BrPalavraCristã]

always impeccable teaching. your content are excellent

[@LeilaGharani]

I appreciate that!

[@daveys]

This is a great tutorial on MS Forms, many thanks Leila!

[@Jawad1058]

Thank you very much my dear Leila, this was very helpful, simple, and clear. وفقك الله

[@MrSaylom]

Thanks a lot for an excellent coaching.

[@nadiahDono]

May I ask if we can automatically email the respondent after submitting the form? Like webminar invitation link on Team. Anw, all ur tutorials are gems. It helps me a lot!

[@tusharpatil2989]

It's good experience to use forms effectively and nicely explained.

[@trevorparnham]

Leila, I've only just found and am I glad I have. How can I make this also a paper survey and load the results into Excel? Can you point me in the right direction?🙏

[@akinwaleakinlosotu4079]

Heavens bless you for this video. It has helped me a lot. Thanks a lot.

[@kiacarens]

Thank you Leila. You saved me. Great video! Love you!

[@rodrigogarciasharpe5308]

Your videos are so good and helpful!, thank you for your time and work.

[@remars-xcel]

The Queen never fails to impress me, imagine Excel is reinventing itself by using forms and not rely on VBA complex coding.... except M code lol

[@randomrandy3059]

I dont see new form on the excel sheet. I am a 365 subscriber... and It dont take me to Excel, but rather Downloads a file and then I can open it in excel.

[@leoric3081]

This is a great lesson and will be extremely useful. Thank you!

[@LeilaGharani]

Glad to hear that!

[@kelleyhiggins327]

Hi Leila- Just finished watching your video. Thank-you for taking time to make it. It was a 5 on helpful. I do have a follow-up question...I noticed the forms were entered in excel as anonymous and with no email if not in company. I run an educational program and do need to associate responses by name at least. None of my students are "in my company" Any suggestions on how to get names?

[@myriambaiguerel2294]

Hi Leila! Thank you for this enlightening video. I would like to know how to create multiple forms in one Excel workbook. Is that possible? THanks

[@cherifbelfekih7545]

Great tutorials. I love the way they flow.

[@alimir2561]

Thanks Leila for tutorial, after watching this video, I have successfully created a form but I encountered some issue like few additional columns and duplicated columns are in excel sheet. How can I fix this issue, Please help me out.

[@mayurkhatri1048]

Hi, I am a great fan of the way you teach and the topics that you cover. I have learned a lot from your videos. While I was going through the current video, it just came to my mind that Google Forms is also an effective tool to create survey form. I have not used Microsoft forms earlier, so I am not sure which is better one.

[@LeilaGharani]

Microsoft Forms is relatively new. I actually only used Google Forms before. There were a few things that Excel Forms lacked. They've really improved though and continuing to improve.

[@gmmichel7]

You did a good job, your explanation is clear and useful

[@andiesmithe1598]

Excellent structure and detail. You are awesome.

[@MrPeru510]

Thanks (as usual) for the great content! You Rock!!!

[@mahmoudelsayed5264]

great video, great explanation a lot of thanks.

[@remediationdepartment4332]

I love all you videos, Thanks for your efforts!!!!!!

[@vinodxavier8160]

Thanks Leila for a very good and easy understandable video for creating survey form from excel. Now I am facing an issue in creating quiz using this method. While creating quiz in Teams classroom it is not showing the forms created from excel. Can you help me out in solving the issue

[@jayachandrank1075]

Great! Is it possible to set /automate to send reminder to the client if he/she has not yet completed the survey. Like for example - remainder once every Monday until the client completes the survey. Appreciate your response

[@rhettscott3124]

Leila, love the video. Is there a way that I can use external survey data submitted to MS Outlook and then automatically ingest to MS Excel???

[@davecks3042]

The guru of excel

[@shilpa2791]

Hi Leila, Thanks for the tutorial. How do i ask for comments if users choose disagree

[@kevinochieng4591]

Thanks so much for your videos.they are very helpful.Any trick /add-on to incorporate geo location field on Microsoft forms

[@soosnatachowdhury8974]

Hi Leila, TY for this educational video. Very insightful indeed. Could you guide me to identify why some qr codes are unrecognizable on Android only and not on Apple

[@rajani2002]

Use this version, its working well, thanks.. But we are unable to add multiple form in another sheet within same workbook... is there any solution for this ?

[@fatimaahmed7156]

This is interesting ❤ but what is the difference between Google forms and Microsoft forms ? I believe we can get the survey results with Google forms as well

[@hildahildasweet]

Thank you so much Leila, I have been obsessed with our Channel!. I do have a questions regarding this tutorial. How may I rearrange the questions in Excel after the form is created?

[@zeinabouibrahim2697]

Hi Leila, thanks for your videos, it helps me a lot in my daily tasks. One question please, i tried to add file uploader in my form, but it doesnt allow me to share the form with People out of my organisation. Is there any solution for that. Thanks a lot

[@infy25]

Great video thank you so much. Is there a way to trigger a form from particular cell or a row from Excel and response to that form should be saved in the same row/cell from wr it was triggered?

[@rajeshsanjiv]

Thank you. That was crisp. 1 Q. Can you change the date format on the form?

[@jeffreymenezes6493]

Great Tutorial, thanks Is it possible to create an excel spread sheet that can have formulas extracted from an online Form? If so, how?

[@alexd.8361]

Hello good video, very informative and easy explained. How can I connect the form and spreadsheet to Teams so inserts are submitted live? Need this as an App for team members to submit hot calls which would go live into the excel sheet, which is supposed to be connected to a Teams Channel.

[@simpliexcel1289]

That was indeed a great tutorial Leila. Thank you for making this video. There is one more option in MS forms that is option to upload/attach file to the form. Most of the people don't use it even though they need to. It will be nice if you create another video and cover that part as well. All the best for the future.👍👍

[@qwandary]

It only lets you add media (image of video) these days.

[@kramdsm]

Hello - Great demo. Can you secure (shield) the responses form the submitters? For example if this was an HR (Human Resources) form and you want to limit the ability to view or download the responses, can you limit access?

[@PeterGMcDermott]

What a great tutorial! I noticed today that another entry point to create one is within the desired folder of the Excel file in Microsoft Teams. In the file viewer within Teams, click + to create new, and then select Forms (it will have the Excel icon) it should do the same thing!

[@LeilaGharani]

Thanks for the tip, Peter. I'll check it out.

[@BahySaleh-f5l]

Hi Leila, can I export and import Microsoft Forms between different accounts? e.g. from Microsoft Work account to Personal Microsoft account?

[@maximlarioshin7402]

Thank you Leila!

[@mattschoular8844]

Hmmm.., The combination of Forms and Grid is very interesting. Thanks Leila