Visualize your Survey Data with Google Sheets and a Browser Dashboard

A beginner's guide on how to display your survey results in your web browser with the help of Google Sheets and Chartmat.

Visualize your Survey Data with Google Sheets and a Browser Dashboard
Have you conducted a survey and want to share your results? No matter whether you conducted an employee survey, a customer satisfaction survey or a public opinion survey - your challenge remains the same: you need to find a comprehensive way to present and share the results of your survey with interested stakeholders.
In the following tutorial we explore how you can visualize the results of your survey through a browser dashboard and Google Sheets. We assume that your survey data is in a format so that you can import it into Google Sheets and we will use Chartmat to build the browser dashboard to visualize your survey.

Prepare your Data

There are several tools available to conduct surveys. If you want to collect your survey data in a Google Spreadsheet you have the option to use a Chartmat form or use a survey tool such as Survey Sparrow which allows you to sync your data directly with your Google Sheets spreadsheet.
In case you are conducting your survey with another tool that does not automatically sync your survey data with Google Spreadsheets you can find an easy way to import your survey data into your Google Spreadsheet. You will typically be able to export your survey data as *.csv and can subsequently import the *.csv-file into Google Sheets.

Visualize your Survey Results

Once you have your survey data ready in your Google Sheet you can start visualizing the data through a browser Dashboard. With Chartmat you easily transform your Google Sheets data into a dashboard that is accessible from any web browser and can be shared easily. Simply complete the following steps:
  1. Sign up for a Chartmat Account
  1. Create a new Board in Chartmat and connect your Board to your Google Spreadsheet
  1. Visualize your survey data through building Chartmat Charts

How to display your Survey Results

To present the information of your survey in the most compelling way you can use Charts.
Based on the type of information you are trying to visualize you have different chart types at your disposal:
  • Pie charts: to show the percentage distribution of survey data
  • Bar charts: to display absolute numbers
  • Radar charts: to compare various variables in one single chart
  • Line chart: to show the evolution of one or various variables
At Chartmat you have all these Chart categories available. In case you have issues getting started you can simply clone our employee survey data template and start building from there. Below you see an example of a radar Chart from our survey template:
notion image
Furthermore, you can use sections to present different topics of your survey data. This is ideal in case your survey was structured into different segments.
On top Chartmat offers you a markdown block which you can fully customize. You can use these markdown blocks if you would like to comment or explain the survey results inside your Dashboard.
The demographics of the people that you survey also matter a lot. It can make sense to enable the visualization of survey results by category of respondents. For this purpose you can use filters. Filters allow the viewer to select the display of survey results by categories such as gender, employment or age.

Embed your Survey Results into a Your Personal Website

Chartmat provides you an easily accessible place to visualize your survey data. However, you might want to display your survey results on your personal website. That is not an issue at all. With Chartmat you can easily embed a single Chart or your entire Board (the combination of your Charts) into your website. Simply select the embed option in the top nav bar of your Board and you will obtain the code snippet that you need for embedding your survey results.

The Bottom Line

By completing the steps explained in this guide you are able to transform your survey data into an informative collection of charts that tells a story to the viewer. All you need in order to complete these steps is a Google Spreadsheet and a monthly subscription to a Chartmat Account.