Custom Database Tables Spreadsheet
Manage Custom Database Tables with a Spreadsheet
No import/export needed. All the changes apply live on the website.
Edit Custom Tables added by Plugins
In WordPress, you have the standard database tables where the posts, pages, products, user accounts, taxonomies, and comments are stored.
However, many plugins add custom database tables for storing information without slowing down the WordPress site. For example:
– LMS plugins save courses and user progress in custom tables (LearnDash, LearnPress, TutorLMS)
– Affiliate systems save affiliate data, clicks, and statistics in custom tables (AffiliateWP)
– Forum plugins save threads and forums in custom tables
– Directory plugins usually save listings and meta data in custom tables, and many more plugins
Usually you can edit the standard information using our WP Sheet Editor plugin or other plugins. But the custom tables added by other plugins are very difficult to edit. You are forced to use ugly and tedious interface that come with those plugins.
A Spreadsheet created especially for all the Custom Tables
Say goodbye to all the limitations. We have created a WordPress plugin to solve that problem.
Our plugin will generate a spreadsheet editor for every custom table found in your database where you can manage all the information quickly, make advanced searches, bulk edit thousands of items, migrate from one site to another, etc.
Use cases
LearnDash, LearnPress, TutorLMS
Use a spreadsheet to manage the User Activity and Progress. You can edit quickly, search by multiple fields and using multiple conditions, export and import, and more.
AffiliateWP and other Affiliate Systems
Manage the affiliate system statistics using a spreadsheet, where you can view and search clicks, referrals, etc.
You can bulk edit all the information, import from Excel, export to Google Sheets or Excel to analyze the data, make advanced searches, and more.
Directory plugins
Many directory plugins like JReviews, etc. save listings and meta data using custom tables.
You can use our spreadsheet editor to export information to Excel or Google Sheets, bulk delete, you can search by any field with operators, you can import information from other directory plugins, etc.
SEO, Redirections, Pretty links plugins
Use our spreadsheet to manage the redirections easily. Search by any field, export to Google Sheets or Excel, import from Excel or Google Sheets, bulk edit and delete, Migrate redirections from one site to another, etc.
And many more use cases… hundreds of plugins save information in custom database tables.
Our plugin is a universal solution for managing all the custom database tables with a spreadsheet editor.
- This plugin generates one spreadsheet for every custom database table.
- This plugin works with custom tables, it doesn’t include standard tables because we have other WP Sheet Editor plugins with special support for standard tables, like the Posts spreadsheet, Users, Taxonomies, Media library, etc.
- All the usual features of WP Sheet Editor work with the custom tables including: Live Editing in the Cells, advanced search, bulk edit, formulas, export, import, bulk duplicate, columns manager, columns formatting, etc.
Powerful bulk editor for your information
You can edit hundreds or thousands of rows at once. It’s super fast.
Live Editing in the Cells
Create or import new rows quickly
Move all the information from one column to another at once
Replace words or phrases in multiple columns in bulk
Bulk Delete thousands of rows quickly
Migrate information from one plugin to another or between sheets
Export to Excel or Google Sheets, Generate Reports
Import from other sites or other plugins in the same site
Powerful Formulas system for advanced edits
Columns manager to customize cell formatting and labels for easy edits
Add new rows live
Copy paste between sheets live
General Features
- All the custom tables: The plugin generates one spreadsheet for every custom table found in your database.
- Edit information that was inaccessible: You can edit statistics, course progress, etc. that you can’t usually do in wp-admin.
- Move information between plugins: You can copy paste large amounts of cells from one sheet to another.
- Unlimited data: The Spreadsheet supports hundreds of thousands of rows, hundreds of columns, etc.
- Bulk edit data:You can edit data in the cells or using a powerful bulk edit feature with formulas.
- Columns Visibility: You can remove, deactivate, display, and sort columns.
- Formulas: You can update thousands of rows at once using formulas.
- Advanced search: You can find information by any combination of columns using operators.
- Columns resizing: You can resize columns.
- Columns renaming: You can rename columns.
- Columns formatting: You can change the cell format from text to checkbox, tinymce editor, file uploader, dropdown selector, etc.
We Support Large Websites
The plugin is very efficient with your server resources.
It loads only on wp-admin. It doesn’t affect the speed of your site.
You can load thousands of rows in the spreadsheet without issues.
You can control the number of rows to save per batch. i.e. 3 rows every 20 seconds.
You can control the time to wait between batches when saving changes. i.e. 3 rows every 60 seconds.
It saves only the modified cells in the spreadsheet. For example, you can load 500 rows, edit 3 fields, and it saves only 3 fields.
Here are some screenshots:
