Home Forums Chart Support Easiest Google Sheets Integration?

Easiest Google Sheets Integration?

Viewing 4 posts - 1 through 4 (of 4 total)
  • #41897

    Is there a built-in way to have CanvasJS create a chart using data from a public Google Sheet? For example, the sheet below?
    https://docs.google.com/spreadsheets/d/18qW3T0LSrqCtg-2JlHSh5cHG06NeHUp4JZUyBg7k1Sw/edit?usp=sharing

    If not native, what’s the easiest recommended export?

    Many thanks!

    #41913

    @hejenemy,

    You can publish Google-Sheet as CSV and use the URL generated to fetch data using jQuery AJAX as shown in this JSFiddle.

    Chart with data from external CSV


    Thangaraj Raman
    Team CanvasJS

    #41920

    Thank you. Is there any guidance on how to manipulate the data? The example is a very simple series, just a few data points in a column. How would you specify specific columns in the Google Sheet to correspond with the axis or data series within the CanvasJS chart?

    #41933

    @hejenemy,

    You can read a specific row from the CSV file by its index / header. Please take a look at this documentation page for a step-by-step tutorial on rendering charts with data from a CSV file and parsing it. Also, please refer to this article for more information on parsing CSV data.


    Thangaraj Raman
    Team CanvasJS

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.