Visualizer: Charts and Graphs
[resolved] No option to choose csv format on Google Drive Publish to the web window (7 posts)

  1. brightestspark
    Posted 1 year ago #

    I created a Google spreadsheet in my Google Drive.

    I tried to follow your instructions here https://github.com/madpixelslabs/visualizer/wiki/How-can-I-populate-data-from-Google-Spreadsheet%3F

    But I don't have an option to choose csv as per step 4.

    Any ideas why?

    Here's my spreadsheet https://docs.google.com/spreadsheets/d/1OwLbLxAemWIjLo97GR3xggXkGwBFBpbGJie9eKj7gwk/pubhtml


  2. madpixels
    Plugin Author

    Posted 1 year ago #

    Looks like the Google has removed such ability to export spreadsheet in the csv format. A simple workaround could be to upload a csv file to your server and use it as a source for your chart. Could you try it?

  3. brightestspark
    Posted 1 year ago #

    Hi - no biggie - we wanted to use Google Drive so that non web peeps could populate and update the spreadsheets ongoing, but they are happy to just upload the csv through WordPress for initial and ongoing updates.


  4. philip.levine
    Posted 1 year ago #

    Step 1) Set share to anyone with link
    Step 2) Use the following URL replacing KEY with the Google Doc key - In your example it would be 1OwLbLxAemWIjLo97GR3xggXkGwBFBpbGJie9eKj7gwk

    Perhaps there a feature could be added that just allows you to enter the KEY and the plugin would generate the rest of the URL

  5. webbrewers
    Posted 1 year ago #

    So if Google no longer supports publishing csv files, the interactivity no longer works and the plug in's documentation should be updated to reflect that, no?
    I tried the above and replaced "export" with "pubhtml" and neither work.

  6. madpixels
    Plugin Author

    Posted 1 year ago #


    You don't have to use Google. Just upload your csv to your server, copy its link and use it as remote source. In this case you will be able to update csv files and your charts will be updated as well.

  7. webbrewers
    Posted 1 year ago #

    Right but the documentation says you can connect to a Google doc. The alternative is you have to replace the file when it changes (or find a way to open it from the server in Excel). Dynamic updates were a requirement in this case, so I ended up using RJ Quickcharts which provides an easy way to update via the dashboard so removes the need for a Google doc.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Visualizer: Charts and Graphs
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.