How to Embed Google Sheet in WordPress

If you have an existing WordPress website and you want to embed your Google Sheet data onto it, this article will explain how you can do you exactly step by step.

Follow these 3 simple steps:

1. Share Your Google Sheet
2. Install Sheet2Site Wordpress Plugin
3. Embed a Google Sheet Onto Wordpress Website

For example, you have a pricing table in a Google Sheet that looks like this:

After you will have a beautiful responsive table that can be embed to your WordPress website:

1. Share your Google Sheet

Open your Google Sheet that you would like to embed into your website

1. Share your Google Sheet
2. Share (top right corner)
3. Anyone with a link can view

For embedding Sheet2Site will use your first left sheet (tab). If you would like to embed another sheet, simply drag and drop this particular sheet to the left side to make the first.

2. Install Sheet2Site WordPress Plugin

Sheet2Site WordPress Plugin was made exactly for this purpose. It will embed your Google Sheet to the WordPress website page and keep update it automatically.

1. Open your WordPress Dashboard
2. Select a Plugins tab on the left
3. Add New
4. Search for Sheet2Site

3. Embed a Google Sheet onto WordPress Website

Now let's embed Google Sheet to your WordPress website. Here is what you need to do:

1. Create a new page from your WordPress Dashboard: Pages - Add New

2. Add new block -> shortcode

3. Copy your Google Sheet ID

You can copy it from your browser address bar:

4. Paste this code:

[sheet2site key=1IxTGBbsRrSZAQ88EDh2kAqpL4iT3NceSSRBzv7_0vT8]

5. Publish your Word Press page:

Click Publish and once again Publish to confirm

You should see embedded Google Sheet in your WordPress website:

Done!

After this step your Google Sheet will be embed into your Website.

---

Advanced Table Options

You can cusomize your embedded Google Sheet on your WordPress website with some advanced feature such as images, links, call to action buttons, sorting, filters and search. Here is how you can do it:

Images

If you want to add an image to your Google Sheet and showing it on your Word Press website you can just upload the image to any free photo sharing hosting even Google Drive will work. Most important that this link has an image format name, in the end, .jpeg, jpg, png.

Links

To be able to display a clickable link in your table, simply add a link to a particular cell has http, https, or mailto in the start. It will be shown as a clickable link with a highlighted color.

Call to Action Buttons

You can change links to beautiful looking buttons on your WordPress website. Just rename your column to a Learn More-Button and a button for each cell of the column.

Hide Columns of your Google Sheet

If you would like to hide some columns from your embed Google Sheet you can add -Hide to a particular column that you would like to hide. Might be useful for some calculations. Example of how you need to name a column header: Current Year-Hide

Search

One of most important feature of any table is a search. Search functionality is incuded by default. Searching is executing by default throught all cells in the sheet. If the data exist in any cell it will be shown.

Default Sorting

When the user loads the website, the initial sorting of the table is the same as in your Google Sheet. If you will change the sorting in your Google Sheet, the website's table sorting will change as well

Sorting by a speficic column

Each column can be sorted separately when you click on the Table's header. The data type of the column is recognizing by default. Current types that are supported:

• String
• Date: 2020-03-21
• Number: 20000 or 20,000
• Currency: $100,000
• Percent: 40%