How to create a survey database with only HTML and a Google Sheet
All these guides require that you have a free Sheet Monkey account. If you haven't registered your account, please do that before continuing.
When you need to put a simple survey on your site but don't want to use a third party tool, Sheet Monkey is great choice. Building a survey with Sheet Monkey only requires a spreadsheet and HTML and we've even made those for you to get you started.
Sample HTML:
<form action="<your-form-action>" method="post">
<label>Your Name: <input type="text" name="Name" required /></label>
<label>Your Email: <input type="email" name="Email" required /></label>
<label>Favorite Color: <select name="Response 1"><option>Red</option><option>Green</option><option>Blue</option></select></label>
<label>Do you like Ice Cream?: <input type="radio" name="Response 2" value="Yes" /> Yes <input type="radio" name="Response 2" value="No" /> No</label>
<label>Any other comments: <textarea name="Response 3" placeholder="Leave your thoughts here"></textarea></label>
<input type="hidden" name="Created" value="x-sheetmonkey-current-date-time" />
<input type="submit" value="Save Response" />
Remember: This HTML and this sheet are only suggestions to help get you started. Modify them as much as you want.