About this plugin
GSheet Tables turns a public Google Sheet into a searchable, sortable WordPress table. It is useful for member directories, store lists, clinic or pharmacy lists, facility directories, event lists, product catalogs, document indexes, and any data that is easier to maintain in a spreadsheet.
Update your Google Sheet and the table on your WordPress site can show the latest data without rebuilding the page manually. Site owners can manage the source data in Google Sheets, while visitors get a clean table with filters, sorting, pagination, and CSV export.
The plugin uses public CSV export, so there are no Google API keys, OAuth screens, service accounts, or quota setup steps. If your team already manages data in Google Sheets, GSheet Tables keeps the WordPress side simple.
You can also make text clickable by entering links in CSV-friendly formats like:
Label|URL or Label (URL).
Good for
- Member directories and association lists
- Store, branch, clinic, pharmacy, or facility directories
- Event schedules and seminar lists
- Product, price, or service tables
- Document indexes and downloadable resource lists
- Internal data lists maintained by non-technical staff in Google Sheets
Key Features
-
Google Sheets integration
- Display data by providing a public spreadsheet URL
- Tables update automatically when the sheet changes
-
Real-time filtering
- Column-level filters for quick narrowing
- AND search across multiple columns
- Partial or exact match modes
-
Sorting
- Click headers to sort (ascending/descending)
- Automatic numeric column detection
- Sort indicators
-
Pagination
- Choose items per page (10, 25, 50, 100, all)
- Page number navigation
- Previous/Next controls
-
CSV export
- Export filtered and sorted data
- UTF-8 BOM CSV for Excel compatibility
- Export visible columns only
-
Link rendering (CSV-friendly)
- Plain URLs are clickable
- Label|URL or Label (URL) formats for clickable text
- Japanese phone numbers (e.g. 0463-25-1377 ) are auto-linked with tel: for tap-to-call on mobile
- HYPERLINK() and rich-text links are not available in CSV
-
Custom styling
- Border styles (theme, horizontal, vertical, all, none)
- Border width
- Header/cell font sizes
- Color settings (header bg/text, cell bg/text, hover bg)
- Custom CSS
- Theme style inheritance by default
-
Admin features
- Table creation and management
- Default filters
- Visible column selection
- Advanced filters (OR, numeric range, date range)
- Live preview
Use Cases
- Data directories
- Event listings
- Product catalogs
- Member lists
- Document indexes
- News lists
- Statistics tables
- Any dataset managed in Google Sheets
Security
- Nonce validation for all AJAX requests
- Proper capability checks for admin features ( manage_options )
- Sanitization of all user input
- Proper output escaping
Development
- GitHub: https://github.com/doublecracker/gsheet-tables
- ライセンス: GPL v2 or later
Credits
開発者: doublecracker
Support
問題が発生した場合は、GitHubのIssuesページで報告してください。
com/doublecracker/gsheet-tables/issues
Support the Development
GSheet Tables is free and open source. If you find it useful, please consider supporting its development:
- ☕ Buy Me a Coffee
- 💝 GitHub Sponsors
Your support helps maintain and improve this plugin. Thank you!