Flexx Sheet Editor

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

1. Upload the plugin files to the /wp-content/plugins/flexx-sheet-editor directory, or install the plugin through the WordPress plugins screen directly.

2. Activate the plugin through the 'Plugins' screen in WordPress.

3. Access the editor from Tools → Flexx Sheet Editor in your WordPress admin.

Usage

Basic Workflow

1. Select a Post Type - Choose the post type you want to edit from the dropdown
2. Choose Fields - Select which fields you want to display in the spreadsheet
3. Load Data - Click "Load Data" to populate the spreadsheet
4. Edit - Make your changes directly in the spreadsheet
5. Save - Click "Save Changes" to update your posts

Export/Import

Export:

1. Load your data in the spreadsheet
2. Click "Export CSV"
3. The file will download automatically

Import:

1. Select your post type and load the data
2. Click "Import CSV"
3. Select your modified CSV file
4. 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_posts capability
• 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.