#01 Add & Edit Blocks
Blocks Tab
Each page created with Websheet is built with Blocks. You can insert them on your page by adding them into your sheet.
Choose an empty cell in which you wish to insert your Block. On your website, your Blocks are then displayed in the same order as they are in your sheet. If the footer setting is enabled, these Blocks will then be added to the end of your site.
You can review the Blocks available in the Websheet sidebar, or go to blocks.websheet.cc for a more comprehensive overview.
Select Block
To add a Block, simply click on the one you want to use to insert it into the chosen cell.
Edit Block
You can then edit your Blocks at any time with the Block editor. To do so, simply select the cell containing the Block you wish to edit, and select Edit Block in the sidebar.
#02 Pages Explained
Pages Tab
You can manage your pages in the pages tab of the sidebar. Here, we'll look at how to:
  1. Add a page
  2. Change the properties of a page.
  3. Set a page to be your homepage.
Press +
It's very simple to add pages! Just click the icon and select the sheet you would like to convert into a page.
Page Properties
After you've chosen which sheet you want to convert into a page, the page properties for said page will open. Read through the different settings that you can configure and set the values you want. You can then edit your page properties at any time – just click the triple dot icon next to the relevant page and choose Properties.
Set a Homepage
You are free to set any page as your homepage specifically. Just click on the triple dot icon next to the page and select Make Home Page.
Now your pages are good to go – nice and simple!
#03 Site Settings Explained
The site settings view allows you to configure the appearance and general behaviour of your website. Here, we'll briefly explain where to find this and how to navigate inside the settings.
To open site settings, click on the triple dot icon at the top of the sidebar, followed by Site Settings.
In the site settings view, you'll see 6 tabs:
  •   ➔ Adjust the behavior of your menu.
  •  ➔ Set default colors for your Blocks and menu.
  • ➔ Set default fornts for your Blocks and menu.
  • ➔ Upload your logo, set a custom domain and subdomain, and set search engine settings.
  •   ➔ Set up a cookies message and page. Languages
  •  ➔ Add languages to your site – go global!
Please note – changes to site settings are saved inside your spreadsheet. This means if you duplicate your sheet, they'll also be duplicated across.
#04 Add & Style Your Menu
With Websheet, you can add a custom menu to your website. Let's take a quick look at how to add and style a menu here:
Firstly, choose the empty cell in which you wish to insert your menu.
In Blocks in the sidebar, select the menu category and click on WEBMENU01.
Now you can open the menu editor by clicking Edit Block in the sidebar. Here, you can add menu items and set up the linking for your menu.
After you've saved, go to site settings to customize the style for your menu, e.g. colors, effects, and more!
#05 Edit Blocks Extra Usage
Edit Block can be found in the sidebar. Don't let the name fool you – it can be used for more things than just editing the settings for a particular Block! Here we'll look at a couple of these other uses…
Color Picker
If you click on a cell containing a color value (either in rgba or hex format), the Block editor will open with a color picking, allowing you to edit the color specified with ease.
Editing Image
If you edit Block on a cell containing an image formula, you'll open the image formula, allowing you to replace the image should you wish.
Text Editor
If you click on an empty cell or a text cell, the Block editor will open with a text editor. Here, you can enter advanced HTML into the selected cell, which can then be referenced and reused in other Blocks (e.g. list Blocks).
#06 Insert Image Into Cell
Currently the only ways to reference an image is to provide an direct link or to use FORMULATEXT(C10), where CellReference
Insert Image in C2
You can insert an image from the sidebar. Simply click on the top triple dot icon followed by insert image. Once you've selected an image, it will then be inserted into the cell you've currently selected.
File Browser
You will now be asked to upload or browse, which will open an modern file picker where You can upload Your files into directories or select an already uploaded image.
You will now need FORMULATEXT() formula with refence to the IMAGE() formula cell. This gives you a preview of the image and a valid url for referencing inside blocks in the next cell. Here shown in D2.
#07 My Projects Explained
The publish controller helps you to review all the sites published with Websheet.

You can open Publish Control by clicking on the top triple dot icon in the sidebar. Here, you'll be able to:
Unpublish any of your websites, which will also mean they are deregistered with our system. Pause or unpause automatic updates for your sites. Find the url of a spreadsheet or connected website should you need to find these.
#08 Import Template
A template is a spreadsheet that we have created for you to use as a basis for your site with Websheet. We already have a whole range of templates ready for you to use, modify, or draw inspiration from! To see a list of all templates, check out templates.websheet.cc and once you have found one that fits your needs, click on the link to open it.

There are 3 ways of using a template – we'll walk you through the options briefly here:
Make a Copy
A) Duplicate the entire spreadsheet.

This will copy the whole template, including the site settings – and is usually the way we would recommend. To do this:

  1. After opening the sheet containing your template, go to File, and then select Make a Copy.
  2. In your copied sheet, open Websheet from the Add-ons menu.
  3. Click Launch in order to register your sheet.
  4. You should now see a dialog prompting you to review your template.
  5. Use to adjust the template however you need.
  6. Use Site Settings to upload your own logo and set up your site with your own custom domain.
Sheet Copy
B) Only copy the sheets.

1. Open the sheet you want to copy, and right click on the tab for that sheet specifically.
2. Then choose copy to. You can set up another sheet before hand to copy the sheet to.
3. Choose the destination. Then you'll need to add the new sheet to your spreadsheet.
4. You may need to fix the references within the copy sheet manually using the editor.
Copy Cells
C) Only copy selected cells or rows.

1. Choose the cell or cells you would like to copy.
2. Copy them as you usually would using ctrl + C.
3. Paste them into your own sheet using ctrl + V. Remember – you should be copying formulas rather than values!
4. You may need to fix the references within the copy sheet manually using the editor.
#09 Expression Mode Explained
Let's refence D10
Tool Icon > Expression Mode
Expression Mode
Enter Formula
Block using Reference
#10 How to Refence a Table
Example Table
Select Table & Add a Range
Inserting WEBPLAN10
Tool Menu
Matching Rules
Matching Columns
Table Online
Expression Mode
#11 Websheet Formulas
Formula Cat.
#12 Text Styling
Clear up styling
#13 Defined Color Ranges
#14 Translations
Websheet's mission is to help you easily create the website of your dreams. Explore the thousands of possibilities.