[New Feature] Import Spreadsheets Directly From Google Drive

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.

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.

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.

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

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

2. Click Publish

3. Copy the Publish Link

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.

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:

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

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.

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.