Title: Error loading Google Spreadsheet data Last modified: August 22, 2016 --- # Error loading Google Spreadsheet data * Resolved [jenninsb](https://wordpress.org/support/users/jenninsb/) * (@jenninsb) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/) * I’m getting this error message: * [Error loading Google Spreadsheet data. Make sure your Google Spreadsheet is shared using either the “Public on the web” or “Anyone with the link” options.] * My doc is public on the web, and I can view it by pasting my URL in another browser: * [https://docs.google.com/spreadsheet/ccc?key=0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc&usp=sharing](https://docs.google.com/spreadsheet/ccc?key=0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc&usp=sharing) * Here’s the code as I’m using it: * [gdoc key=”[https://docs.google.com/spreadsheet/ccc?key=0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc&usp=sharing”%5D](https://docs.google.com/spreadsheet/ccc?key=0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc&usp=sharing”%5D) * What am I doing wrong? * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) Viewing 15 replies - 1 through 15 (of 15 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539675) * That’s an old style Google Sheet so your `key` should just be `0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc`. * Thread Starter [jenninsb](https://wordpress.org/support/users/jenninsb/) * (@jenninsb) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539812) * Thanks for getting back to me, but this doesn’t seem to have fixed it. Now my code looks like this: * [gdoc key=”0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc”] * And I get the same error message: * [Error loading Google Spreadsheet data. Make sure your Google Spreadsheet is shared using either the “Public on the web” or “Anyone with the link” options.] * Here’s the page: [http://www.escapadecon.net/?p=454](http://www.escapadecon.net/?p=454) * My wordpress version is 4.0.1, if that makes any difference. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539813) * [You have not yet published your Spreadsheet to the Web](http://spreadsheets.google.com/pub?key=0AkssTOsw2NNddGZTVXR4VWxpNGpyNW1nYVc1Um5DOGc). Choose File -> Publish to the Web, like the FAQ and countless other support threads here mention you need to do. * Thread Starter [jenninsb](https://wordpress.org/support/users/jenninsb/) * (@jenninsb) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539816) * OK, I’m really confused. I did read your documentation and followed the instructions to share my spreadsheet to the web. I checked this by pasting the google docs link in my first message in several browsers where I am not logged in to google, and was able to view the spreadsheet just fine. * I have embedded screen caps showing the sharing status of my spreadsheet in the page with the non-working link: * [http://www.escapadecon.net/schedule/](http://www.escapadecon.net/schedule/) * OTOH, I pasted the key from a previously shared document, and it did embed, so your diagnosis seems accurate. I just don’t know what else I need to do, once google tells me that the document is shared publicly. * I am not familiar with the old/new google spreadsheet format. Do you think it would make a difference if I upgraded my spreadsheet to the newer format? * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539822) * “Publish to the Web” is not the same as “share with the public.” For an old Google Sheet (yours) you must “Publish to the Web.” “Sharing” isn’t relevant. Go to the File menu and select “Publish to the Web.” * Sorry this is terse, I am on my phone. * Thread Starter [jenninsb](https://wordpress.org/support/users/jenninsb/) * (@jenninsb) * [11 years, 6 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539828) * Thank you! I need to work on my reading comprehension. I’m sorry to have wasted your time. * [Daniel Silveira](https://wordpress.org/support/users/daniel-silveira/) * (@daniel-silveira) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539953) * I did all you said but it din’t work (my google drive is in portuguese but it obviouly shouldn’t affect the result), see screenshots below: * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539954) * What screenshots, Daniel? Double (and maybe triple) check that you’ve made your spreadsheet available correctly. That’s almost certainly the issue, as mentioned above. * [Daniel Silveira](https://wordpress.org/support/users/daniel-silveira/) * (@daniel-silveira) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539955) * [http://www.congressomv.org/wp-content/uploads/2015/01/publish.png](http://www.congressomv.org/wp-content/uploads/2015/01/publish.png) [http://www.congressomv.org/wp-content/uploads/2015/01/frontend.png](http://www.congressomv.org/wp-content/uploads/2015/01/frontend.png) [http://www.congressomv.org/wp-content/uploads/2015/01/backend.png](http://www.congressomv.org/wp-content/uploads/2015/01/backend.png) * [ashleyashley](https://wordpress.org/support/users/ashleyashley/) * (@ashleyashley) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539957) * I have been trying to get my google spreadsheet to show up on my wordpress site. * It is published to the web and ALSO publically shared by link At first it said there was an error getting the spreadsheet, but now, nothing happens at all, and it just shows the code: * [ gdoc key= ” [https://docs.google.com/spreadsheets/d/1xFCm-h5zXHMCtTIIGmVdolnNIaDk_n8ogOgZrqY/pubhtml](https://docs.google.com/spreadsheets/d/1xFCm-h5zXHMCtTIIGmVdolnNIaDk_n8ogOgZrqY/pubhtml)”] * please advise * [ashleyashley](https://wordpress.org/support/users/ashleyashley/) * (@ashleyashley) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539958) * nevermind, I took out the spaces and got it * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539959) * [ashleyashley](https://support.google.com/drive/answer/2494886), as I’m glad you’ve figured out by now, I see a “Google Drive — Page Not Found” error page when I try to follow the link to your spreadsheet. * So, just in case others find this thread in the future: If you indeed have the correct URL but you see a “Page Not Found” error when you try following it, then you have not yet shared the spreadsheet publicly. Try double-checking that you have followed [Google’s instructions for how to share](https://support.google.com/drive/answer/2494886?hl=en) a spreadsheet with anyone on the Web. Alternatively, make double (or triple!) sure that you have the correct URL. * Good luck. 🙂 * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539960) * Daniel, the problem you’re encountering is that you’re using the old-style `key` with a new-style Google Sheet. Try using the full URL that Google gives you ( just copy-and-paste it) in your shortcode’s `key` parameter, not only the sheet ID itself. * In other words, you need something more like this: * ``` [gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/pubhtml"] ``` * and _not_, as you currently have it, like this: * ``` [gdoc key="ABCDEFG"] ``` * Hope this helps. 🙂 * [Daniel Silveira](https://wordpress.org/support/users/daniel-silveira/) * (@daniel-silveira) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539961) * Ok, it worked out * After copying the url, I had to to change the ending: * Instead of [gdoc key=”[https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=0″%5D](https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=0″%5D) * i put [gdoc key=”[https://docs.google.com/spreadsheets/d/ABCDEFG/pubhtml”%5D](https://docs.google.com/spreadsheets/d/ABCDEFG/pubhtml”%5D) * Thanks * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539962) * Glad you got it working, Daniel. * Yeah, I think I might have to rework the `key`/`gid` inputs again now that Google is changing those around in their UI a little bit. :\ Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Error loading Google Spreadsheet data’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) ## Tags * [sharing](https://wordpress.org/support/topic-tag/sharing/) * 15 replies * 4 participants * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/) * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/error-loading-google-spreadsheet-data/#post-5539962) * Status: resolved