Posted 2013-11-20 by & filed under Product Update.

Hi all, we have added a cool feature to our ‘Chart’ tool – integration with Google Spreadsheet. Easily input your data and don’t worry about updates – it’s automatic!  

How to add data from your Google Spreadsheet

  gspreadsheet button You will notice a new button ‘Google Spreadsheet’ on the right side of the ‘Charts’ window. Click on it and you will be prompted to insert a Google Spreadsheet Link at the bottom of new window.  

How to get Google Spreadsheet Link

GooglePublishPage_70
  1. In your Google Spreadsheet page, click on ‘File’ and select the ‘Publish to the web’ option.
  2. On the popup window, click on the ‘Start publishing‘ button to publish your spreadsheet.
  3. Copy the published link provided and paste it in the text box in magic.piktochart.com.
You can also choose to select which sheet, as well as which cell range within the spreadsheet to be used.  

Chart auto-update

So what happens if you edit your data in Google Spreadsheet? Don’t worry, your chart is going to update automatically whenever the published infographic (as in http://magic.piktochart.com/output/XXXXX-XX) is loaded. If you make changes in the Google Spreadsheet and want to see changes immediately while you are working in the editor, click the ‘Update charts’ button. update charts button   Happy Piktocharting!  

About Author

Ai Ching

Ching is the Chief Email Officer and dedicates her time to find growth hacking ninja ways. Former P&G and Experimental Psychologist, Ching’s addiction includes supporting new projects on Kickstarter and travelling.

Related Articles

One Response to “Product Update: Integration with Google Spreadsheet”

Leave a Reply

Your email address will not be published. Required fields are marked *