SpreadsheetConverter has five different ways to handle multi-sheet workbooks:

  • Listview shows the sheet names in a list, and you click on a name to view a sheet. (Available in the iPhone/Android flavor only.)
  • Tabs generates a tab for each worksheet in the workbook, much like Excel itself does, to let you select what sheet you want to work with. (Available in all flavors except iPhone/Android.)
  • Wizard uses Next and Previous buttons in the toolbar to guide the user through a sequential step-by-step data entry process.
  • Panels are horizontal headers, each representing a worksheet. When you click on a panel, the corresponding worksheet slides down to appear below it. If you click on the panel again, the worksheet disappears again by sliding in under the panel.
  • Accordion layouts are similar to panel layouts but show only one section of the form at a time.

Make all required worksheets visible

To work with more than one worksheet in a workbook, you must first make all the required worksheets visible in the converted web page. Hiding worksheets is done in the Worksheets tab in the Settings panel.

Switch to the SpreadsheetConverter ribbon

In Excel, look for the SpreadsheetConverter tab at the right end of the menu ribbon. Click the tab to switch to the SpreadsheetConverter ribbon.


Open the SpreadsheetConverter Settings panel

In the SpreadsheetConverter ribbon, select Properties > Show so that the SpreadsheetConverter Settings panel becomes visible.


Open the Worksheets Settings panel

In the SpreadsheetConverter Settings panel, select the Worksheets tab so that the Worksheets Settings become visible.


Worksheets > Hide worksheets

By default, SpreadsheetConverter shows only the active worksheet. If your spreadsheet contains more than one worksheet, uncheck the appropriate checkboxes to make the corresponding worksheets visible in the converted web page.


Preferences > Customize Text

To change or translate any built-in texts used with your form, including the button texts, use Preferences > Customize Text.


Listview layouts

The Listview layout is only used for small screens when converting with the iPhone/Android flavor, and contains a list of the worksheets in the web page. The user scrolls to a sheet and clicks on it to view it. Any worksheet can be viewed at any time.

Screenshot of the Listview layout in the Workbook tab of the task pane

If the workbook is used as a multi-section form, it can be submitted for processing by pressing the Submit button in the Side menu.

Screenshot of the Side menu

Tabbed workbook layouts

With a Tabs layout, SpreadsheetConverter generates a row of links at the top of the web page, with one link for each worksheet. Clicking on the Delivery or Billing link below takes you to the corresponding worksheet. The user can view any worksheet at any time.


If the workbook is used as a multi-section form, it can be submitted for processing by pressing the Submit button in the toolbar.

Data entry wizard layouts

Choosing a wizard layout creates a sequential data entry wizard to guide the user through the various sections of the form. The user advances from each section to the next using a Next button.


The Previous button returns to preceding section of the form. Finish bypasses all remaining steps and immediately submits the form.

You can add a Cancel button that allows the user to exit from the wizard without submitting the form. To add a Cancel button, specify an URL for After Cancel in the wizard in the Workbook > Configure Submit settings.

All the button names can be modified in Preferences > Customize Texts.

So called breadcrumbs appear at the bottom of the toolbar to give users a way to keep track of their location within the wizard (the term comes from the trail of breadcrumbs left by Hansel and Gretel in the popular fairytale).

Panel layouts

Panels enable the user to view one or more worksheets simultaneously. The user can switch between sections of the form at will, or work with two or more sections at the same time.

In the example below, both the Products and Billing worksheets are visible at the same time.


A form created with panels can be submitted at any time by pressing the Submit button.

Accordion layouts

With an accordion layout, only one section of the form is visible while the rest of the form is hidden. Clicking on the Products panel displays the Products worksheet.


Clicking on the Delivery panel closes the Products panel and opens the Delivery worksheet.


Forms created with an accordion layout are submitted with the Submit button.

Build live website calculators and web forms now!

conversion imageconversion imageconversion image

Just download, install and test the Excel add-on now. Or let us convert a spreadsheet for you, for free.