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. ☮🙏

[@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??

[@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).

[@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!

[@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!

[@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!

[@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 :)

[@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.

[@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!

[@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!

[@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.

[@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 👍👍🙏🙏

[@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 👍

[@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!

[@samuelkodjoe1645]

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

[@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!!!

[@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!

[@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!

[@dkarthikr123]

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

[@LeilaGharani]

Thank you so much!!

[@called7bn]

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

[@LeilaGharani]

Glad it was helpful!

[@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.

[@bbashur]

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

[@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

[@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!

[@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..

[@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.

[@cliffmorgan9120]

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

[@LeilaGharani]

You are so welcome, Cliff!

[@XcelGuruSayantan]

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

[@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.

[@adenigba]

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

[@robregist]

Engaging, informative and nicely paced... 👍

[@juvyboiser2241]

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

[@PleasantPanther]

Thanks!

[@revingmsto6980]

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

[@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!

[@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.

[@daveys]

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

[@sriharim1596]

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

[@LeilaGharani]

Great to hear!

[@WilliamRay1981]

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

[@gmmichel7]

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

[@gunj12]

Many thanks for this. Very helpful 🙂

[@remediationdepartment4332]

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

[@kiacarens]

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

[@banderdammam9068]

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

[@andreaschunzel4672]

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

[@cherifbelfekih7545]

Great tutorials. I love the way they flow.

[@diegoloredobecerra7124]

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

[@AzizIzgin]

very infomative video, thanks, question though, when I do the form and export till to excel 11:28 , I gett all the information on one row. How come?

[@caselcortez8071]

I love the way you discuss in this video.

[@MrPeru510]

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

[@bluescream7463]

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

[@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!

[@BrPalavraCristã]

always impeccable teaching. your content are excellent

[@LeilaGharani]

I appreciate that!

[@foxyb8153]

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

[@LeilaGharani]

You are so welcome!

[@chrism9037]

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

[@LeilaGharani]

You're so welcome Chris!

[@chaiyya345]

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

[@shimamyina246]

This was super helpful. thanks.

[@cherhan2674]

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

[@MrSaylom]

Thanks a lot for an excellent coaching.

[@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!

[@swaminathannarayanan2639]

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

[@CeliaAlvesSolveExcel]

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

[@Sickreamz]

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

[@rodrigogarciasharpe5308]

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

[@andiesmithe1598]

Excellent structure and detail. You are awesome.

[@Jawad1058]

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

[@Tech_BFF]

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

[@anishjoshi9485]

Hello Leila! I wanted to add a checklist option in my form wherein the person answering can check multiple answers for a question..is that possible in microsoft forms?

[@topherwinters]

It is. 1) Select a "Choice" question type, 2) Ask your question, 3) List the answers you want them to choose from, 4) Click on the "Allow multiple answers" toggle at the bottom of the setup section. One thing to note - if you set your "Choice" to a dropdown display, Forms will disable the "Allow multiple answers" toggle switch.

[@AdityaKumar-zz7dm]

It was really lovely . Thanks for the knowledge & understanding :)

[@LeilaGharani]

My pleasure 😊

[@mahmoudelsayed5264]

great video, great explanation a lot of thanks.

[@HusseinKorish]

Extremely Useful ... thumps up .... thanks Leila

[@tusharpatil2989]

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

[@GpD79]

Leila, do you know if there is a way to get the overview information found at 10:50 into an excel document or word document?

[@LadyDelmar]

13:14 I would use this as an interest form to a new community I am selling and would like to print the forms for a file and have the ability for them to upload DL amd reservations. Is this possible?

[@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

[@wayneedmondson1065]

Hi Leila. Thanks for this Forms demo and good tips on how to start and the options available. Always interesting and useful information at your channel :)) Thumbs up!!

[@LeilaGharani]

Thank you Wayne.

[@adityapatnaik6079]

GREAT WORK ! YOU POST THE BEST CONTENT !

[@tithsambo6923]

I do like your tutoring 👍👍

[@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?

[@logandwilliams]

3:05 my ribbon and menus look quite different from yours. I have a premium account for personal, and a premium for business. I am trying to use my premium for personal for this project/tutorial. Help?

[@sailingmarquise9742]

Very useful video congratulation Leila

[@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.

[@youtubeCK-bk2ob]

I'm a bit confused. At 11:50 you say that if people are logged in to their accounts, then the excel will display their names and emails. In the beginning of the video, you deselected "Record Names". Wouldn't the responses still remain anonymous after you deselect record names even if folks are logged in and take the survey? Thank you

[@pwanlass]

Fantastic video!

[@davecks3042]

The guru of excel

[@akinwaleakinlosotu4079]

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

[@leoric3081]

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

[@LeilaGharani]

Glad to hear that!

[@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

[@TheQureshy]

Thank you Leila, great video. Learned some great tips there.

[@kostyantynbrazhko2510]

hi Leila. useful video - thank you. i intend to copy n paste the list of countries from excel like you did to have the drop down list to select from in survey. Q: is it possible to introduce the dynamic drop down i.e. i want people to select their region first and then select their country based on the region they selected. the country list would only contain countries in that region.

[@BahySaleh-f5l]

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

[@gracemark5995]

learned a lot from you leila in microsoft forms 👍👍👍

[@davidmelgar1935]

Super helpful video!!

[@thedish5]

Super useful! Thank you!

[@brahmmamb24]

Every video is amazing tips has been sharing.. Thank you so much

[@saskiahenfling9895]

Great tutorías, thanks Gharani😘

[@LeilaGharani]

My pleasure 😊

[@YauFennie]

Leila... U are the best!!

[@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?

[@notnecessary7730]

TY Leila. Do you have any Info on quizzes? Do you known it they have made any updates or if there is a way to reuse a quiz so we don't have to keep writing quizzes over and over and over??