Import Data from Google Spreadsheet
To import your file from a Google spreadsheet:
Under the Data tab of your Charts editor, click Google Sheet. You will be requested to Paste your Google Sheet URL link.
On your Google Spreadsheet, click the Share button.
Change restriction to allow Anyone with Link.
Copy the link and click Done to confirm the action.
Paste the link into the text bar in the chart tab. Click Link Data.
Your data will be reflected on your Chart immediately.
If you would like to link a specific tab, open the tab and copy the selected tab browser URL instead. Like so:
Common Questions
What happens if I update the data on Google Spreadsheet?
Your data will not automatically be updated. Should there be any changes to your data, you will need to open the Piktochart Editor, unlink the chart and link your updated chart again following the steps under Import from Google Sheets and ensure that you have successfully Saved your visual.
- If your visual is published on the web via https://create.piktochart.com/output/... , the data will be updated when you refresh the page.
- If you download your visual as an image or PDF, you'll need to open the Piktochart editor and download a new copy of the visual.
How do I modify my data after importing it to Google Spreadsheet?
When your data is imported from the Google Spreadsheet, you may only modify the data on the Google Spreadsheet alone. It is not possible to modify the data on Piktochart. This is to maintain consistency so the data is always available in one place.