Google Sheets and Excel both feature many ways to import different types of data into your spreadsheet. These can be useful when preparing a Geckoboard-specific spreadsheet that fetches the data you need from a source spreadsheet.
Importing using Google Sheets
Google Sheets has built-in powerful import functions that can easily scrape data from web pages, feeds, and files.
Note: Widgets powered by spreadsheets using these functions update refresh approx. every 15 minutes.
Fetches data from a given URL in .csv (comma-separated value) or .tsv (tab-separated value) file format.
Imports an RSS or ATOM XML feed.
Imports data from a table or list within an .html page.
Imports a range of cells from a specified spreadsheet.
Imports data from structured data types including .xml, .html, .csv, .tsv, and RSS and ATOM XML feeds.
Fetches current or historical market data from Google Finance.
Scripts and third-party add-ons for Google Sheets
There are several helpful services, add-ons, and third-party tools that specialize in getting data into Google Sheets.
Sync data from APIs using JSON
Thanks to third-party developers, you can sync data from other platform's APIs into a Google Sheet.
Refresh your data daily with Supermetrics paid service
Supermetrics enables you to schedule an automatic daily refresh of your data on Google Sheets.
Importing using Excel
In Excel, you can import data from several data sources:
Import data from an Access database
Export data from an Access database in a file format that can be read by Excel.
Import data from a spreadsheet
Import data from an existing workbook, then specify the relationships between your existing data and the new data.
Import data using copy and paste
Import data from a table you've found on a web page, or any other source from which you can copy and paste into Excel. Use press Ctrl + T to format the pasted data as a table.
Import text files with Excel
There are two ways to import data from a text (
.csv) file with Excel: you can open it in Excel, or you can import it as an external data range.
Third-party add-ons for Excel
Report Builder for Adobe Analytics paid service
Report Builder is an Excel plugin that enables you to import your Adobe Analytics data into Excel.
Connect your spreadsheet to Geckoboard
With your data imported, you're all set to turn your spreadsheet into an easy-to-understand dashboard.