How Do You Upload A Google Sheet To Third Party

Importing live data into a Google Sheet or Excel spreadsheet might seem like a daunting task, merely information technology'due south easier than you think…

If you're reading this you probably know spreadsheets are a useful style to aggregate, tidy and analyse information. But what you probably don't know is that with some simple techniques and plugins, whatever humble spreadsheet can exist transformed into an incredibly powerful, automated, data-gathering machine that tin can save yous or your team hours of transmission input.

In this post we await at four dissimilar ways to get almost any data into a spreadsheet.

How to become data into a spreadsheet

1. Manual input

Await, aren't nosotros supposed to exist looking at ways to import live information into a spreadsheet automatically?

Well, yeah, but calculation information into a spreadsheet past hand shouldn't exist dismissed entirely. Although it might seem inefficient, there are scenarios where this is the all-time or only option for getting information into a spreadsheet:

If you're working with small-scale set of data on a ane-off basis
If your information doesn't update frequently
If the data sources you lot're working with don't let data to be exported
Every bit a quick proof of concept that could exist automated later

In addition, manually adding data to a spreadsheet can be made more efficient through outsourcing to a virtual assistant. Sites like Upwork, Freelancer.com and Fiverr make it quick and like shooting fish in a barrel to find talented individuals who tin can help with large or repetitive data entry tasks. But nosotros'll relieve that for another post.

2. Utilize a third-party data import tool

A number of services, add-ons and tools specialize in getting data from a multifariousness of sources into Google Sheets and Excel spreadsheets.

One of our favourites is Supermetrics - a flexible add-on for Google Sheets and Excel that lets you easily pull in data from many different tools, with a item focus on marketing data.

For each data source you connect to Supermetrics, y'all tin admission a comprehensive range of metrics, data and information to bring in to your spreadsheet, and it'due south even possible to schedule automatic importing of new data and then your spreadsheet always contains upwards-to-date data.

Information sources that Supermetrics supports include: Adobe Analytics, AdRoll, Google BigQuery, Google Search Console, Moz, Optimizely, Pinterest, SEMrush, and more.

Here's a quick overview of how to import data into Google Sheets using Supermetrics:

Install the Supermetrics add together-on in the G Suite Marketplace
In a Google Canvass, select Add-ons from the chief menu, so Supermetrics > Launch
Select a data source from the list of bachelor sources and authorize information technology to share data with Supermetrics
Build a query using the options available and and so click Become Information to Table

import-data-google-sheets-supermetrics

One time you're happy with the query you've built, yous tin then schedule it to re-run weekly, daily or even hourly which will fetch new data and add it to your spreadsheet. You tin as well accept Supermetrics transport a snapshot of your updated spreadsheet to an e-mail address.

refresh-email-supermetrics-spreadsheet-report-1

There are a range of similar plugins and add-ons that have their ain strengths. Some of the ones nosotros similar include:

Integromat: allows for complex workflows, filtering and blending of information before data is sent to a Google Sheet or Excel spreadsheet. Data sources supported include JSON, CSV files, RSS and XML feeds, and hundreds of third political party APIs.
Zapier: A huge range of information sources (2000+) that can manipulate or add data to a spreadsheet automatically
Google Analytics' Google Sheets add together-on: Import detailed information from Google Analytics into a Google Sail
Report Builder (Excel): If y'all use Adobe Analytics, Report Architect is a plugin that enables you lot to excerpt your Analytics information from Adobe into Excel.

Turn spreadsheet data into shareable dashboards

3. Import Functions (Google Sheets)

An entire library of functions in Google Sheets allows you to attain powerful results using simple formulae.

Google Sheets offers v dissimilar import functions (listed below) that let it to pull data into your spreadsheet from a variety of sources including XML, HTML, RSS and CSV - perfect for importing lists of blog posts, tweaks, product inventories or information from some other service.

Here are the specific functions along with the type of information they collect:

IMPORTDATA(url)
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.Run into more than detail nearly using Google Sheets' IMPORTDATA office to display CSV data hither: Using Google Sheets' ImportData office

IMPORTHTML(url, query, alphabetize)
Imports data from a table or list within an HTML webpage.Come across more detail about using Google Sheets' IMPORTHTML function hither: Using Google Sheets' ImportHTML part

IMPORTXML(url, xpath_query)
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. See more detail well-nigh using Google Sheets' IMPORTXML office here: Using google Sheets' ImportXML function

IMPORTFEED(url, query, headers, num_items)
Imports a RSS or ATOM feed.

IMPORTRANGE(spreadsheet_key, range_string)
Imports a range of cells from a specified spreadsheet.

Using these functions, you tin can easily scrape data from web pages, feeds and files. Also, a congenital-in finance function enables y'all to pull back market data.

Other useful Google Sheets functions

Creating a Inaugural Timer using Google Sheets
GOOGLEFINANCE function to display market information

four. Scripting (Google Sheets)

Scripting (or in non-technical terms - writing a short bit of custom code) can be a powerful way to go data into Google Sheets. Information technology'due south basically an easier way to write large spreadsheet formulas and functions.

Google Apps Script is a deject-based scripting language that provides easy means to automate tasks beyond Google products and other services.

Google Apps scripts are extremely flexible, and can be automatic using a variety of triggers, and although they demand more technical cognition to write and prepare, an active customs is on hand to offer guidance and help.

At Geckoboard, nosotros use Discourse to power our Community we use Google Apps Scripts to fetch data from Discourse and add it to a spreadsheet, which we then visualize on a alive dashboard to see how fundamental metrics are performing.

Hither are the steps nosotros took to pull data from our Customs to Google Sheets, to a dashboard:

Created a new Google Sheets Spreadsheet
Created a new script for our Spreadsheet (Tools > Script editor) and re-create and pasted chrislkeller'south ImportJSON functions (to exist able to import the output of Discourse'south API which is JSON).
Looked in Soapbox's API documentation for a call that returned the latest topics created in the Community
Added a new function in our script to telephone call the endpoint identified on step 3 and update cell A1 with the response
Finally, added a trigger to run the role myFunction every hour.
Used Google Sheets standard functions to identify the rows containing topics created Today and count them.
Used Geckoboard's spreadsheets integration to get the information onto a dashboard (more well-nigh this in the department below).

Google offers a multifariousness of resources to assist you make the virtually of Google Sheets using Google Apps Scripts. You might observe some of their examples useful to become your data into Google Sheets.

Beyond spreadsheets: visualizing and sharing your data

Want to have your spreadsheet game even further? Now that you've imported data from various sources into your Google Sheets and Excel spreadsheets, you can easily visualize and share this information using a dashboard.

excel-example-dashboard-geckoboard

Learn more than about this Excel dashboard example here.

The instance above contains a variety of visualizations powered by data in a spreadsheet, which updates automatically to bear witness up-to-the-infinitesimal data.

Here's how it works

Create your spreadsheet in Google Sheets or Excel (importing data from via the steps mentioned earlier in this post)
Sign upwards for a free Geckoboard business relationship
Select 'Add dashboard', then 'Add together widget'
Pick the 'Spreadsheet' integration from the listing of data sources.
Select your information and choose a visualization
Build out your dashboard by adding more visualizations

Scout this in action in the video below!