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
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
- In your Google Spreadsheet page, click on ‘File’ and select the ‘Publish to the web’ option.
- On the popup window, click on the ‘Start publishing‘ button to publish your spreadsheet.
- 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.
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.