Import Data to Charts
There are 3 different ways in which you can import data for your charts:
IN THIS ARTICLE
Enter Data Manually
This is best if you have small data to work with.
To do this, input your data manually into the spreadsheet table on the right of the chart window. The input will be reflected immediately on the chart preview.
To remove or add a column or a row, highlight the specific column or row and Right-click for a drop option to appear.
Import From File
If you have an excel spreadsheet in XLS, XLSX, or CSV format, you can import your data files from your computer to the Piktochart editor.
To do so, click Import Your Data at the top of the chart table. A window will appear for you to select your file to open. If your Excel file (.XLS and .XLSX) is detected to contain more than one sheet, you will be asked to select the correct sheet from which to pull the data for your chart.
Your data contained in these files need to have column and row headers, and at least one column of data.
Import From Google Sheet
To import your file from Google Sheet, follow the instructions available on the tab on how to obtain your Google Spreadsheet URL.
Go to Tools > Chart and select your preferred chart option.
Select Dynamic Data tab from the Chart pop-up window.
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 pop-up.
If you would like to link a specific tab, open the tab and copy the selected tab browser URL instead. Like so:
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 Save 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.