We design powerfulGoogle Sheets resourcestoaccessandhandle datain an easy way

Bad decisions often come from a lack of data, or a lack of analysis of existing data.Unfortunately, not everyone has access to a BI (business intelligence) department in order to collect, examine, and provide insights based on data.The good news is, because spreadsheets are so intuitive, finding, structuring, and mining insights from data is within the reach of anyone.We build and share Google Sheets resources and add-ons that enhance the experience of collecting and analyzing data at scale.

ImportFromWeb is a Google Sheets add-on that adds a new function to import data from public websites directly into a Google Sheet. Unlike ImportXML and other native functions, it supports most websites and has many additional options that make it a powerful tool for data collection and cleaning.

As the name implies, ImportJSON imports JSON-formatted data into Google Sheets. It supports importing and parsing JSON from any URL in Google Sheets, and filtering the results to get only what you need.