Connect your spreadsheets

Pull in data from Google Sheets and Excel spreadsheets.

Richard Ingram avatar Kelsey Milner avatar
50 articles in this collection
Written by Richard Ingram and Kelsey Milner
Build widgets from spreadsheets

Customize spreadsheets widgets

Learn how to adjust presentation options and filter your spreadsheets data to create easy-to-understand visualizations.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create gauge widgets from spreadsheets

Learn about the various configuration options available when creating gauge widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create line chart widgets from spreadsheets

Learn about the various configuration options available when creating line chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create number widgets from spreadsheets

Learn about the various configuration options available when creating number widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create column chart widgets from spreadsheets

Learn about the various configuration options available when creating column chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create bar chart widgets from spreadsheets

Learn about the various configuration options available when creating bar chart widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create leaderboard widgets from spreadsheets

Learn about the various configuration options available when creating leaderboard widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create table widgets from spreadsheets

Learn about the various configuration options available when creating table widgets from your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create text widgets from spreadsheets

Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create dynamic spreadsheet widgets

Including pre-populated cells in your cell selection means your spreadsheet widgets will automatically respond as data is added.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Compare two numbers in your spreadsheet

Compare your selected spreadsheet cell with a choice of four comparison visualizations: goal, number, percentage, and sparkline.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display data from pivot tables in Geckoboard

Learn how to retrieve pivot table data by using ImportRange to reproduce the pivot table in a new Google sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create multiple series charts using spreadsheets

Learn how to add multiple series of data to line and column charts using data from spreadsheets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add goals to track progress on your spreadsheet data

Goals are shown as progress bars on number widgets and shaded areas on line, column and bar charts.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Highlight important changes to your spreadsheet data

Add status indicators to number and gauge widgets to spot important changes to your spreadsheet data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create a event countdown Number widget

Learn how to build a widget displaying a countdown number.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Add milestones to a table widget

Build a table widget displaying milestones from a Google Sheet or Excel file.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Highlight table widget cells in spreadsheets using Emoji

Steps to build a table widget with conditional color-based Emoji.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Forms to collect information and display it on a dashboard

Collect user-generated data, like quick polls to full-on questionnaires, and display it on a dashboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Display a 'quote of the day' text widget using spreadsheets

Steps to display a daily inspirational quote on your dashboard using our Spreadsheets data source.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

How to build visualizations from data dumps

Guidance for how to take a data dump and use formulas in a new sheet to build visualizations.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Refresh rate for Spreadsheet widgets

Widgets refresh every 15 mins, except when powered by a Google Sheet where it's within 3 mins from the sheet's last update.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Manually refresh Spreadsheets widgets

Steps to refresh your Spreadsheet widget while you're building and editing it.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ ImportData function to display online data in Geckoboard

Learn how the ImportData function pairs with our Spreadsheet data source to build visualizations from CSV files.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ ImportHTML function to display data in Geckoboard

Learn how the ImportHTML function imports data from a table or list within a website into a Google Sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use ImportRange to extract data needed for Geckoboard to a new spreadsheet

Learn how Google Sheets' ImportRange function helps import data samples and run calculations in a separate sheet from the source.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Use Google Sheets’ GoogleFinance function to display data in Geckoboard

Learn how the GoogleFinance function pairs with our Spreadsheets data source to display market data on your Geckoboard dashboard.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Create a weather widget using Google Sheets

Steps to build a widget displaying temperature and weather using weatherstack data.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago
Spreadsheets troubleshooting

Excel spreadsheet file not showing in Geckoboard

Check if your file is saved in a different format from .xlsx.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheet FetchError: 'Could not find spreadsheet file'

Check that your share settings are set correctly and if you have the right type of sharing link.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheets error: 'Error fetching the list of spreadsheets'

Check if "Allow users to install Google Drive apps" in the "Data Access" menu is enabled.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheet import error: 'This worksheet is too large to import'

Steps to avoid hitting the 5MB file size limit for connected spreadsheets.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Connected Excel spreadsheet not updating after making changes

This might be due to your changes occurring in-between refreshes, or your uploaded file failed to overwrite an older version.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Deleted spreadsheet on Google Drive still powering widgets

Files in your Google Drive Trash folder are still, in effect, regarded as active documents until emptied.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Spreadsheets error: 'Cannot read property "offsetWidth" of undefined'

This error will occur if you only have one row of data to select from.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

X-Axis dates not display correctly on charts

This often occurs when X-Axis dates are being calculated by a formula, or when they're sourced from another sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago

Pivot table sheet is empty

You'll need to use ImportRange to reproduce the pivot table in a new sheet.
Richard Ingram avatar
Written by Richard Ingram
Updated over a week ago