WordPress.org

Plugin Directory

Inline Google Spreadsheet Viewer

Embeds a public Google Spreadsheet in a WordPress post or page as an HTML table or interactive chart.

Version 0.8.5

  • Feature: DataTables-enhanced tables now include the Responsive plugin enabled by default. This plugin further improves narrow and liquid layouts by displaying columns that won't fit without scrolling horizontally in a child row instead. If you want to keep the old behavior (horizontal scrolling), add the no-responsive class to your shortcode, like this: [gdoc key="ABCDEFG" class="no-responsive"]
  • Developer: Update DataTables libraries to version 1.10.5.

Version 0.8.4

  • Developer: Two new plugin filters, gdoc_table_html and gdoc_viewer_html, allow other plugin or theme authors to customize the output produced by the gdoc shortcode. See the Other Notes page for documentation and implementation notes.
  • Bugfix: Correctly declare JavaScript dependencies.

Version 0.8.3

  • Bugfix: Stricter whitespace checking fixes an issue where space/newline character sequences were unintuitively interpreted.

Version 0.8.2

  • Feature: WordPress Embeds support provides OEmbed emulation, so now you don't even need to use a shortcode. In other words, pasting your Spreadsheet's key onto its own line is now the equivalent of invoking a shortcode like this: [gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/edit"]
    • This feature is only available for "new" Google Spreadsheets.

Version 0.8.1

  • Bugfix: Properly serialize and store responses from Google with mismatched encoding.
  • Bugfix: Properly save and load caches with shortcodes that use the gid attribute.
  • Bugfix: Uninstaller correctly clears plugin cache.

Version 0.8

  • Feature: Built-in caching. To improve page load speeds, shortcodes whose keys output spreadsheet table data will be cached for ten minutes by default.
    • You can use the new expire_in attribute to set a custom cache lifetime (in seconds). For instance, to cache for 1 minute instead of 10, use [gdoc key="ABCDEFG" expire_in="60"]
    • To turn off caching for a specific spreadsheet, set the use_cache attribute to no, like [gdoc key="ABCDEFG" use_cache="no"]. Disabling the cache for a spreadsheet is only recommended for relatively small datasets (under 100 rows or so) that change often, or for debugging purposes.
    • Changing the query in a shortcode will also create a new cache, since a different query may return different data.

Version 0.7.1

  • Bugfix: Restore correct <caption> (shortcode content) handling.

Version 0.7

  • Feature: Previews for direct links to PDF, XLS, DOC, and other file formats supported by the Google Docs Viewer now work, too. Simply use the direct URL to one such file hosted on the public Internet as your key to embed an HTML preview of that file.
  • Feature: New shortcode attributes style, width, and height enable you to supply inline display dimensions. Note that when used on HTML tables, you must use the CSS equivalents for width and height by using the style attribute rather than the other two directly. For instance: [gdoc key="ABDCEFG" class="no-datatables" style="width:50%;height:480px;"]
  • Bugfix: Correct chart_pie_slice_text_style attribute handling.

Version 0.6.3

  • Feature: Massively customizeable charts.
    • You can now use a huge number of shortcode options to customize the look and feel of your charts. Most configurable options defined in the Google Chart API are supported through shortcode attributes. For instance,
      • to choose custom chart colors, use the chart_colors attribute with a space-separated list of color strings (like chart_colors="red #CCC").
      • Use JSON syntax in an attribute whose value calls for an Object. For instance, chart_background_color='{"fill":"yellow","stroke":"red","strokeWidth":5}', and notice the single quotes around the attribute value and double quotes for correct JSON parsing.

Version 0.6.2.2

  • Bugfix: Workaround WordPress parser garbling < and > comparison operators in query shortcode attribute. Instead, use the URL-encoded equivalents, %3C and %3E, respectively.

Version 0.6.2.1

  • Bugfix: Show the QuickTag button only on post edit screens.

Version 0.6.2

  • Bugfix: Fix bug that failed to load Chart visualizations in combination with gid parameter.

Version 0.6.1

  • Bugfix: Fix bug that caused JavaScript loading to fail when certain gdoc shortcodes were used.

Version 0.6

  • Feature: Use the chart attribute to display your Google Spreadsheet's data as an interactive chart or graph. Supported chart types include:
    • Area charts
    • Bar charts
    • Bubble charts
    • Candlestick charts
    • Column charts
    • Combo charts
    • Histograms
    • Line charts
    • Pie charts
    • Scatter charts
    • Stepped area charts
  • Feature: Customize the tooltip by supplying a title attribute in the shortcode for your table or chart.
  • Performance: Load large JavaScript libraries only when needed for the kind of chart or table that's being displayed.

Version 0.5.1

  • Feature: New gdoc quicktag allows point-and-click insertion of [gdoc key="ABCDEFG"] shortcode when using the HTML editor.
  • Feature: On-line help using WordPress's built-in help viewer.
  • Usability: More error detection and suggestions for possible fixes.
  • Localization: Translation infrastructure added. Help translate Inline Google Spreadsheet Viewer into your langauge!

Version 0.5

  • Feature: Query your spreadsheet like a database using the new query shortcode attribute. The value of the query attribute is any Google Charts API Query Language query. For example, to retrieve only the first two columns in rows whose first column begins with "Mario Bros." in a Google Spreadsheet, use a shortcode like [gdoc key="ABCDEFG" query="select A, B where A starts with 'Mario Bros.'"].

Version 0.4.7.1

  • Usability: Show a user-friendly error with suggestions to fix the detected problem.

Version 0.4.7

  • Feature: Support for the FixedColumns extension for DataTables-enhanced tables.
  • Large DataTables-enhanced tables now scroll horinzontally by default to avoid common layout issues.

Version 0.4.6

Version 0.4.5

  • Bugfix: Correctly output the table's id attribute for "new" Google Spreadsheets.
  • Security: Added additional output escaping.

Version 0.4.4

Version 0.4.3

  • Feature: "New" Google Spreadsheets are now officially supported.

Version 0.4.2

  • Feature: Detect Web addresses and email addresses and turn them into clickable links. Optionally disable this behavior by adding linkify="no" to your shortcode.

Version 0.4.1

  • Bugfix: Correctly pass gid attribute.

Version 0.4

Version 0.3.3

  • Bugfix: Correctly load search/sort/filter JavaScript on some systems where it failed.

Version 0.3.2

  • Adds jQuery DataTables plugin to provide column sorting, searching, and pagination. All tables will have DataTables's features applied. If you'd prefer to stick with the old, static table, use the no-datatables class when calling it. For instance, [gdoc key="ABDEFG" class="no-datatables"]. This also means the plugin now requires WordPress version 3.3 or later.

Version 0.3.1

  • Bugfix for "Invalid argument supplied for foreach()" when using built-in PHP str_getcsv().
  • Bugfix for some situations in which debugging code caused a fatal error.

Version 0.3

  • Implements header_rows attribute in shortcode to allow rendering more than 1 header row.
  • Fetches data using wp_remote_get() instead of fopen() for portability; now requires WordPress 2.7 or higher.
  • Updates plugin internals; uses PHP 5.3's str_getcsv() function if available.

Version 0.2

  • Implements gid attribute in shortcode to allow embedding of non-default worksheet.
  • Updates plugin internals; now requires WordPress 2.6 or higher.

Version 0.1

  • Initial release.

Requires: 3.5 or higher
Compatible up to: 4.1.1
Last Updated: 2015-3-13
Active Installs: 3,000+

Ratings

4.1 out of 5 stars

Support

22 of 22 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1
100,3,3
0,1,0
50,2,1
0,1,0
33,3,1
50,2,1
0,1,0 100,1,1
0,1,0
50,2,1
0,1,0
0,1,0
100,1,1 0,1,0
100,1,1
100,1,1
100,1,1