1. Install Add-on for Google Sheets
To be able to make your website work you need to share your sheet with a link. Anyone with a link a see it (if you will share the link), but no one can edit it. Also it can not be found through Google search.
- Share (top right corner)
- Get shareable link
- Anyone with a link can view
If you already have data in your Google Sheet you can already convert it to the website!
Click on Update Website in the menu and you will get your website link.
Also take a look on Table options. You can hide some columns, add buttons and images or change the colors.
Embed this tableYou can Embed this table to your website.
If you want to have some other tempalte and more customization you can select a template:
Create a new Google Sheet
Add-ons -> Sheet2Site -> Choose Template
Please wait for 20 seconds until a template will finish to copying
If you have data in your sheet just select all, copy and paste to the cards tab.
Change a text in a "Header" tab in the bottom of the spreadsheet to understand how it works.
6. Push changes to your website
Open the link that you saved it previusly. Data will will be updated in 30 sec.
7. Embed to your existing website
If you already have a website and want to embed your spreadsheet data in a visual way you can easily do it by adding a code snippet
Sheet2Site Embed support all major website builders such as Squrespace, Wix, WordPress, Weebly. It aslo support custom website build with code.
It will keep your logo, navigation bar footer. It will be on a separete page like: example.com/directory
How to embed Sheet2Site to your webiste?
Here is how you can create your own embed site with your own data:
- Sheet2Site Google Sheet add-on must be installed
- Template must be created
- Menu Add-ons -> Sheet2Site -> Embed in your website
- Copy code snippet
- Paste it into your website builder as embedded code. Let me know if you need any help.
IF you have troubles of getting website link you can use this alternative method:
Copy the link of your Google Sheet:
And paste it here 👇
Your website will be open in a new window.
Please save the link will not change.
Add-ons -> Sheet2Site -> Show Advanced Settings.
Once you done all of steps above, you can read documentation about what you can do with Sheet2Site