We use essential cookies to make Venngage work. By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.

Manage Cookies

Cookies and similar technologies collect certain information about how you’re using our website. Some of them are essential, and without them you wouldn’t be able to use Venngage. But others are optional, and you get to choose whether we use them or not.

Strictly Necessary Cookies

Always Active

These cookies are always on, as they’re essential for making Venngage work, and making it safe. Without these cookies, services you’ve asked for can’t be provided.

Show cookie providers

  • Venngage
  • Amazon
  • Google Login
  • Intercom

Functionality Cookies

These cookies help us provide enhanced functionality and personalisation, and remember your settings. They may be set by us or by third party providers.

Show cookie providers

  • Venngage
  • Chameleon
  • Intercom
  • Algolia

Performance Cookies

These cookies help us analyze how many people are using Venngage, where they come from and how they're using it. If you opt out of these cookies, we can’t get feedback to make Venngage better for you and all our users.

Show cookie providers

  • Venngage
  • Mixpanel
  • Intercom
  • Google Analytics
  • Hotjar

Targeting Cookies

These cookies are set by our advertising partners to track your activity and show you relevant Venngage ads on other sites as you browse the internet.

Show cookie providers

  • Google Ads
  • Google Tag Manager
  • Facebook
  • Pinterest
  • Product

  • Solutions

  • Templates

  • Learn

  • Pricing

How to Import Spreadsheets Directly from Google Drive into Your Infographics and Charts

By Nadya Khoja, Feb 03, 2020

Import Spreadsheets Into Venngage for Custom Charts Header

With Venngage’s Import Spreadsheet feature, you can quickly create vibrant, insightful charts with ease. 

Whether you’re presenting data in a boardroom or a blog post, it should be engaging and attractive to your audience. In just 4 quick steps, import your data directly from a Google spreadsheet into Venngage charts and customize them like a pro.

 

1. Format your Google spreadsheet 

You need to format your data in your spreadsheet so that Venngage’s chart widgets can import the data correctly. How you format the data depends on the type of data you’re presenting.

When you’re looking at trends, time values should run along the X-axis. When arranging your data into your spreadsheet, anything in the first column will be treated as the X-axis values. So in the case of tracking trends, set your time values to the first column.

Google Spreadsheets Table Example

In the above example, Anchor (our made up SaaS company) is tracking weekly trends for registrations, creations, and upgrades from its users. The individual weeks are listed in the first column, which tells the chart widget how to arrange the data. 

In other instances, you may be sharing survey responses, onboarding responses or other data that represent parts of a whole, best represented by a pie chart. In those instances, the column with the numerical values automatically populate the chart.

Google Spreadsheets Example

 

2. Select a chart for your data

In the editor, whatever design you’re working on, you can include customizable chart widgets. From the left panel, click the Charts tab, and then choose any chart type to get started.

Venngage Editor Chart Selection Tab Screenshot

You can also check out Venngage’s chart templates page: 

Venngage Chart Templates Page Screenshot


 

3. Import your spreadsheet

To import your spreadsheet, you need to use the web link, not the share link. Here’s how to get it: 

Select File > Publish to the Web > Publish. 

1. Select File and Click Publish to the Web

How to Publish to Web with Google Spreadsheet

2. Click Publish

Google Spreadsheets, Click Publish Button Example

3. Copy the Publish Link

Google Sheets Publish to Web Copy and Paste Link Example

Privacy concerns? Don’t worry! Your spreadsheet isn’t available for just anyone on the internet to see. Your data can only be viewed by those you’ve shared this link with (like a typical share link). Copy this link and paste it into your chart widget. 

Switch over to the editor, click Edit Chart or double-click the chart itself. This opens the chart editor with the Data tab selected. Scroll down to the import field, paste the web link from your spreadsheet and click the import button.

Venngage Bar Charts Widget Customization. Upload Spreadsheet and Populate Chart Example

Like magic! You’ll see the table populated with your data, and the chart transformed by it. 

 

4. Customize your chart design

Now for the really fun stuff. There are a few ways you can customize your chart design to suit the look of your infographic design, annual report, business presentation and more. 

Under the Data tab, you can choose a number of chart types and styles. This lets you choose the right chart for your data.

If you prefer a line chart over a bar graph, or want a combination of them, you can choose them and see how your data gets visualized. This makes it easy and convenient to decide on the perfect chart type. You can also assign a color scheme for your bars and lines:

Venngage Charts Widget Style Change In Editor Example

From the Chart Style tab you can apply different looks to your charts:

Venngage Charts Widget Customization In Editor Example

Under the Settings tab, you can assign a title to your chart, choose font styles and colors, modify your borders, label your axes, and more. 

Venngage Charts Widget Customization In Editor Example

Finally, you can resize and reposition your chart once you’ve customized it. Use the bounding box to resize it. Drag and drop it with your cursor to position it.

Venngage Charts Customization In Editor Example

It doesn’t get easier than this when it comes to visualizing data! 

What else can you do with Venngage? Find out by checking out these posts to learn more!

 

Venngage Business [Features and Perks]

venngage-business-blog-header

 

40+ New Fonts, Including Chinese, Thai, Arabic!

new-fonts-header

 

How to Make an Infographic in 5 Steps 

how-to-make-an-infographic-in-5-steps-blog-header

 

How to Choose the Right Charts for Your Infographic

Venngage How to Choose Charts Blog Post Header Image

TAGS:
About Nadya Khoja

Nadya heads marketing at Venngage and has been featured in Entrepreneur, The Huffington Post, The Next Web, Forbes, Marketing Profs, Social Media Examiner and more. She also has a web-series called Drunk Entrepreneurs where she interviews different entrepreneurs who are finding success.