Analyze your Google Sheets data with ZoomCharts Spreadsheet Analytics

Jan 05, 2017

ZoomCharts Spreadsheet Analytics is a tool that allows you to receive an instant interactive report out of your spreadsheet data just by browsing that file.
Learn more about ZoomCharts Spreadsheet Analytics


Spreadsheet Analytics supports various data sources, like Microsoft Excel, POST data or JSON.
We also support Google Sheets. And here we will show you how easy it is to analyze your Google Sheets Data.

Step 1. Go to Google Sheets

First you need to login into your Google account and access Google Sheets.

Step 2. Open file for editing

Select your desired file or create a new one.
Or just take a look at our Google Sheets sample document.

Step 3. Format your file structure

When creating a file, the format should comply with these simple rules:
  • 1) by default the first sheet of your excel file will be analyzed (or the one with name "Data");
  • 2) you may have as many columns as you want - each column will have a separate PieChart by default;
  • 3) make sure that the column names are on the first row;
  • 4) make sure that data items goes in rows with details in columns;
  • 5) dates and numeric values will be automatically recognized and offered for selection in the interactive reporting interface;
  • 6) remove any other unrelated information or blocks.
Your data should look something like this:

Step 5. Get a public link to your Google Sheets file

Do this by clicking on a "share" button at the top right corner of Google Sheets and then click on "get share link" button.
This link will be needed later on, so copy that.

Step 6. Access ZoomCharts Spreadsheet Analytics

Open Spreadsheet Analytics and login to your existing account or start a 30 day trial.

Step 7. Choose Advanced data sources

Click on a "Show advanced data source options" link below the large green "browse" button.


Step 8. Select Google Sheets from available options



Step 9. Input your desired Google Sheets file

Paste your Google Sheets shared link (that you received in step #5) in a field and then press "Add" button.


Step 10. Try it yourself and enjoy your interactive report


Try Spreadsheet Analytics now!

Use sharing option to share your interactive report with your colleagues or friends. Use embedding option to include your interactive dashboard in to a web page.

This is how an embedded interactive report looks like



Comments

Online Examples

See various ZoomCharts exmaples in our online examples gallery. Each of examples has sample source code exposed.

See ZoomCharts examples

ZoomCharts Pricing

ZoomCharts licensing is transparent and simple, yet widely configurable to fit your company's needs and budget.

See pricing

Webinar "Power Up Your Power BI Reports" with our partner in Poland - EBIS

ZoomCharts and its partner in Poland EBIS are inviting Power BI specialists to join the online training session "Power Up Your Power BI Reports". The session... Read More

Nov 19, 2020

Online training session on Drill Down Visuals with our partner in Ukraine - Megatrade

ZoomCharts is partnering up with Megatrade, one of the largest distributors in Ukraine specializing in IT products and software, to ensure better access to... Read More

Nov 16, 2020

Introducing new custom visual - Drill Down Map PRO

Drill Down Map PRO custom visual by ZoomCharts stands out among other map visuals with powerful on-chart filtering capabilities and rich customization options.... Read More

Nov 10, 2020

Use case for a Drill Down Graph PRO visual: analyzing internal email communication

With the latest 1.6 release (September, 2020), ZoomCharts Drill Down Graph PRO has become more powerful than ever, enabling users to detect patterns,... Read More

Sep 22, 2020

Use case for a graph visual: mapping subsidiaries of an international organization

ZoomCharts Drill Down Graph PRO offers multiple layout options and unseen level of interaction. In this article we will explore a use case of mapping parent... Read More

Sep 22, 2020

September 2020 product release - extended measure support, powerful new features for graph visual and a redesigned trial experience

Just in time for a fall season, ZoomCharts is releasing the 1.6. version of the Drill Down Visuals. Along with multiple smaller yet nifty improvements, this... Read More

Sep 22, 2020