# Connect your spreadsheets

Pull in data from Google Sheets and Excel spreadsheets.

## Prepare your spreadsheet

- [Prepare your spreadsheet before connecting to Geckoboard](https://support.geckoboard.com/en/articles/6055516-prepare-your-spreadsheet-before-connecting-to-geckoboard)
- [Use Import functions to get data into a spreadsheet](https://support.geckoboard.com/en/articles/7883050-use-import-functions-to-get-data-into-a-spreadsheet)
- [Use ImportRange to extract data needed for Geckoboard to a new spreadsheet](https://support.geckoboard.com/en/articles/6055680-use-importrange-to-extract-data-needed-for-geckoboard-to-a-new-spreadsheet)
- [Calculate spreadsheet data before connecting to Geckoboard](https://support.geckoboard.com/en/articles/7066669-calculate-spreadsheet-data-before-connecting-to-geckoboard)
- [Calculate the number of unique values in a spreadsheet column](https://support.geckoboard.com/en/articles/7834232-calculate-the-number-of-unique-values-in-a-spreadsheet-column)
- [Set refresh rate for Spreadsheets widgets powered by import functions](https://support.geckoboard.com/en/articles/6055647-set-refresh-rate-for-spreadsheets-widgets-powered-by-import-functions)

## Connect your spreadsheet

- [Connect Excel file or Google Sheets to visualize your spreadsheet data](https://support.geckoboard.com/en/articles/6055538-connect-excel-file-or-google-sheets-to-visualize-your-spreadsheet-data)
- [Send data from Google Sheets to Datasets](https://support.geckoboard.com/en/articles/6175261-send-data-from-google-sheets-to-datasets)
- [Grant admin consent to connect OneDrive or SharePoint to Geckoboard](https://support.geckoboard.com/en/articles/9450780-grant-admin-consent-to-connect-onedrive-or-sharepoint-to-geckoboard)

## Build widgets from spreadsheets

- [How to build a spreadsheet dashboard](https://support.geckoboard.com/en/articles/10245293-how-to-build-a-spreadsheet-dashboard)
- [Create leaderboard widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055622-create-leaderboard-widgets-from-spreadsheets)
- [Create gauge widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055563-create-gauge-widgets-from-spreadsheets)
- [Create line chart widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055586-create-line-chart-widgets-from-spreadsheets)
- [Create number widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055539-create-number-widgets-from-spreadsheets)
- [Create column chart widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055601-create-column-chart-widgets-from-spreadsheets)
- [Create bar chart widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055613-create-bar-chart-widgets-from-spreadsheets)
- [Create table widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055630-create-table-widgets-from-spreadsheets)
- [Create text widgets from spreadsheets](https://support.geckoboard.com/en/articles/6055644-create-text-widgets-from-spreadsheets)
- [Create dynamic spreadsheet widgets](https://support.geckoboard.com/en/articles/6055666-create-dynamic-spreadsheet-widgets)
- [Compare data within your Spreadsheets widgets](https://support.geckoboard.com/en/articles/6055661-compare-data-within-your-spreadsheets-widgets)
- [Create multiple series charts using spreadsheets](https://support.geckoboard.com/en/articles/6055650-create-multiple-series-charts-using-spreadsheets)
- [Create an event countdown with a Number widget using a Google Sheet](https://support.geckoboard.com/en/articles/6055602-create-an-event-countdown-with-a-number-widget-using-a-google-sheet)
- [Add milestones to a table widget](https://support.geckoboard.com/en/articles/6068251-add-milestones-to-a-table-widget)
- [Highlight table widget cells in spreadsheets using emoji](https://support.geckoboard.com/en/articles/6055670-highlight-table-widget-cells-in-spreadsheets-using-emoji)
- [Use Google Forms to collect information and display it on a dashboard](https://support.geckoboard.com/en/articles/6191117-use-google-forms-to-collect-information-and-display-it-on-a-dashboard)
- [How to build visualizations from raw data](https://support.geckoboard.com/en/articles/6055667-how-to-build-visualizations-from-raw-data)
- [Refresh rates for Spreadsheets widgets](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets)
- [Use ImportData to get CSV data into Google Sheets and display it in Geckoboard](https://support.geckoboard.com/en/articles/6055677-use-importdata-to-get-csv-data-into-google-sheets-and-display-it-in-geckoboard)
- [Use ImportHTML to bring data into a Google Sheet and display it in Geckoboard](https://support.geckoboard.com/en/articles/6055678-use-importhtml-to-bring-data-into-a-google-sheet-and-display-it-in-geckoboard)
- [Use GoogleFinance to display market data in Geckoboard](https://support.geckoboard.com/en/articles/6055679-use-googlefinance-to-display-market-data-in-geckoboard)
- [Create a weather widget using Weatherstack and Google Sheets](https://support.geckoboard.com/en/articles/6055588-create-a-weather-widget-using-weatherstack-and-google-sheets)
- [Import Looker data into Geckoboard using Google Sheets](https://support.geckoboard.com/en/articles/8182178-import-looker-data-into-geckoboard-using-google-sheets)
- [Display Google Calendar events on your dashboard via Google Sheets](https://support.geckoboard.com/en/articles/8426541-display-google-calendar-events-on-your-dashboard-via-google-sheets)
- [Export Power BI data to Excel and display in Geckoboard using Spreadsheets](https://support.geckoboard.com/en/articles/10593389-export-power-bi-data-to-excel-and-display-in-geckoboard-using-spreadsheets)

## Spreadsheets troubleshooting

- [Troubleshoot Spreadsheets issues](https://support.geckoboard.com/en/articles/11096428-troubleshoot-spreadsheets-issues)

## Discover more

- [Aggregate Google Adwords and AdSense data in Google Sheets](https://support.geckoboard.com/en/articles/6055543-aggregate-google-adwords-and-adsense-data-in-google-sheets)
- [Use Google Apps Script to import Stripe data to Google Sheets](https://support.geckoboard.com/en/articles/6055578-use-google-apps-script-to-import-stripe-data-to-google-sheets)
- [Use Google Apps Script to import Richpanel data to Google Sheets](https://support.geckoboard.com/en/articles/8371001-use-google-apps-script-to-import-richpanel-data-to-google-sheets)