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.

Never miss new features!

Join 3000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

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).
This  information will be used to send you newsletters as well as pre-populate any forms, should you want to edit your newsletter preferences.
You can always use this link to unsubscribe from the newsletter. You can see our Privacy Policy here.