This updated Excel-to-web converter can hide entire worksheets when you create web surveys from Excel prototypes to disable irrelevant sections of the survey. Show rows in web calculators only when they are required for the calculation.
January 30, 2014 — SpreadsheetConverter is an add-on to Microsoft Excel that lets you convert spreadsheets to live web pages. The new version 7.4 recently became available at SpreadsheetConverter.com.
A unique feature of the new version is a user interface widget that can hide designated rows in the source spreadsheet, depending on conditions defined by the spreadsheet developer. This makes it possible to simplify a form or calculator by making sections of the calculator appear only if they are relevant to the current user. As an example, different address fields may be shown for domestic and international users.
“Excel is a marvelous tool to create electronic forms and web calculators, but it lacks some sophistication that we try to make up for with our unique set of widgets. Showing only relevant sections of a web form makes it much easier for end users”, says Anna Winter, sales manager for SpreadsheetConverter.
During the conversion to web format, the developer can choose to have different worksheets appear as separate tabs, as slide-in panels or in a step-by-step “wizard” fashion. In this situation, the new widget also has the ability to hide entire worksheets, for larger unwanted sections of a form or calculator. Winter describes this as the “in-depth trigger”.
“In a survey, you often have topic areas that only become relevant if someone has children, owns a certain product or has a particular interest. Hiding the irrelevant sections of a survey gives you a higher response rate and higher quality responses”, she says.
The ability to hide rows or worksheets can be nested infinitely. As the user enters data into previously hidden cells that just became visible, additional rows or worksheets may be unlocked.
SpreadsheetConverter is available for free trial at spreadsheetconverter.com/buy/free-trial/. It creates web pages that are completely standalone, do not use Excel and run on all web servers. You only need Excel and the Spreadsheet Converter add-on for the actual conversion from spreadsheet to web page format. There is a one-time fee for the conversion program, with no extra fees per page, user or server. You may use the program and the web pages it creates for as long as you like. Full versions start at $127.
Media contact: Anna Winter, firstname.lastname@example.org