MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Surveys & Forms in Excel


November 20, 2019 - by Bill Jelen

Excel Surveys & Forms in Excel. Photo Credit: Mael BALLAND at Unsplash.com

I often start my live Excel seminars off by asking you to point your cell phone camera at a giant bar code I have projected on the screen. That QR code leads to a three-question survey. Answers automatically flow into my Excel worksheet and those answers get used in the afternoon demo of 3D Maps.

One way to use the feature is to start at Forms.Office.com. If you use OneDrive for Business, you might see a Forms icon as the fourth icon in the Insert tab. But others will see a Survey icon, which is not as robust.

A browser will open and you can build your form. Click New Question. Forms offers support for seven question types. Don't miss the useful Ranking or Likert types hidden behind the three dots.


As you are building survey questions, there are four question types visible: Choice, Text, Ranking, Date. But if you click on the three dots, you have more choices such as Raking, Likert, and New Promoter Score.

Type the question and possible answers.

With a multiple choice question, type the question and some answers. You can Add Option to increase the number of possible answers. Use Add Other Option to allow people to type their own answer.

When you are done with all questions, click Share in the top right corner. You can share via a link, or via e-mail, or using the QR Code.

On the Share tab, you can generate a link, download a QR Code, get embed code, or e-mail the survey to recipients.

Try it: point your cell phone camera at the bar code below. A box should appear offering to open a web page.

A QR code that leads to a survey.

Title Photo: Mael BALLAND at Unsplash.com


Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.