3 min read

Data Tables Plugin for WordPress: Google Sheets, MySQL, Charts and Excel Export

$29.00

Data Tables Plugin for WordPress: Google Sheets, MySQL, Charts and Excel Export

Data Tables Plugin for WordPress: Google Sheets, MySQL, Charts and Excel Export

Turn Google Sheets, JSON APIs, MySQL, posts and WooCommerce into fast, filterable, editable tables.

Your data becomes a live table on your site. Visitors filter, sort, search and export; your team edits cells straight from the front end. Server-side paging keeps big tables fast. One payment, no subscriptions or licence servers.

Fully licensed · One self-contained plugin · No tracking or licence server · Version 1.0.5

Tables Full

What Tables Full does

✔ Google Sheets
Public links, or private sheets through a Google service account, cached with a refresh interval you choose.
✔ JSON APIs
Nested data flattened into columns, list path and an encrypted Authorization header.
✔ MySQL query builder
Pick table, columns, conditions and order. Read-only, admin-only, prepared queries.
✔ Posts and WooCommerce
Post and custom post type tables, and product tables with SKU, price, stock and add-to-cart.
✔ Cascading filters
Dropdown, text and range filters. Choosing a Region narrows the City list.
✔ Conditional formatting
Colour a cell or a whole row with 10 operators.
✔ Formula columns
SUM, AVG, MIN, MAX, ROUND, ABS and IF with a safe parser, never eval.
✔ Master-detail
Click a row to see the full record in an accessible dialog.
✔ Server-side processing
Only the rows on screen load, so tables with thousands of rows stay fast.
✔ Front-end editing
Allowed roles double-click a cell to edit it, with conflict protection.
✔ Excel and PDF export
Generated by the plugin itself, following the visitor’s search, filters and sort.
✔ REST API and webhooks
Full CRUD API plus HMAC-signed webhooks, and folders to organise tables.

How it works

  1. Upload the zip under Plugins > Add New > Upload Plugin and activate it.
  2. Open 007AJ Tables and create a table, or connect a Google Sheet, JSON API, MySQL table, posts or WooCommerce.
  3. Add filters, formatting, formulas and export options.
  4. Place it with the shortcode or the block.
  5. Already using the free 007AJ Tables plugin? Your tables carry over automatically.

Screenshots

Sales pipeline table with filters and coloured status cells
Sales pipeline table with filters and coloured status cells
Google Sheets and other data sources
Google Sheets and other data sources
Cascading filters
Cascading filters
Editing a cell on the front end
Editing a cell on the front end
Master-detail record dialog
Master-detail record dialog
Chart built from a table
Chart built from a table
Spreadsheet-style table editor
Spreadsheet-style table editor
Editor features: merge, formatting, undo and redo
Editor features: merge, formatting, undo and redo
All tables, organised in folders
All tables, organised in folders

Requirements

  • WordPress 6.0 or newer and PHP 7.4 or newer.
  • OpenSSL on the server to store secrets such as API tokens.
  • WooCommerce only if you want product tables.

FAQ

What licence do I get?
Fully licensed version, use on your own sites.
Do I need the free plugin too?
No. Tables Full is one self-contained plugin with the editor, charts, import, shortcode and block built in.
Does it contact outside services?
Only the data sources you configure. No tracking and no licence checks.
Who can use the MySQL builder?
Administrators only, and only on tables you allow. Queries are read-only.

Documentation and support

Read the full Tables Full documentation. For support email admin@007aj.com with your WordPress and PHP versions and the steps to repeat the problem. Never send passwords or API keys.

Tables Full

Turn Google Sheets, JSON APIs, MySQL, posts and WooCommerce into fast, filterable, editable tables. Fully licensed version — use on your own sites. $29 one-time.

$29.00ZIP · 2 MB