Use Simple Forms to Collect Information the Easy Way
Akerele Oluwasogo, GLMP (MR EXCEL)
FOUNDER | CEO | Microsoft Excel, SQL, Tableau and Power BI Corporate Trainer at Lead-Leap Consulting Limited
There are a lot of us who at one point or another need to collect information from a number of different people. Traditionally, you send out an email asking for the information you want. Then the ‘fun’ begins…a flood of email replies overwhelm your inbox…at some point you have to take a trip to the copy & paste rodeo so you can consolidate everyone’s answers into a single place so you can make sense of it all. It is painful and time consuming.
Today, I’ll tell you how you can say good bye to those overloaded inboxes and the copy & paste-apalooza and make the whole process quick and painless. The secret is to use a web form that will automatically collect all the responses for you in a nice, neat spreadsheet. Once you’ve setup your questions all you have to do is sit back and watch the data roll in, while sipping a nice, warm cup of coffee (or whatever drink you prefer). Easy peezy – here are a couple nice, free options.
These online survey tools let other people fill out a form—like a sign-up sheet or questionnaire—where you can see it all in one place online. You can create a survey, send everyone a link and all the responses are compiled for you, automatically in an online spreadsheet.
Google Docs Form
1. Go to Google Drive at drive.google.com.
2. In the new Drive, click New in the top left, hover over More, and choose Google Forms.
( In the older version of Drive, click the Create button in the top left, then Form.)
In the form template that opens, you can add any questions you’d like. You can also organize your form by adding headers and dividing your form into several pages. Learn more about editing your form.