May 2025
- Mahesh Balakrishnan
- Jun 3
- 3 min read
Spreadsheet to a fully functional VQB quiz
Several customers have recently requested the ability to upload a spreadsheet with question and answers and have the spreadsheet converted to a VQB quiz. We are excited to roll out v1 of this feature and will continue to upgrade and add related features as we collect your feedback.
What's significant about this feature relative to other apps (if they support this feature in the first place) is that our dashboard will accept the question and answers in whichever format you have them available. If you are porting your quiz from another app and have the quiz as a spreadsheet or have already prepared your quiz as a spreadsheet, you can upload your spreadsheet as-is. If you further specify the type of question in the spreadsheet -- e.g. text options, visual options, text slider, user name, etc -- Visual Quiz Builder will reflect that in the converted quiz. Else, our AI will use it's best guess on the question type.
Here are a couple of examples to make the point clear:
Example 1
Example 2
Here are some of the upgrades that you can expect in future releases:
At this time, our app recognizes question titles and answer option titles but, in the future, you can include URLs for images, color codes and a lot more in your spreadsheet
Copy / Pasting the text of answer options into an input box and leaving it to our dashboard to convert them into answer options
Including product handles for various answer options in the spreadsheet so Visual Quiz Builder can tag the quiz for you as well
Prompting our AI to add CSS got a lot better
We announced this feature last month and made some substantial improvements to it based on further testing and feedback. For one, we are using a different model that is significantly better at interpreting prompts and generating code. Our AI is also keeping the context of existing code and only suggesting additional code that is compatible with prior code to achieve the desired outcome. Secondly, you can undo and redo any of the code suggested by our AI; very helpful when there are many lines of added code. This makes our CSS editor accessible to anyone; you do not need to know CSS. You are only limited by your imagination!
Additional settings for mobile vs desktop
We had mentioned in last month's update that we will be adding separate mobile settings for components like tooltips, pop-ups and additional question types in the coming weeks. With the latest release, nearly all settings on the dashboard can be set separately for desktop / mobile without a line of code. Of course the app will continue to be responsive as before and provide you the optionality to optimize settings as needed. A few quick tips on how to access these additional settings:
For various alignment options (including margins and padding), click to expand the HTML text editor for the relevant component in the Edit tab and switch between devices to access the relevant options.
For layout options ranging from font sizes, colors, backgrounds, roundedness and more, access these options within the Layout tab. If you're looking to change these options across the entire quiz, access them under Global Settings.
If you're looking to change these options for specific sections like the landing page or questions or result page, access them under the specific section.
Know anyone who would benefit from a VQB Quiz? Let us reward you generously when you refer a customer.
Comments