Please wait...

Creating Tables in WordPress from Google Spreadsheets with formulas

Here is an example of Google Spreadsheet with some basic formulas. As you can see, in cell I6 we have formula =(H6-G6)/H6). We named this sheet Original data. You can name it however you like, but it is very important to use that name correctly in further step.

In the second sheet, which we named “Copy of data”, in cell A1, write formula =IMPORTRANGE (“link of Original data”, “Original data”!Data range”). Please, write everything as it is written in the function toolbar (including quotation marks and exclamation mark).

As you can see, you will get the same data without formulas, but every time you make some changes in “Original data” sheet, the changes will be reflected in “Copy of data” sheet and in your WpDataTable. All you need to do now is to create a WpDataTable from this source. Please use the URL link from “Copy of data” sheet and not from the “Original data”.

Note: Please don’t apply any formatting in this new sheet. You can make every adjustment that you need in WpDataTables. Also, do not merge cells, wpDataTables doesn’t support merging cells.

Do you have the best

essential plugins installed?
Grab the best 46 plugins. Tested and sorted.

Plugins for SEO, Caching, Security, Design and UX, Stats & analytics, Social sharing. Only the best ones.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).

Thank you for subscribing!

Please check your inbox to download the WordPress goodies.