SpreadsheetConverter lets you create web pages with live formulas. One example is when sales tax is added to a sale. You create your formula-driven web page directly in Excel, with the skills you already have. The resulting web page may be simple, but very promising.

In this example, a calculating web page is created in a few minutes. We start with a very simple Excel spreadsheet, and create a web page that looks the same and calculates the same.

For European visitors, we have also provided a version of this tutorial for value-added tax (VAT).

The spreadsheet

It is a simple spreadsheet that takes a user entered price and tax rate, and displays the sales tax amount and the total price with sales tax.

sales-tax-calculator-web-322-192

The formulas are:

sales tax in dollars = price_without_tax * sales tax rate in %

total price = price_without_tax + sales tax in dollars

sales-tax-calculator-excel-334-200

If you don’t want to practice using the product,

the original spreadsheet can be downloaded here.

Layout and formatting

The settings for layout and formatting in Excel are carried over to the converted web page. To create this example, do the following:

  • Merge and center the cells A1:D1
  • Set the font size of A1 to 14
  • Set the background color (Format Cells > Fill) for the heading and the calculated values
  • Format the fields with currency symbols, decimals and thousands separators

SpreadsheetConverter settings

These are the settings you need to make in SpreadsheetConverter:

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.

ssc6-ssc-ribbon-tab-410-90

PREFERENCES > BROWSERS AND CONVERSION PATH OPTIONS

Your SpreadsheetConverter Preferences determine where the results of your conversions are stored. Open the Preferences menu.

ssc6-menu-269-136

Select “Browsers and Conversion Path Option”.

browser and conversion path

Click on the button to the right under Choose folder to store webpage and navigate to where you want SpreadsheetConverter to store the web pages it creates. Each converted calculator or form will be enclosed in its own subfolder.

ssc6-browsers-and-conversion-path-option-350-211

Select what browsers you wish to verify the result of each conversion in – click once to activate a browser, click once again to deactivate. Your converted web pages will open in all selected browsers directly after conversion.

OPEN THE SPREADSHEETCONVERTER SETTINGS PANEL

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

ssc6-menu-show-298-87

OPEN THE WORKSHEETS SETTINGS PANEL

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

ssc6-panel-worksheets-tab-407-210

WORKSHEETS > HIDE WORKSHEETS

By default, SpreadsheetConverter shows only the active worksheet. If your spreadsheet contains more than one worksheet, use these settings to make additional worksheets visible or hidden in the converted web page.

ssc6-hide-worksheets-288-167

OPEN THE WORKBOOK SETTINGS PANEL

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

ssc6-panel-workbook-tab-412-209

WORKBOOK > LAYOUT > TABS

In the Workbook Settings panel, locate the Layout settings. This is where you select how you want the converted web page to appear. Select “Tabs” to give each worksheet its own tab in the web page, just like in Excel. When you start to make complex web forms, you may prefer one of the more advanced options here, e.g. to show the form as a wizard, where each worksheet is a separate step.

ssc6-workbook-layout-277-183

WORKBOOK > INPUT CELLS > AUTO

In the Workbook Settings panel, locate the Input Cells settings. In Excel, all cells are unlocked by default, and can be modified by the user. In the web page, we only want to open a few of the cells for input. In the “Auto” mode, SpreadsheetConverter automatically unlocks cells that are referenced in formulas, and cells that contain a Text Field widget. You can also mark cells for input by giving them a unique background color, or by unlocking them.

ssc6-workbook-input-cells-272-107

Convert the spreadsheet

SAVE THE FILE

Before you convert the spreadsheet to a web page, remember to save it in Excel.

If you closed the spreadsheet, open it again so that it is visible in Excel.

SELECT THE FLAVOR YOU WANT

SpreadsheetConverter can generate the web page in different formats, depending on your needs. You may later want to convert your own spreadsheets for other environments, e.g. for iPhone or Android smartphones, for Windows web servers with ASP.NET, or in Flash format. Select “Html” for this tutorial.

ssc6-menu-flavor-284-168

CLICK CONVERT

To start the conversion, click “Convert” in the SpreadsheetConverter ribbon.

ssc6-menu-convert-279-92

Ensure that there are only “Information” messages in the “Errors” panel. If you have any other messages, don’t hesitate to contact our Help Center.

ssc6-errors-no-errors-299-224

The converted web page

SpreadsheetConverter creates the web page in the folder you previously specified, and opens the resulting web page in the browsers you selected.

The webpage is self-contained. You can upload it to a web server, or send it as an e-mail to a customer. Everyone with a web browser can use it.

sales-tax-calculator-web-322-192

Conclusion

SpreadsheetConverter can take just about any spreadsheet with formulas and all, and convert it to a live web page that still does all the calculations exactly the same as in Excel.

To test the calculator, change the price and press the Tab key. The price including sales tax will be updated immediately. Test the sales tax calculator here!