The easiest way to import an Excel calculator, live chart or smart form into Squarespace is to use SpreadsheetConverter. This tutorial will show you how to publish live Excel spreadsheets and charts in Squarespace using Publish to Cloud 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 Squarespace blog or website with an iframe.
Most blogs and websites consist of just text and static images. A simple way to make it more interesting is to add a live chart, calculator or web form to it. Help your visitors solve their problems!
With this clever Excel plugin you can also create smart web forms, advanced tables, import interactive charts or open live graphs on your own website.
Before we converted the sales tax calculator spreadsheet to a web page, we had to open it in Excel.
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. We enabled Live Preview to have the web page automatically refreshed every time we saved new changes in Excel.
SpreadsheetConverter offers click-to-publish web hosting with Publish to Cloud, a built-in cloud service that is hosted on the globally distributed Amazon S3 infrastructure with superior performance, extreme reliability and massive scalability. Over a dozen server locations around the globe ensure that your calculator always is within easy reach of your global audience.
Publish to Cloud offers free 7-day test publishing for all users and permanent production publishing for paid users.
Once we had converted the spreadsheet to web format we could upload it to the web by clicking on the Publish to Cloud button on the SpreadsheetConverter ribbon.
One of the most convenient HTML structures is the iframe. Think of an iframe as an embedded window on one web page that shows the content of another web page.
With the help of an iframe, we can embed our calculator web page in almost any other web or blog page.
When the upload to Publish to Cloud finishes, a group of options appears at the bottom of the window. We clicked on the Copy iframe… link to copy the iframe code for the published calculator to the clipboard.
In the iframe code, we can adjust the height and width of the iframe to avoid scrolling. The iframe statement finally looked like this:
<iframe src='https://ssccust1.spreadsheethosting.com/1/59/226a21cef25ec5/Sales_tax_calculator/Sales_tax_calculator.htm' width='960' height='720' border='0' frameborder='0'> <p>Your browser does not support iframes.</p> </iframe>
The iframe technique works just as well regardless of where you have uploaded the converted web page. Just replace the link to the calculator in the example above with a link to where you uploaded your web calculator.
Now we switched to the site in SquareSpace. We made sure we were in Edit mode. Then we clicked on the black balloon-shaped button and got the list of content blocks. We clicked on the Code option.
When we clicked on the Code button, it opened a code dialog which we could move around and there was also some default code.
We removed the default code and pasted the iframe code we copied from the Publish to Cloud dialog into the text area.
As soon as we entered the iframe code, the preview of our calculator was instantly shown. If the content of the calculator hadn’t been fully visible, we would have adjusted the width and height in the iframe code. Finally, we clicked on the Apply button.
We opened the web page in a browser and tested the calculator – it worked great. For every new value we entered into the Price field, it automatically calculated new amounts for Sales tax and Price, just like Excel.
SpreadsheetConverter can publish almost any Excel calculator, chart, spreadsheet or electronic form on the web. For more examples, visit our Examples library.