Creating Quick and Easy HTML Surveys/Forms That Export Results to CSV Files - All Under 10 Minutes!
This tutorial will cover creating an HTML survey that lets you export results to a CSV file in no time! I'll guide you through the process of setting up your own interactive survey using HTML and JavaScript. Regardless of whether you're a beginner or more experienced coder, I think you'll find this tutorial straightforward and accessible. If you don't and you need help, feel free to ask questions in the comments. I try to keep these videos brief to respect your time!
With this HTML survey, you may prevent the need of buying expensive data entry software in Microsoft Office (e.g., MS Access, MS Excel, etc.) or survey administrative software like Qualtrics. The ingredients you need are the ability to (1) enter data and (2) export/store data - and it's all here. This isn't the solution for all data entry needs, but it does provide an alternative option especially for those with limited budgets. Use R or Python to analyze your data (both of which are free) and you might just have everything you need.
In the end, you should be able to get your HTML survey up and running in less than 10 minutes! The result will be a functional HTML survey that captures user responses and stores them in a CSV file. I will also show you how to combine all of your CSV files into one and create a final survey dataset.
LINKS TO CODE
Full HTML/JavaScript Survey: https://controlc.com/b86becb0
PowerShell code to merge CSVs (Windows): https://controlc.com/21f866c0
Note: As of January 2024, Controlc.com the site where I hosted the code for this video abruptly removed all links that were generated without an account (which is why I initially used them) and set a new rule that "guest" links will expire after 72 hours. Unfortunately, the Mac and Linux code I had for this video were among these. Please let me know if you'd like the code and I can regenerate it for you.
VIDEO SUMMARY
Introduction - 0:00
Overview - 0:06
Opening Text Editor/Entering HTML - 0:19
Adding in JavaScript Code - 3:23
Making a Few Tweaks to Questions - 5:00
Ask ChatGPT to Generate a 4th Question - 6:20
Explaining JavaScript's Limitations Appending to an Existing CSV - 6:55
Use PowerShell to Combine all CSVs in a Folder - 7:24
Outro - 8:59
