anjanasilva

WordPress Plugin to present a CSV file in a DataTable. This will import data from a CSV file and display in a DataTable.
<h3>How To Use</h3>
Insert following code snippet into any page or post using this shortcode, make sure you use an unique id :
<pre><code>[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id]
</code></pre>
You can now disable DataTable search, pagination, sorting and displaying of bInfo with the recent 1.1 release. The purpose of this is to render a static looking HTML Table out of a CSV file.
<pre><code>[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id disable_search=true disable_paging=true disable_binfo=true disable_sorting=true]
</code></pre>
Save it, just refresh the page and see. Less hassle, all your csv data is inside the DataTable.
<h3>Credits</h3>
This plugin utilizes some excellent open source scripts, functions and images whose creators deserve to be recognized.
<ol>
<li>Shaun Scovil, for inspiring me through his CSV to Sortable Plugin.</li>
<li>V.Krishn wrote a handy <a href="http://github.com/insteps/phputils" rel="nofollow ugc">PHP function</a> that enables users of PHP < 5.3 to utilize the <code>str_getcsv()</code> function that powers this plugin.</li>
</ol>
<h3>Common Errors</h3>
<ol>
<li>If the datatable misbehaves, this is probably due to an incorrect csv format. In that case, open csv file in excel 
and re-save it as a new csv. Most likely this will resolve your issue.</li>
</ol>

AJ CSV to DataTable

Wordpress Plugin to import data from a CSV file and display it in a DataTable.

Sheetable

<a href="https://getsheetable.com/" rel="nofollow ugc">Website</a> | <a href="https://docs.getsheetable.com" rel="nofollow ugc">Documentation</a>
Sheetable – Google Sheets to WP Table lets you embed and sync Google Sheets data as responsive WordPress tables. Import your spreadsheet, customize the display, and embed it anywhere using shortcode or Gutenberg block. No API key required, no server load, no complex setup.
Paste your Google Sheet link, customize, embed – done.
<h3>Why Choose Sheetable?</h3>
Sheetable takes a modern approach to embedding Google Sheets in WordPress:
<ul>
<li>Ultra-lightweight (only ~10KB footprint on frontend) – Won’t slow down your site</li>
<li>Client-side caching – Lightning-fast repeat loads</li>
<li>No API key required – No setup, no limits, no OAuth</li>
<li>Zero server processing – All rendering happens in browser</li>
<li>Core Web Vitals optimized – Built for 100/100 Lighthouse scores</li>
<li>Large spreadsheet support – Handles large datasets smoothly, even millions of rows</li>
<li>Formatting support – Checkboxes, links, images, email, phone detected automatically</li>
</ul>
Modern performance without complexity.
<h3>Free Features</h3>
<ul>
<li>Unlimited tables – Create as many as you need</li>
<li>Unlimited Google Sheets – Connect any public sheet</li>
<li>Unlimited rows & columns – No artificial limits like others</li>
<li>Real-time search – Find data instantly</li>
<li>Column sorting – Sort by any column</li>
<li>Pagination – Navigate large datasets easily</li>
<li>Refresh – Update data on demand without loading page</li>
<li>Fully responsive – Works on all devices including mobile, tablet, desktop, folding devices</li>
<li>Rich content support – Links, images, text, numbers, dates, emojis, checkboxes</li>
<li>Smart links – Auto-detect emails and phone numbers as clickable links</li>
<li>Text wrapping options – Control how long text displays in cells</li>
<li>Show/hide title & description – Control what visitors see</li>
<li>Row numbers display – Easy reference</li>
<li>Shortcode support – Embed anywhere</li>
<li>Gutenberg block – Native WordPress editor support</li>
</ul>
<h3>Pro Features</h3>
Unlock advanced functionality with Sheetable Pro:
<ul>
<li>Show/hide header & footer – Full table control</li>
<li>Auto-refresh – Set custom intervals for live sync</li>
<li>Custom CSS editor – Complete styling freedom</li>
<li>Full styling control – Colors, fonts, borders, spacing</li>
<li>Row & column offset – Start from any position</li>
<li>Limit rows & columns – Display exactly what you need</li>
<li>Range selection – Specify A1:F200 or any range</li>
<li>Regex search – Advanced pattern matching</li>
<li>Content protection – Disable text selection & copy</li>
<li>Responsive column visibility – Hide specific columns on mobile/tablet</li>
<li>Responsive column wrapping – Show limited columns with expandable rows</li>
<li>Copy & paste styles – Apply styling from one table to another</li>
<li>Export options:
<ul>
<li>Excel (XLSX)</li>
<li>CSV</li>
<li>TSV</li>
<li>PDF</li>
<li>HTML</li>
<li>Markdown</li>
<li>JSON</li>
<li>Copy to clipboard</li>
<li>Print</li>
</ul>
</li>
</ul>
<h3>How It Works</h3>
<ol>
<li>Make your Google Sheet public and paste the URL</li>
<li>Customize your table settings and styles</li>
<li>Embed using shortcode or Gutenberg block</li>
</ol>
<h3>SEO & Performance Benefits</h3>
<ul>
<li>Fully indexable HTML output – Search engines can read your data</li>
<li>Ultra-lightweight – Better Core Web Vitals scores</li>
<li>Fast mobile performance – Optimized for all devices</li>
<li>Clean semantic markup – SEO-friendly structure</li>
<li>Lower bounce rate – Fast loading keeps visitors engaged</li>
</ul>
Sheetable helps both your site speed and search rankings.
<h3>External Services</h3>
This plugin connects directly to Google Sheets to fetch and display spreadsheet data.
Google Sheets (Google LLC)
<ul>
<li>What it does: Fetches your spreadsheet data directly to the visitor’s browser (Client-side)</li>
<li>Data sent: The visitor’s browser sends a request to your public Google Sheet URL</li>
<li>Data received: Spreadsheet content (rows, columns, formatting)</li>
<li>When: Each time a visitor loads a page containing your table</li>
<li>Terms of Service: <a href="https://policies.google.com/terms" rel="nofollow ugc">Google Terms of Service</a></li>
<li>Privacy Policy: <a href="https://policies.google.com/privacy" rel="nofollow ugc">Google Privacy Policy</a></li>
</ul>
Note: No data is sent to Sheetable servers or any third-party intermediary. All data transfer occurs directly between the visitor’s browser and Google’s servers.
<h3>Privacy Policy</h3>
Sheetable respects your privacy. The plugin:
<ul>
<li>Does not collect any personal data from you or your visitors</li>
<li>Does not send any data to external servers (except the direct fetch from Google to the visitor)</li>
<li>Does not use cookies or tracking</li>
<li>Processes all data client-side in the visitor’s browser</li>
</ul>
Your Google Sheet data is fetched directly from Google’s servers to the visitor’s browser. Sheetable acts only as a display layer.

Sheetable – Google Sheets to WP Table

Turn Google Sheets into WP tables with search, sorting & pagination. No API key needed. Ultra-lightweight.

AJ CSV to DataTable vs Sheetable – Google Sheets to WP Table