How can we help you?

Popular Topics : The Basics, Tips & Tricks , and Designing & Editing

Menu +

Populating Charts with imported Data

Visme makes it easy to bring your data to life with beautiful charts and graphs. Whether you’re working with Google Sheets, Microsoft Excel, or data from external applications like Google Analytics, Smartsheet, or SurveyMonkey, here’s how you can seamlessly import your data and keep it up to date.

To learn more about how to create and customize charts and graphs, check out this resource.

1
From the editor window of your project, select the chart you’ve created in your project and then click on the Import Data tab on the leftside menu. The list of available options will appear.

Importing Data from Google Sheets

Visme offers two simple ways to bring in data from Google Sheets:

1
From the list of available data sources, select Google Sheets. You can either connect using a public URL or by signing into your Google account.

2
To connect via URL, paste the shared link into the text box and click Connect Sheet by URL to confirm.

Make sure your sheet is set to “Anyone with the link can view”.

3
Alternatively, click Connect to Google Sheets to link your Google account. After signing in, you’ll see a list of your available spreadsheets. Simply select the one you’d like to import.

 

Importing Data from Microsoft Excel

You can use Excel files in two ways:

1
From the list of data source options, select Microsoft Excel. You can either upload an Excel file directly or connect to Excel Online.

2
To upload a file, click Upload File XLSX, CSV and choose your file from your computer. Once uploaded, your data will automatically populate the chart.

3
To connect to Excel Online, click Connect to Excel Online. You’ll be prompted to sign in with your account. Follow the steps and then choose the worksheet tab and click Import.

 

Connecting Charts to External Applications

Visme supports live connections to several external apps, such as Google Analytics, Smartsheet and SurveyMonkey, so you can build dynamic charts that stay updated.

1
From the list of data source options, select the external app you want to connect (e.g., SurveyMonkey, Smartsheet, or Google Analytics), then click Connect to proceed.

2
You’ll be prompted to sign in to your account for that app. Follow the authentication steps to grant Visme access.

3
Once you’re logged in, Visme will automatically display your available data sources. Simply choose the dataset you’d like to bring the data into your chart.

If you’d like to re-sync the data values with your connected source, click Re-sync Data at thr bottom of the Settings menu
Back to home
Home
Data Visualizations
  • The Basics
  • Getting Started
  • Account & Plans
  • Publish & Present
  • Enterprise Plans
  • Embed & Download
  • For Print
  • Creating & Editing 101
  • Common Questions & Answers
  • Project Types
  • Presentations
  • Social Graphics
  • Documents
  • Infographics
  • Charts & Graphs
  • Whiteboards
  • Videos / GIFs
  • Printables
  • Webpages
  • Designing & Editing
  • Designing with AI
  • Data Visualizations
  • Text & Text blocks
  • Interactivity
  • 3D Graphics
  • Images
  • Animations
  • Video
  • Tables
  • Audio and Music
  • Graphics, shapes and icons
  • Backgrounds
  • Collaboration and Team Features
  • Workflows
  • My Brand
  • Team & Workspaces
  • Apps and Integrations
  • Analytic Tools & Insights
  • Analytics
  • Tips & Tricks
  • Account & Projects Settings
  • Viewing and Presenting
  • Creating and Designing
  • Productivity Tools
  • My Blocks
  • Tools & Features
  • My Files
  • Grides & Guides
  • Slide Library & Content Blocks
  • Forms & Surveys
  • Getting Started with Visme Forms
  • Sharing and Embedding your Visme Form
  • Make your Form
  • Data Collection and Management
  • Style your Form
  • Forms Integrations
Visme 101
Visme 101

Learn how Visme will change the way you create stunning content.

Reserve your seat