{"id":2834,"date":"2025-08-02T21:14:08","date_gmt":"2025-08-02T21:14:08","guid":{"rendered":"https:\/\/wppluginbox.com\/en\/?p=2834"},"modified":"2025-08-03T19:27:54","modified_gmt":"2025-08-03T19:27:54","slug":"create-datatable-from-google-sheets","status":"publish","type":"post","link":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/","title":{"rendered":"How to Create a Stocks DataTable from Google Sheets in WordPress"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2834\" class=\"elementor elementor-2834\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7fe5b84d elementor-section-full_width cexpress-header elementor-section-height-default elementor-section-height-default\" data-id=\"7fe5b84d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-466651b3\" data-id=\"466651b3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1bf176 express-header-img elementor-widget elementor-widget-image\" data-id=\"1bf176\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\/\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1454\" height=\"1282\" src=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\" class=\"attachment-full size-full wp-image-2461\" alt=\"WP Plugin Box Brand Logo\" srcset=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg 1454w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-300x265.jpg 300w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-1024x903.jpg 1024w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-768x677.jpg 768w, https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2-1200x1058.jpg 1200w\" sizes=\"(max-width: 1454px) 100vw, 1454px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-3680ee1\" data-id=\"3680ee1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-462c30c0 elementor-widget elementor-widget-shortcode\" data-id=\"462c30c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">\n<!-- Desktop Menu -->\n<nav class=\"custom-menu\">\n  <ul>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/\">Home<\/a><\/li>\n    <li class=\"has-mega-menu\">\n      <a href=\"#\">Our Plugins \u25be<\/a>\n      <div class=\"mega-menu\">\n        <div class=\"mega-column\">\n          <h4>WordPress Plugins<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\">Stylish Google Sheet Reader<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\/\">Smart Mortgage Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-loan-calculator\/\">Smart Loan Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/home-affordability-calculator\/\">Home Affordability Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-investment-calculator\/\">Smart Investment Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/sell-btc-by-hayyatapps\/\">Sell BTC Pro<\/a><\/li>\n                          <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-order-form-builder\/\">Stylish Order Form Builder<\/a><\/li>\n                      <\/ul>\n        <\/div>\n\n        <div class=\"mega-column\">\n          <h4>Pricing<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\">Smart Mortgage Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-loan-calculator-pro-pricing\">Smart Loan Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/home-affordability-calculator-pro-pricing\">Home Affordability Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-investment-calculator-pro-pricing\">Smart Investment Calculator<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/sell-btc-pro-pricing\">Sell BTC Pro<\/a><\/li>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-order-form-builder-pro-pricing\">Stylish Order Form Builder<\/a><\/li>\n                      <\/ul>\n        <\/div>\n\n        <div class=\"mega-column\">\n          <h4>Documentation<\/h4>\n          <ul>\n                          <li><a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader <\/a><\/li>\n                      <\/ul>\n        <\/div>\n      <\/div>\n    <\/li>\n\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/our-portfolio\">Our Portfolio<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/contact-us\">Contact Us<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/plugin-support\">Plugin Support<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/blog\">Blog<\/a><\/li>\n\t<\/ul>\n<\/nav>\n\n<!-- =========== Mobile Nav ============ -->\n<div style=\"display: flex; justify-content: flex-end;\">\n  <div class=\"mobile-menu-toggle\" onclick=\"document.querySelector('.mobile-menu').classList.toggle('open')\">\n    <i class=\"fas fa-bars\"><\/i> Menu\n  <\/div>\n<\/div>\n\n<nav wpbox-custom-menu=\"1\" class=\"mobile-menu\">\n  <ul>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/\"><i class=\"fas fa-home\"><\/i> Home<\/a><\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fab fa-wordpress\"><\/i> Our Plugins <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\">Stylish Google Sheet Reader<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\/\">Smart Mortgage Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-loan-calculator\/\">Smart Loan Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/home-affordability-calculator\/\">Home Affordability Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/smart-investment-calculator\/\">Smart Investment Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/sell-btc-by-hayyatapps\/\">Sell BTC Pro<\/a><\/li>\n                      <li><a href=\"https:\/\/wordpress.org\/plugins\/stylish-order-form-builder\/\">Stylish Order Form Builder<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fas fa-tags\"><\/i> Pricing <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smc-pro-pricing\">Smart Mortgage Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-loan-calculator-pro-pricing\">Smart Loan Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/home-affordability-calculator-pro-pricing\">Home Affordability Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/smart-investment-calculator-pro-pricing\">Smart Investment Calculator<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/sell-btc-pro-pricing\">Sell BTC Pro<\/a><\/li>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/stylish-order-form-builder-pro-pricing\">Stylish Order Form Builder<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li>\n      <details>\n        <summary><i class=\"fas fa-book\"><\/i> Documentation <i class=\"fas fa-sort-down\"><\/i><\/summary>\n        <ul>\n                      <li><a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\">Stylish Google Sheet Reader Docs<\/a><\/li>\n                  <\/ul>\n      <\/details>\n    <\/li>\n\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/our-portfolio\"><i class=\"fas fa-briefcase\"><\/i> Our Portfolio<\/a><\/li>\n    <li><a href=\"https:\/\/wppluginbox.com\/en\/contact-us\"><i class=\"fas fa-envelope\"><\/i> Contact Us<\/a><\/li>\n\t  \n<li><a href=\"https:\/\/wppluginbox.com\/en\/plugin-support\"> <i class=\"fas fa-plug\"><\/i> Plugin Support<\/a><\/li>\n\n<li><a href=\"https:\/\/wppluginbox.com\/en\/blog\"> <i class=\"fas fa-lightbulb-on\"><\/i> Blog<\/a><\/li>\n\n\t  \n  <\/ul>\n<\/nav>\n<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d0cf8e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d0cf8e2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7659e43\" data-id=\"7659e43\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f740d62 elementor-widget elementor-widget-html\" data-id=\"f740d62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<link rel=\"stylesheet\" type=\"text\/css\" href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/style.css\">\r\n\r\n<div class=\"blog-container\">\r\n\r\n  <h2>How to Display Stock Data from Spreadsheets as Responsive DataTables<\/h2>\r\n  <h3>Using WordPress Plugin \u2013 Stylish Google Sheets Reader<\/h3>\r\n\r\n  <p>Want to showcase dynamic stock market data on your website using a spreadsheet?\r\n  With the <strong><a href=\"https:\/\/wordpress.org\/plugins\/stylish-google-sheet-reader\/\" target=\"_blank\">Stylish Google Sheets Reader <i class=\"fas fa-external-link\"><\/i><\/a><\/strong> WordPress plugin, you can convert a Google Sheet into a clean,\r\n  sortable, searchable, and responsive <strong>DataTable<\/strong> \u2014 without writing code.<\/p>\r\n\r\n  <p>In this post, we'll demonstrate this using a <strong>public Google Spreadsheet<\/strong> containing 50+ stock entries.<\/p>\r\n\r\n<center>\r\n<div style=\"margin:50px;\">\r\n  <p>\r\n  <strong>Example Spreadsheet (Stocks tab):<\/strong><br>\r\n  <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ljvtNZ87Dl0Cmm-xDaIx4YuSdr6Oo8zLFeXJWgjVxeE\/edit#gid=2075646135\" target=\"_blank\" class=\"sgsr-btn-link\">\r\n     View Google Sheet <i class=\"far fa-external-link\"><\/i>\r\n  <\/a>\r\n<\/p>\r\n<\/div>\r\n<\/center>\r\n\r\n\r\n<center>\r\n<div style=\"margin:50px;\">  \r\n<a href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/stock_sheet.png\" data-lightbox=\"post-images\">\r\n  <img decoding=\"async\" class=\"example-img\" src=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/stock_sheet.png\" alt=\"Google Sheet Stocks Data Example\">\r\n<\/a>\r\n<\/div>\r\n<\/center>\r\n\r\n\r\n  <h3>\ud83d\udccc Supported Enhancements with Shortcodes<\/h3>\r\n\r\n  <p>\r\n    This plugin supports <strong>shortcodes in Google Sheet headers<\/strong> to convert plain text links (such as image URLs or hyperlinks)\r\n    into rich frontend content like images or formatted values.\r\n  <\/p>\r\n\r\n  <p><strong>\u26a0\ufe0f Note:<\/strong><\/p>\r\n  <ul>\r\n    <li>The plugin only processes <em>plain URLs<\/em>, not embedded hyperlinks or formulas from Google Sheets.<\/li>\r\n    <li>Shortcodes are visible only in the spreadsheet, not in the frontend table.<\/li>\r\n  <\/ul>\r\n\r\n  <p>Here\u2019s how we applied shortcodes in the sheet headers:<\/p>\r\n\r\n  <table class=\"scode\">\r\n    <thead>\r\n      <tr>\r\n        <th>Original Column Name<\/th>\r\n        <th>Modified Header (with Shortcode)<\/th>\r\n      <\/tr>\r\n    <\/thead>\r\n    <tbody>\r\n      <tr>\r\n        <td>Brand Logo<\/td>\r\n        <td><code>Brand Logo [sgsr-image w=\"50\"]<\/code><\/td>\r\n      <\/tr>\r\n      <tr>\r\n        <td>Change (%)<\/td>\r\n        <td><code>Change (%) [sgsr-updown criteria=\"0\"]<\/code><\/td>\r\n      <\/tr>\r\n      <tr>\r\n        <td>Trend<\/td>\r\n        <td><code>Trend [sgsr-hide]<\/code><\/td>\r\n      <\/tr>\r\n      <tr>\r\n        <td>Trend Logo<\/td>\r\n        <td><code>Trend Logo [sgsr-image w=\"50\"]<\/code><\/td>\r\n      <\/tr>\r\n    <\/tbody>\r\n  <\/table>\r\n\r\n<p>\r\n  The <code>[sgsr-hide]<\/code> shortcode hides a column from the frontend output.  \r\n  In the example, the <strong>Trend<\/strong> column is hidden, while conditional logic in the Google Sheet is used to generate up\/down values, which are shown as icons in the <strong>Trend Logo<\/strong> column.\r\n<\/p>\r\n\r\n<p>\r\n  Key shortcode attributes and their functions:\r\n<\/p>\r\n<ul>\r\n  <li><strong>w<\/strong> \u2013 Sets the image width in pixels (used with <code>[sgsr-image]<\/code>).<\/li>\r\n  <li><strong>criteria<\/strong> \u2013 Defines the threshold for showing up\/down indicators in <code>[sgsr-updown]<\/code>. For example, <code>criteria=\"0\"<\/code> shows an up arrow if the value is greater than 0 and a down arrow if less.<\/li>\r\n  <li><strong>total<\/strong> \u2013 Defines the maximum rating value (e.g., out of 5 stars in <code>[sgsr-rating]<\/code>).<\/li>\r\n  <li><strong>fill<\/strong> \u2013 Sets the star fill color for ratings (e.g., <code>#ffcc00<\/code> for yellow stars).<\/li>\r\n<\/ul>\r\n\r\n\r\n  <blockquote>\r\n  Need the full list of shortcodes and usage examples?\r\n  <a href=\"https:\/\/wppluginbox.com\/en\/documentation-stylish-google-sheet-reader-pro\/\" target=\"_blank\" class=\"sgsr-btn-link\">\r\n    View All Shortcodes & Guide <i class=\"far fa-external-link\"><\/i>\r\n  <\/a>\r\n<\/blockquote>\r\n\r\n  <blockquote>\r\n  \ud83d\udca1 <strong>If your data is in Excel format (.xlsx or .xls)<\/strong>, upload it to Google Drive, right-click the file,\r\n  and select \u201cOpen with \u2192 Google Sheets\u201d. Once it opens, go to the menu and choose <strong>File \u2192 Save as Google Sheets<\/strong>.\r\n  Then use the URL of the newly created Google Sheet in the plugin configuration.\r\n<\/blockquote>\r\n\r\n\r\n\r\n  <h3>\ud83d\udccc Google Sheet Configuration Used<\/h3>\r\n\r\n  <ul>\r\n    <li><strong>Sheet Name:<\/strong> <code>stocks<\/code><\/li>\r\n    <li><strong>Range:<\/strong> <code>A:H<\/code><\/li>\r\n    <li><strong>Use First Row as Headers:<\/strong> \u2705 Yes<\/li>\r\n    <li><strong>Frontend Output:<\/strong> Searchable, sortable, paginated stock table<\/li>\r\n  <\/ul>\r\n\r\n  \r\n<center>\r\n<div style=\"margin:50px;\">  \r\n<a href=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/stock_sheet_settings.png\" data-lightbox=\"post-images\">\r\n  <img decoding=\"async\" class=\"example-img\" src=\"https:\/\/wppluginbox.com\/docs\/stylish-google-sheet-reader-pro\/examples\/stock_sheet_settings.png\" alt=\"Google Sheet Config\">\r\n<\/a>\r\n<\/div>\r\n<\/center>\r\n\r\n  <h3>\ud83d\udccc Final Output Preview (Frontend Table)<\/h3>\r\n\r\n  <p>This is how the stock data looks when rendered on your WordPress site using the plugin:<\/p>\r\n\r\n  \r\n  <div class=\"shortcode-preview\">\r\n    \r\n<style type=\"text\/css\">\r\n  body{\r\n\/*    background-color: black!important;*\/\r\n  }\r\n\r\n  \r\n<\/style>\r\n\r\n<div sgsr-tab-section=\"1\" \r\nsgsr-center-txt=\"1\" \r\ntable-id=\"3\" \r\ntable-config='{&quot;no&quot;:&quot;3&quot;,&quot;project_uid&quot;:&quot;7x23b1iXlQPw1P38&quot;,&quot;sheet_id&quot;:&quot;1ljvtNZ87Dl0Cmm-xDaIx4YuSdr6Oo8zLFeXJWgjVxeE&quot;,&quot;tab_name&quot;:&quot;stocks&quot;,&quot;range&quot;:&quot;A:H&quot;,&quot;enable_search&quot;:&quot;1&quot;,&quot;enable_sorting&quot;:&quot;1&quot;,&quot;enable_data_export&quot;:&quot;0&quot;,&quot;enable_auto_refresh&quot;:&quot;0&quot;,&quot;auto_refresh_duration&quot;:&quot;15&quot;,&quot;shadow_style&quot;:&quot;s-n&quot;,&quot;theme&quot;:&quot;white&quot;,&quot;header_color&quot;:&quot;#6d78f2&quot;,&quot;header_text_color&quot;:&quot;#ffffff&quot;,&quot;custom_scrollbar&quot;:&quot;0&quot;,&quot;responsive&quot;:&quot;1&quot;,&quot;max_table_height&quot;:&quot;scrollable&quot;,&quot;enable_paging&quot;:&quot;1&quot;,&quot;page_length&quot;:&quot;10&quot;,&quot;enable_cache&quot;:&quot;0&quot;,&quot;cache_duration&quot;:&quot;5m&quot;,&quot;enable_form&quot;:&quot;0&quot;,&quot;form_main_heading&quot;:&quot;Submit Your Details&quot;,&quot;form_sub_heading&quot;:&quot;Please fill in the required details below and submit the form.&quot;,&quot;enable_row_selection&quot;:&quot;0&quot;,&quot;thank_you_msg&quot;:&quot;Thank you for your submission.&quot;,&quot;submission_email&quot;:&quot; &quot;,&quot;form_fields&quot;:&quot;&quot;}'\r\nsgsr-card=\"s-n\"\r\nsgsr-paging=\"1\" \r\nsgsr-scroll=\"scrollable\"\r\n>\r\n<!-- style=\"display: none;\">  -->\r\n<!-- ----------------------------------------------------------------- -->\r\n<div class=\"sgsr-render-error\"><\/div>\r\n<div><p class=\"sgsr-refresh sgsr-flash\"><i class=\"fas fa-sync-alt\"><\/i> Refreshing<\/p><\/div>\r\n<div class=\"sgsr-mob-msg\"><p class=\"sgsr-swipe\">Swipe sideways to see full table <i class=\"fas fa-arrows-alt-h\"><\/i><\/p><\/div>\r\n\r\n<div class=\"searc-box\">\r\n  \r\n  <input type=\"text\" class=\"searchInput\" placeholder=\"Search...\">\r\n\r\n  <!-- NEW DROPDOWN -->\r\n    <div class=\"sgsr-search-col-div\">\r\n    <select class=\"searchColumn\">\r\n        <option value=\"all\">Search All Columns<\/option>\r\n    <\/select>\r\n  <\/div>\r\n\r\n<\/div>\r\n\r\n<div class=\"sgsr-responsivess\" sgsr-card=\"0\" sgsr-tab-div=\"1\">\r\n<table sgsr-table=\"1\">\r\n  <thead>\r\n    <tr class=\"headerRow\"><\/tr>\r\n  <\/thead>\r\n  <tbody><tr><td>Loading data...<\/td><\/tr><\/tbody>\r\n<\/table>\r\n\r\n<div><p data-sgsr=\"b\"><\/p><\/div>\r\n<\/div>\r\n\r\n\r\n<div class=\"pagination-controls\" style=\"display: none;\">\r\n  <div class=\"sgsr-group-left\">\r\n    <button class=\"prevPage\">Prev<\/button>\r\n    <span class=\"pageInfo\"><\/span>\r\n    <button class=\"nextPage\">Next<\/button>\r\n  <\/div>\r\n\r\n  <div class=\"sgsr-group-center sgsr-inline-group\">\r\n    <label for=\"gotoPage\">Go to Page:<\/label>\r\n    <select class=\"gotoPage\"><\/select>\r\n  <\/div>\r\n\r\n  <div class=\"sgsr-group-right sgsr-inline-group\">\r\n    <label for=\"rowsPerPage\">Rows \/ Page:<\/label>\r\n    <select class=\"rowsPerPage\">\r\n      <option value=\"10\">10<\/option>\r\n      <option value=\"20\">20<\/option>\r\n      <option value=\"30\">30<\/option>\r\n      <option value=\"50\">50<\/option>\r\n      <option value=\"100\">100<\/option>\r\n      <option value=\"250\">250<\/option>\r\n      <option value=\"500\">500<\/option>\r\n      <!-- <option value=\"all\">Show All<\/option> -->\r\n    <\/select>\r\n  <\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n<!-- ----------------------------------------------------------------- -->\r\n<\/div>\r\n\r\n\r\n<div style=\"display: none;\" sgsr-submission-form=\"3\">\r\n  <form onsubmit=\"sgsr_form_submission(3);return false;\" id=\"sgsr-form-3\">\r\n        \r\n        <div class=\"sgsr-form\">\r\n         <label for=\"sgsr_field_1\" class=\"sgsr-label\">Your Name<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_1\" id=\"sgsr_field_1\" placeholder=\"Enter Name\" value=\"\" required=\"\">\r\n            <\/div>\r\n          \r\n            <div class=\"sgsr-form\">\r\n              <label for=\"sgsr_field_2\" class=\"sgsr-label\">Email<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_2\" id=\"sgsr_field_2\" placeholder=\"Enter Email\" value=\"\" required=\"\">\r\n            <\/div>\r\n          \r\n            <div class=\"sgsr-form\">\r\n              <label for=\"sgsr_field_3\" class=\"sgsr-label\">Phone<\/label>\r\n              <input type=\"text\" class=\"sgsr-input\" name=\"sgsr_field_3\" id=\"sgsr_field_3\" placeholder=\"Enter Phone\" value=\"\">\r\n            <\/div>         \r\n          \r\n        <input type=\"hidden\" name=\"json\" id=\"selected_items\" value=\"{}\">\r\n        <button type=\"submit\" class=\"sgsr-btn submitSelected\">Submit<\/button>\r\n      <\/form>\r\n\r\n<\/div>\r\n\r\n\r\n  <\/div>\r\n\r\n\r\n<div style=\"height:50px;\"><\/div>\r\n  <h3>\ud83d\udccc Benefits of Using Stylish Google Sheet Reader<\/h3>\r\n  <ul>\r\n      <li><strong>Keeps original Google Sheets hidden<\/strong> \u2014 users only see the rendered table, not your backend data source<\/li>\r\n    <li>Automatically syncs live stock data from Google Sheets<\/li>\r\n    <li>Responsive on mobile and desktop<\/li>\r\n    <li>Supports image rendering, up\/down trends, sorting, pagination<\/li>\r\n    <li>Works with plain Google Sheets, no need for advanced coding<\/li>\r\n  <\/ul>\r\n\r\n\r\n\r\n<h3 id=\"live-chat-for-cloud-app\">Need Similar DataTable Functionality for Wix, Squarespace, or Shopify?<\/h3>\r\n\r\n<p>\r\nIf you're building on a platform other than WordPress \u2014 like <strong>Wix<\/strong>, <strong>Squarespace<\/strong>, or <strong>Shopify<\/strong> \u2014 you can still enjoy the same great DataTable features.\r\n<\/p>\r\n\r\n<p>\r\nGet exclusive access to our <strong>cloud-based app<\/strong> that mirrors the exact functionality of the Stylish Google Sheet Reader plugin. Use it to connect your Google Sheets and generate clean, responsive <strong>HTML embed codes<\/strong> that work on any website or CMS.\r\n<\/p>\r\n\r\n<a href=\"#live-chat-for-cloud-app\" action=\"live-chat\" class=\"sgsr-btn-link\">\r\n  Try the Cloud App <i class=\"fas fa-cloud\"><\/i>\r\n<\/a>\r\n\r\n\r\n\r\n<\/div>\r\n\r\n\r\n<script type=\"text\/javascript\">\r\n  jQuery(document).on('click', '[action=\"live-chat\"]', function () {\r\n  if (typeof tidioChatApi === 'undefined') {\r\n    console.warn('Tidio chat API not loaded yet');\r\n    return;\r\n  }\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-560adf0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"560adf0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0ff3c78\" data-id=\"0ff3c78\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-229232f elementor-widget elementor-widget-shortcode\" data-id=\"229232f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7be6597e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7be6597e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-58e6309\" data-id=\"58e6309\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63ce3f74 elementor-widget elementor-widget-spacer\" data-id=\"63ce3f74\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c9646cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c9646cc\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-44c48b39\" data-id=\"44c48b39\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d1dc64 elementor-widget elementor-widget-elementskit-heading\" data-id=\"6d1dc64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementskit-heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" ><div class=\"ekit-heading elementskit-section-title-wraper text_left   ekit_heading_tablet-   ekit_heading_mobile-text_center\"><p class=\"ekit-heading--title elementskit-section-title \">\u00a9 WP Plugin Box. All Rights Reserved.<\/p><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2c8d708e\" data-id=\"2c8d708e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2cb32c07 elementor-align-right elementor-mobile-align-center ekit-has-divider-yes elementor-widget__width-inherit elementor-widget elementor-widget-elementskit-page-list\" data-id=\"2cb32c07\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementskit-page-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"ekit-wid-con\" >\t\t<div class=\"elementor-icon-list-items  elementor-inline-items\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-list-item   \">\n\t\t\t\t\t\t<a class=\"elementor-repeater-item-dfcdbc0 ekit_badge_left\" href=\"https:\/\/wppluginbox.com\/terms-of-services\/\" target=\"_blank\" rel=\"nofollow\">\n\t\t\t\t\t\t\t<div class=\"ekit_page_list_content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">\n\t\t\t\t\t\t\t\t\t<span class=\"ekit_page_list_title_title\">Terms &amp; Conditions<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-icon-list-item   \">\n\t\t\t\t\t\t<a class=\"elementor-repeater-item-2fae0ea ekit_badge_left\" href=\"https:\/\/wppluginbox.com\/refund-policy\/\" target=\"_blank\" rel=\"nofollow\">\n\t\t\t\t\t\t\t<div class=\"ekit_page_list_content\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">\n\t\t\t\t\t\t\t\t\t<span class=\"ekit_page_list_title_title\">Refund Policy<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Display Stock Data from Spreadsheets as Responsive DataTables. Convert a Google Sheet into a clean, sortable, searchable, and responsive DataTable \u2014 without writing code.<\/p>\n","protected":false},"author":2,"featured_media":2944,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Display Google Sheets as Responsive DataTables<\/title>\n<meta name=\"description\" content=\"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Display Google Sheets as Responsive DataTables\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-02T21:14:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T19:27:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png\" \/>\n\t<meta property=\"og:image:width\" content=\"898\" \/>\n\t<meta property=\"og:image:height\" content=\"876\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Hayyat Apps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hayyat Apps\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\"},\"author\":{\"name\":\"Hayyat Apps\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b\"},\"headline\":\"How to Create a Stocks DataTable from Google Sheets in WordPress\",\"datePublished\":\"2025-08-02T21:14:08+00:00\",\"dateModified\":\"2025-08-03T19:27:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\"},\"wordCount\":545,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\",\"url\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\",\"name\":\"How to Display Google Sheets as Responsive DataTables\",\"isPartOf\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png\",\"datePublished\":\"2025-08-02T21:14:08+00:00\",\"dateModified\":\"2025-08-03T19:27:54+00:00\",\"description\":\"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.\",\"breadcrumb\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage\",\"url\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png\",\"contentUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png\",\"width\":898,\"height\":876},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wppluginbox.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Stocks DataTable from Google Sheets in WordPress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#website\",\"url\":\"https:\/\/wppluginbox.com\/en\/\",\"name\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\",\"description\":\"Smart web forms, calculators &amp; lead-gen tools for WordPress, Wix, and Squarespace\",\"publisher\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wppluginbox.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#organization\",\"name\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\",\"url\":\"https:\/\/wppluginbox.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\",\"contentUrl\":\"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg\",\"width\":1454,\"height\":1282,\"caption\":\"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins\"},\"image\":{\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b\",\"name\":\"Hayyat Apps\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g\",\"caption\":\"Hayyat Apps\"},\"url\":\"https:\/\/wppluginbox.com\/en\/author\/hayyat\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Display Google Sheets as Responsive DataTables","description":"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Display Google Sheets as Responsive DataTables","og_description":"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.","og_url":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/","og_site_name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","article_published_time":"2025-08-02T21:14:08+00:00","article_modified_time":"2025-08-03T19:27:54+00:00","og_image":[{"width":898,"height":876,"url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png","type":"image\/png"}],"author":"Hayyat Apps","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hayyat Apps","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#article","isPartOf":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/"},"author":{"name":"Hayyat Apps","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b"},"headline":"How to Create a Stocks DataTable from Google Sheets in WordPress","datePublished":"2025-08-02T21:14:08+00:00","dateModified":"2025-08-03T19:27:54+00:00","mainEntityOfPage":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/"},"wordCount":545,"commentCount":0,"publisher":{"@id":"https:\/\/wppluginbox.com\/en\/#organization"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/","url":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/","name":"How to Display Google Sheets as Responsive DataTables","isPartOf":{"@id":"https:\/\/wppluginbox.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png","datePublished":"2025-08-02T21:14:08+00:00","dateModified":"2025-08-03T19:27:54+00:00","description":"Learn how to convert Google Sheets into responsive, searchable DataTables on your WordPress site using the Stylish Google Sheets Reader plugin. Includes shortcode examples and cloud app support for Wix, Squarespace, and Shopify.","breadcrumb":{"@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#primaryimage","url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png","contentUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/08\/stocks_datatable.png","width":898,"height":876},{"@type":"BreadcrumbList","@id":"https:\/\/wppluginbox.com\/en\/create-datatable-from-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wppluginbox.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to Create a Stocks DataTable from Google Sheets in WordPress"}]},{"@type":"WebSite","@id":"https:\/\/wppluginbox.com\/en\/#website","url":"https:\/\/wppluginbox.com\/en\/","name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","description":"Smart web forms, calculators &amp; lead-gen tools for WordPress, Wix, and Squarespace","publisher":{"@id":"https:\/\/wppluginbox.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wppluginbox.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wppluginbox.com\/en\/#organization","name":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins","url":"https:\/\/wppluginbox.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg","contentUrl":"https:\/\/wppluginbox.com\/en\/wp-content\/uploads\/2025\/07\/WP-Plugin-Box-Logo-2.jpg","width":1454,"height":1282,"caption":"WP Plugin Box \u2013 Custom Web Calculators &amp; WordPress Plugins"},"image":{"@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/7e8d1f33896d21fa38c031e8a7c7219b","name":"Hayyat Apps","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wppluginbox.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54016c796204b6d51e8e46068f4dd5670937bdc4a1982a190be8ef133e9c6705?s=96&d=mm&r=g","caption":"Hayyat Apps"},"url":"https:\/\/wppluginbox.com\/en\/author\/hayyat\/"}]}},"_links":{"self":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/comments?post=2834"}],"version-history":[{"count":95,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2834\/revisions"}],"predecessor-version":[{"id":2988,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/posts\/2834\/revisions\/2988"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/media\/2944"}],"wp:attachment":[{"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/media?parent=2834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/categories?post=2834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wppluginbox.com\/en\/wp-json\/wp\/v2\/tags?post=2834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}