Analyze your Google Sheets data with ZoomCharts Spreadsheet Analytics
Jan 05, 2017
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.
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
Subscribe to news
Subscribe to our newsletter and be among the first ones to receive updates about latest developments, releases and other useful information that will help you get the most of our visuals.
Online Examples
See various ZoomCharts exmaples in our online examples gallery. Each of examples has sample source code exposed.
See ZoomCharts examplesZoomCharts Pricing
ZoomCharts licensing is transparent and simple, yet widely configurable to fit your company's needs and budget.
See pricingZoomCharts JavaScript Charts: Best New Features of 2022
2022 was a big year for data visualization, and it was an even bigger year for ZoomCharts JavaScript Charts. We implemented many useful and much-requested features such as conditional formatting, new data aggregation options, and more. We’re even more excited to share the upcoming features that you can expect in 2023. Read all about them!
Read More Dec 22, 2022Analyze your Google Sheets data with ZoomCharts Spreadsheet Analytics
ZoomCharts Spreadsheet Analytics is a tool that allows you to receive an instant interactive report out of your spreadsheet data just by browsing that... Read More
Jan 05, 2017Turn your spreadsheets into interactive reports in seconds
We introduce Spreadsheet Analytics. That means there is a new way to visualize and explore your spreadsheet data. Spreadsheet Analytics is an application build... Read More
Nov 09, 2016Arrange a Meeting with ZoomCharts at Collision in New Orleans
We are excited to be exhibiting at Collision tech conference in New Orleans on April 26-28. Attending this top-notch event? Pre-arrange a meeting with... Read More
Apr 14, 2016data visualizationdata visualisationcollisionconferencetech conferencedata visualization conferencebig datahtml5 charts and graphsjavascript graphs and chartshtml5 charts and graph libraryhtml5 chartshtml5 graphsjavascript graphsjavascript chartschart librarygraph libraryinteractive chartsinteractive graphs
Meet Us at Data Visualization Summit in San Francisco
Hello the West Coast, we are coming! Happy to exhibit at Data Visualization Summit in San Francisco on April 21-22. Want to meet us there and get an exclusive... Read More
Apr 14, 2016data visualizationdata visualisationdata visualization summitdata visualization summit san franciscoconferencetech conferencedata visualization conferencebig datahtml5 charts and graphsjavascript graphs and chartshtml5 charts and graph libraryhtml5 chartshtml5 graphsjavascript graphsjavascript chartschart librarygraph libraryinteractive chartsinteractive graphs
Case Study: Meemim Uses NetChart to Build an Enterprise Collaboration Platform
Canadian start-up Meemim believes that visualization and social networking can lead to better knowledge management. Meemim’s CEO Alexandre Pestov tells us... Read More
Mar 29, 2016