TablePress

New in 3.19.0 (Pro). Two dispatcher tools work with TablePress (the free edition is enough):

Tool	Default	Purpose
tablepress-read	On	List tables, read a table’s cells and options, export it, see it rendered, find the pages that show it, read the custom CSS
tablepress-write	Off	Create, edit, import, copy, rename and delete tables, set the custom CSS, and place a table on a page

Enable the write tool under Tools > Plugins > TablePress. Each operation needs the TablePress permission it needs in TablePress itself (administrators, editors and authors can edit tables; custom CSS and URL imports need more).

Build a table

1. create-table with a name and the cells as rows. The first row is the header row by default.
2. render-table shows the table as visitors will see it, with formulas such as =SUM(B2:B9) worked out.
3. place-table puts it on a page: the TablePress widget on an Elementor page, the TablePress block on any other page. Shortcode parameters such as hide_columns can go with it.

Change it

edit-cells changes a few cells, insert-rows, delete-rows, insert-columns and delete-columns change the structure, and update-table replaces the whole grid or changes the name, description, visibility and options. Rows and columns are numbered from 1.

Every change names the version of the table it read. If someone changed the table in between, the change is refused and nothing is written, so a newer edit is never lost by accident.

Import and export

import-table reads one CSV, HTML, JSON, XLSX or ODS file, pasted into the call or from a URL, and adds it as a new table, replaces the cells of an existing one, or appends its rows. Archives are refused, and a file can never choose or rename a table. export-table gives CSV, HTML or JSON.

Safe by design

• Users without the unfiltered_html capability get their cells cleaned by TablePress, as in its editor. If a table holds HTML only an administrator may save, they cannot change it at all, because TablePress would strip that HTML from the whole table.
• DataTables custom commands (JavaScript) need the unfiltered_html capability.
• If TablePress leaves a save half done, EMCP puts the table back as it was.

History

Every write is recorded in History and can be undone there: an edit restores the earlier table, a new or copied table is removed, a deleted table comes back under its old id, and an id change is changed back. An undo never overwrites a newer change unless you force it.