forlogos

Copy cells directly from a spreadsheet (such as Google Sheets or Libreoffice Calc) and paste into this block. Spreadsheet cells will be displayed and formatted properly.

Spreadsheet Paste Block

A simple block to display data pasted from a spreadsheet.

Pagecode

This plugin allows you to create tables/sheets easily as an Admin, you can colour code the tables, add up rows and columns, and create unlimited tables for free.
This is a plug and play solution for those who want to show visitors simple tables and only want Admins to edit them. Users can search rows and columns for specific data.
The plugin has no additional options but will work dynamically on any page.
Demo of this plugin can be seen here: <a href="https://sandbox-pagecode-com.pagehost.co.uk/table/" rel="nofollow ugc">Click here</a>
As you can see the table shows a list of data, which was added by an Admin, users can sort through this data with ease, this is a basic spreadsheet.
The table is added to the page with a unique key, each key is a new table/spreadsheet, for example if you want to make a table you would use the shortcode below:
[tablestatistics table=”demo”] this would then show a table, and all data added would be saved under demo.
You could then display this shortcode on any page, or you can create another new table, using a different name.
To colour code your table you can add colorcode=”true” to the shortcode, for example [tablestatistics table=”demo” colorcode=”true”]
Colour coding will check if the number is above 0 or less than 0, if it is above 0, then it will be green, if it is below 0 then it will be red.
If you would like to add up the totals of a row, it will add up all the numbers in that row and ignore any text, use {{total}} in a box at the end.
You can also add up totals of columns using {{total.col}}

Dynamic Datatables

This plugin allows you to create custom tables on the fly. You can make unlimited tables, add new rows, columns or delete them and create formulas to  …

Spreadsheet Paste Block vs Dynamic Datatables