GSheet Tables

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ページで報告してください。 https://github.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!