How to Create a Leaderboard Table from Google Sheets in WordPress

Using WordPress Plugin – Stylish Google Sheets Reader

Want to display a dynamic leaderboard on your WordPress site using a spreadsheet? With the Stylish Google Sheets Reader plugin, you can easily transform a Google Sheet into a visually rich, responsive DataTable — complete with player images, medals, scores, and star ratings.

In this post, we'll demonstrate this using a public Google Spreadsheet containing 30+ player records.

Example Spreadsheet (Leaderboard tab):
View Google Sheet

📌 Supported Enhancements with Shortcodes

This plugin supports shortcodes in Google Sheet headers to convert plain text links into images, ratings, and other visual content on the frontend.

⚠️ Note:

• The plugin only processes plain URLs, not embedded hyperlinks or formulas from Google Sheets.
• Shortcodes are visible only in the spreadsheet, not in the frontend table.

Here’s how we applied shortcodes in the sheet headers:

Original Column Name	Modified Header (with Shortcode)
Medal	Medal [sgsr-image w="50"]
Headshot	Headshot [sgsr-image w="50"]
Rating	Rating [sgsr-rating total="5" fill="#ffcc00"]

These shortcode attributes control how the content appears:

• w – Sets image width in pixels.
• total – Defines the maximum rating (e.g., out of 5 stars).
• fill – Sets the star color.

Need the full list of shortcodes and usage examples? View All Shortcodes & Guide

💡 If your data is in Excel format (.xlsx or .xls), upload it to Google Drive, right-click the file, and select “Open with → Google Sheets”. Once it opens, go to the menu and choose File → Save as Google Sheets. Then use the URL of the newly created Google Sheet in the plugin configuration.

📌 Google Sheet Configuration Used

• Sheet Name: Leaderboard
• Range: A:E
• Use First Row as Headers: ✅ Yes
• Frontend Output: Paginated, sortable leaderboard table with images and ratings

📌 Final Output Preview (Frontend Table)

This is how the leaderboard table looks when rendered on your WordPress site using the plugin:

📌 Benefits of Using Stylish Google Sheet Reader

• Keeps original Google Sheets hidden — users only see the rendered table, not your backend data source
• Automatically syncs live leaderboard data from Google Sheets
• Responsive layout works great on all devices
• Supports player images, medal icons, and custom ratings
• Perfect for contests, competitions, rankings, and eLearning

Need Similar DataTable Functionality for Wix, Squarespace, or Shopify?

If you're building on a platform other than WordPress — like Wix, Squarespace, or Shopify — you can still enjoy the same great DataTable features.

Get exclusive access to our cloud-based app that mirrors the exact functionality of the Stylish Google Sheet Reader plugin. Use it to connect your Google Sheets and generate clean, responsive HTML embed codes that work on any website or CMS.

Try the Cloud App