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 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

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.