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)
In the Editor window of your Project, with your chart now created and selected, click the Import Data tab on the left and the list of available options will appear.
For connecting to and importing from a Google Sheet, you’ll need to follow the special instructions that are listed in the tab:
Select Publish to the Web from File
Select the Publish option in the popup window
Copy the link (URL)
After you’ve copied the link (URL) for your Sheet from Google, paste it here and click Connect. For 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.
Note: 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 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 login 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 center 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.
Watch This Video on How to Connect and Import data into Charts