WP Sheet Editor - Custom Tables Pro

Many plugins keep their data in custom tables outside the standard WordPress ones. Think of LMS progress, affiliate statistics, directory listings or redirections. Editing those records usually means a limited screen or hand-written SQL queries. This plugin replaces that with a spreadsheet view for each custom table it finds in your database.

Changes happen live in the cells, so there is no need to export a file, edit it and import it back. You can update many rows at once with bulk tools or formulas, filter by several columns, and move data between plugins or between sites. It is documented to work with LearnDash, AffiliateWP, JReviews and Pretty Links, among other plugins that use custom tables.

Features

• Spreadsheet for every custom table: An editable spreadsheet is generated for each custom table in your database, giving you one familiar place to manage plugin data stored outside the standard WordPress tables.
• Live in-cell editing: Edit values directly in a cell and the change applies to your live site right away, with no import or export cycle needed for everyday updates.
• Bulk editing and formulas: Update hundreds or thousands of rows in one pass using bulk editing tools or formulas, which suits repetitive changes and calculated values.
• Multi-criteria search: Filter records by any combination of columns and conditions, which helps you find exactly the rows you need in a large dataset.
• Spreadsheet file import and export: Bring in data from Excel, Google Sheets or other plugins, and send your table contents out for offline review or for moving to another place.
• Custom column setup: Give columns new names, adjust their widths, and switch cells to checkboxes, dropdowns, file uploads or WYSIWYG editors so data entry matches the content.
• Columns manager: Show, hide, reorder and sort columns so the spreadsheet displays only the fields you are working on.
• Add and duplicate rows live: Create new rows or copy existing ones directly in the sheet, which speeds up data entry and record management.

Best for

• Developers managing plugin data in custom database tables
• Site owners editing LMS, affiliate or directory records
• Administrators migrating large datasets between plugins or sites