No More Publish to Dropbox

Dropbox is removing the ability to host calculators on the web from your Dropbox account. All existing calculators in Dropbox will soon disappear from the web. The information below is therefore partly inapplicable.

We are developing a similar click-to-publish solution specifically for WordPress, where the calculator or form is hosted on the WordPress server. We also consider developing a more generic solution, similar to the Dropbox connection we had in the past.

Meanwhile, we suggest you try to upload your converted calculator to your own website or blog.

The easiest way to import an Excel calculator, live chart or smart form into a Google sites blog or website is to use SpreadsheetConverter. This tutorial will show you how to publish live Excel spreadsheets and charts in Google Sites using Dropbox and an iframe.

Adding a live calculator or chart to your website adds value to your visitors and makes your website more interactive. SpreadsheetConverter converts Excel spreadsheets, charts and tables to live web pages that can easily be imported into your Google Sites blog or website using an iframe.

Screenshot of a sales tax calculator in Google Sites


Most Google Sites blogs consist of just text and static images. A simple way to make your blog or website more interesting is to add a live chart, calculator or web form to it. Help your visitors solve their problems or visualize their situation!

To create this tutorial, we took a simple calculator for sales tax and published it in a Google Sites website. To be able to embed the Excel spreadsheet in a web page, we first converted it to HTML and JavaScript using SpreadsheetConverter HTML.

With this clever Excel plugin you can also create advanced tables, import complex charts or open live graphs in Google Sites.

Creating the calculator

Converting the spreadsheet to an HTML file was simple with SpreadsheetConverter HTML. We just opened the calculator in Excel and pressed the Convert button in the SpreadsheetConverter ribbon.

Screenshot of the sales tax calculator in Excel

Share the calculator in Dropbox

SpreadsheetConverter offers click-to-publish sharing with Dropbox, a cloud service for file sharing. Dropbox includes enough free storage to hold hundreds of live calculators and web forms. Once we had converted the spreadsheet to web format we could make it immediately available on the web using a Dropbox account as a web server.

Screenshot of the Dropbox Share menu selection in SpreadsheetConverter

If you’re unfamiliar with Dropbox sharing, you may want to read the tutorial on how to publish Excel spreadsheets on the web using Dropbox before you continue.

Copy the Dropbox URL

When we uploaded the calculator to Dropbox, we saved the public link to the calculator, since we intended to use this link to show the calculator in an iframe.



Add an iframe to your web page

With the help of an iframe, we can now show our calculator in almost any other web or blog page. The iframe is a ”viewport” that shows the content of another page.

Open your web page in the Google Sites editor. Put the insertion point where you want the calculator to appear and click on Insert > More gadgets… 

Screenshot of the More gadgets link in the Insert menu in Google Sites

Search for “include iframe”.

Screenshot of the search gadget window in Google Sites

Click on the Include gadget (iframe) in the list.

Screenshot of the Select gadget window in Google Sites

Click on the Select button. This opens the properties panel for the include iframe gadget.

Screenshot of the properties for the insert iframe widget in Google Sites

In the URL to content text box, insert the link to the converted web page in Dropbox. The other settings are optional and allow you to tailor the iframe to your requirements. After you’ve made the necessary adjustments, press OK.

Screenshot of an iframe placeholder in Google Sites

In the web page, you should now see a placeholder representing the iframe.

To view the resulting page, press Save to save the page and leave edit mode.


Viewing the result

When Google Sites displayed the web page with the iframe, we could test the calculator and it worked great. For every new value we entered into the Price field, it automatically calculated new amounts for Total sales tax and Price, just like Excel.

Screenshot of the sales tax calculator in Google Sites

Interested in learning more?

SpreadsheetConverter can publish almost any Excel calculator, chart, spreadsheet or electronic form on the web. For more examples, visit our Examples library.