Import Spreadsheets Directly From Google Drive Into Your Infographics and Charts

By Nadya Khoja, Mar 31, 2015

import spreadsheet

This week we’ve added a few new features to Venngage. You asked, we provided. Sometimes that’s all it takes. Now you can import spreadsheets to your charts directly from Google Drive. Let me break it down for you so that the process is an easy one.

1. Start out by dragging any chart into your workspace

Open the Charts tab in the side menu and pick the type of chart you want to create.

import spreadsheet

2. Get the web link for your Google Sheet

Open your spreadsheet and click File > Publish. Then, copy the web link.

import spreadsheet

3. Import your spreadsheet data

Open the chart editor by double clicking on the chart. Then, paste the web link to your spreadsheet under the data table and click Import. It may take a few minutes for the data to import.

import spreadsheet

4. Customize your chart design

Success! Your data has been imported. Now you can customize your chart design. Change the colors, fonts, and label settings.

import spreadsheet

 

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.