Duplicate an existing Template, for example the Blank Template Spreadsheet as an start for creating Your own Template. Check out our Templates here.

Following this nameing convention for your templates: $Templatename @Nor

• $ - Short for the money You will be making!
• @Nor - The first 3 letters of your name.
• Templatename - This I will provide you with.

Each sheet within your spreadsheet should be starting with an capital letter and have no spaces. In addition to this...

• The home page should always be called Home
• Any form result tabs should be called Form
• You should take care to name sheets in English and in a logical manner.
• Color Sheets
  
  
  • Main sheet should be green
  • Table sheets should be blue
  • Form sheet should be violet
  • You can use more colors if making sense, for example for grouping of sections
    
    
• You should create new tabs to store big tables – check out Products from $Farmer Shop Template to see an example! Here are a couple of sample names that you might use:
  
  
  • Team
  • Products
  • Conference
  • Contacts
  • Events

If you create new columns, you should use unique, logical titles for each. Here are some example column names you want to use:

• Title
• Subtitle
• Description
• Type ( with Combo Box )
• Link ( with link, websheet link or absolute link https://.. )
• Link Text
• Button Text
• Button Link ( same as Link )
• Image Url ( with FORMULATEXT() or IMAGE() )
• Image Description
• Date
• Price
• Show ( with checkbox )
• Hide ( with checkbox )

Vertical and horizontal table headers should always be in bold.

When creating Named Ranges, remember that new ranges should always be names with the prefix Ws_ Here are some examples you may wish to use:

• Ws_Team
• Ws_Products
• Ws_Conference
• Ws_Contacts
• Ws_Events

Make full use of spreadsheet checkboxes to bring a new level of customization to your site! Find out more about this here

You can make use of comboboxes within your tables to make it easier for your users to select specific items.

Find out more about this here.

Whenever you add a table, think about whether or not a user might want to make use of any filters at all – and add these beforehand to give them a smooth experience!

Add instructions and suggestions! Give your users more information on how to use your template, e.g. add the note into specific cell. Add when possible * symbol to mark that given cell contains an note. Read more on how to do that here.

When setting Rows and Cols Sizes, You should remember that the user should with ease change row order and navigate in the sheet, this may be hard if those size are too big. Still if we have cells with images(min 100px) we should set an size which allows to view them in an good manner. Please use the following sizes for your columns and rows: Sizes [px]:

• 21( Height )
• 60(  Formula Row , Height )
• 100( Image Cell, Height )
• 200
• 300
• 350( Formula Column Width )

You can also make groups to help make your sheet look more appealing for anyone who wishes to use it!

Create sections with clear instructions for your users on how exactly they should fill out the sheet to generate a site as they would like. Just make sure to separate your sections with 10px columns and rows as needed to keep everything formatted well.

You should style your spreadsheet in a similar way to as has been done in the blank template sheet.

All texts should be set to Roboto as a default, Link color into "dark cornerflower blue 2". To change create an custom theme, check out this link. to learn how to set an custom Theme.

The Spreadsheet Default Zoom should be changed into 110%. Check out this link. to learn how to set an custom Zoom value.

Texts should always be left and down-aligned.

All texts dont should be set to Roboto as a default.

All text should normally be 10px.

You should always format text with wrapping on.

Named Ranges may occasionally be copied over when you duplicate sheets. Double check to ensure that all Named Ranges present are needed, and remove any that aren't.

Take a moment to remove any extra columns and rows that aren't needed. Across all sheets and tabs, still You should keep Your row count an multiply of 5. For example 10, 15, 20, 25, 30 and so on. For Page Sheets do in addition same for Block Formula Counters, pleas review $Websheet Guide > Home sheet as example.

The sky's the limit!

I am always open to collaboration to create more advanced spreadsheets. It's also possible to combine with other plug-ins such as Zapier and Glide – and many others!

You can make use of advanced spreadsheet formulas to import dynamic data as well – stock prices and RSS feeds, for example. You can also use Google Forms, Google Charts, and our own Form Blocks to import even more data into your sheets and incorporated into your templates