Form Ranger

Occasionally, helping others takes a decidedly nerdy turn. Such was the case recently when Mr. Anthony asked if there is a way to populate a Google Form's answer choices from a spreadsheet range. Taking a deeper dive into the esoteric oddities of a technology is great fun; a mind candy that keeps me smiling.

The answer is yes. Google Forms has a most useful add on called Form Ranger which populates answer choices from a Google Spreadsheet range. Form Ranger really shines if you are planning to create a Google Form with lots of answer choices, especially if the answers are in digital format like a class roster, comma separated value, or some other text document. Form Ranger is easily configured and its use is transparent. If you would like to use Form Ranger, the video below might be enough to get you started, or you may contact me for a demo.