All Collections
Connect your spreadsheets
Prepare your spreadsheet
Import data into your spreadsheet before connecting to Geckoboard
Import data into your spreadsheet before connecting to Geckoboard

Learn more about the import features of Google Sheets and Excel that can populate spreadsheets connected to Geckoboard.

Updated over a week ago

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.

๐Ÿ™ Grappling with bringing your spreadsheet data to life? Don't hesitate to contact our support team. We can build a dashboard with your Google Sheets for you.

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.

IMPORTFEED(url, query, headers, num_items)

Imports data from a table or list within an .html page.

IMPORTHTML(url, query, index)

Imports a range of cells from a specified spreadsheet.

IMPORTRANGE(spreadsheet_key, range_string)

Imports data from structured data types including .xml, .html, .csv, .tsv, and RSS and ATOM XML feeds.

IMPORTXML(url, xpath_query)

Fetches current or historical market data from Google Finance.

GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])

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 (.txt or .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.

Did this answer your question?