Flexx Sheet Editor self-updates
A lightweight, professional WordPress plugin for editing all post type contents (including Pods CPTs) in a spreadsheet-like interface with CSV export/import capabilities.
by Christos Kanotidis · github.com/christoskaterini/flexx-sheet-editor · website
Install
No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:
wp plugin install https://github.com/christoskaterini/flexx-sheet-editor/archive/refs/heads/main.zipShips its own WordPress updater (Plugin Update Checker), so new versions show up under Dashboard → Updates.
A lightweight, professional WordPress plugin for editing all post type contents (including Pods CPTs) in a spreadsheet-like interface with CSV export/import capabilities.
Features
✨ Spreadsheet Interface - Edit your WordPress posts in a familiar Excel-like interface.
📊 All Post Types - Works with standard WordPress post types and custom post types from:
- Pods
- Advanced Custom Fields (ACF)
- Meta Box
- Any custom post type
🖼️ Featured Images & Media - Manage featured images and media fields
🔒 Secure - Built with WordPress security best practices:
- Nonce verification
- Capability checks
- Input sanitization
- XSS protection
📤 Export to CSV - Export your data to CSV format for offline editing or backup
📥 Import from CSV - Bulk update posts by importing modified CSV files
🎨 Professional Design - Clean, modern interface that integrates seamlessly with WordPress admin
⚡ Zero Dependencies - Pure PHP/JavaScript, no external libraries required
Requirements
- WordPress 5.8 or higher
- PHP 7.4 or higher
Installation
-
Upload the plugin files to the
/wp-content/plugins/flexx-sheet-editordirectory, or install the plugin through the WordPress plugins screen directly. -
Activate the plugin through the 'Plugins' screen in WordPress.
-
Access the editor from Tools → Flexx Sheet Editor in your WordPress admin.
Usage
Basic Workflow
- Select a Post Type - Choose the post type you want to edit from the dropdown
- Choose Fields - Select which fields you want to display in the spreadsheet
- Load Data - Click "Load Data" to populate the spreadsheet
- Edit - Make your changes directly in the spreadsheet
- Save - Click "Save Changes" to update your posts
Export/Import
Export:
- Load your data in the spreadsheet
- Click "Export CSV"
- The file will download automatically
Import:
- Select your post type and load the data
- Click "Import CSV"
- Select your modified CSV file
- The plugin will update all posts with matching IDs
Note: Import only updates existing posts. The ID column must match existing post IDs.
Supported Field Types
- Text fields
- Textareas
- HTML/WYSIWYG content
- Numbers
- Dates and datetimes
- Dropdowns/Select fields
- Checkboxes/Booleans
- Email addresses
- URLs
- Custom fields from Pods, ACF, and Meta Box
Security Features
- Nonce Verification - All AJAX requests are protected with WordPress nonces
- Capability Checks - Users must have
edit_postscapability - Input Sanitization - All user input is sanitized based on field type
- File Validation - Uploaded files are validated for type, size, and MIME type
- XSS Protection - All output is properly escaped
- SQL Injection Prevention - Uses WordPress prepared statements
Technology Stack
Backend:
- PHP 7.4+
- PHPSpreadsheet (MIT License) - XLSX processing
- WordPress APIs
Frontend:
- Jspreadsheet CE v4 (MIT License) - Spreadsheet UI
- jSuites (MIT License) - UI components
- Vanilla JavaScript (ES6+)
- Custom CSS with WordPress admin integration
Frequently Asked Questions
Can I edit custom post types?
Yes! The plugin automatically detects all registered post types, including those created by Pods, ACF, or custom code.
Can I edit custom fields?
Yes! The plugin supports custom fields from:
- Pods
- Advanced Custom Fields (ACF)
- Meta Box
- Standard WordPress post meta
Is there a limit on the number of posts?
The spreadsheet uses pagination (default: 50 posts per page) to handle large datasets efficiently. You can adjust this in the spreadsheet controls.
Can I create new posts via import?
Currently, the import feature only updates existing posts. Creating new posts via import will be added in a future version.
What file formats are supported for import/export?
Currently, CSV (.csv) format is supported for both import and export.
License
This plugin is licensed under the GPL v2 or later.
Third-party Libraries:
- Jspreadsheet CE - MIT License
- jSuites - MIT License
- PHPSpreadsheet - MIT License
Support
For bug reports and feature requests, please use the GitHub repository issues page.
Credits
Developed with ❤️ using best practices and open-source libraries.