In addition to creating custom charts and graphs to visualize your data, you can import data from Google Sheets, MS Excel, Google Analytics, and SurveyMonkey.
To learn more about how to create and customize charts and graphs, check out this resource.
Connect Live Data (Google Sheets)
Select the chart you’ve created in your project and then click on the “Import Data” tab on the left. The list of available options will appear.
Then, for connecting to and importing from a Google Sheet, you’ll need to import your Google Spreadsheet.
- From your Google Spreadsheet, click on the “Share” button
- Once in the Link Box, change the link to “Anyone with the link”
- Copy the link (URL)
- Paste the link on the “Google Link” Field
For the next steps, scroll down to the bottom of this article – After Connecting Data – What’s Next?
Import Data from Spreadsheet
For an MS Excel file, you can upload both an XLSX file and a CSV file to connect to and import from by clicking Select File.
: We suggest you work with aggregate or pivoted data for your spreadsheet imports. Visme will use the first tab (or sheet) within your Excel file that you import into the graph engine. The data will populate into the Chart Data tab where you can continue to make adjustments to the data manually as needed.
For the next steps after important from your spreadsheet, scroll down to the bottom of this article – After Connecting Data – What’s Next?
Connecting Charts to External Applications
For Google Analytics, click Connect, which will prompt you to sign in to your Google Analytics account. You can choose which analytics data you wish to connect from the options that load.
For SurveyMonkey, click Connect, which will prompt you to log in to your SurveyMonkey account. You can choose which survey data you wish to connect from the options that load.
After Connecting Data – What’s Next?
You can review the new data in the Chart Data tab. Also, if you’d like to re-sync the data values here with your connected source, click Re-sync data.
You can preview any changes you have made to your chart by clicking anywhere on your project in the centre of the Editor window.
To disconnect your chart from the import source, select the Import Data tab again and click Disconnect. You can then return to the Chart Data tab to adjust your data values.