Connect your spreadsheets | Geckoboard Help Center
Connect your spreadsheets
Pull in data from Google Sheets and Excel spreadsheets.
Prepare your spreadsheet
- Prepare your spreadsheet before connecting to Geckoboard
- Use Import functions to get data into a spreadsheet
- Use ImportRange to extract data needed for Geckoboard to a new spreadsheet
- Calculate spreadsheet data before connecting to Geckoboard
- Calculate the number of unique values in a spreadsheet column
- Set refresh rate for Spreadsheets widgets powered by import functions
Connect your spreadsheet
- Connect Excel file or Google Sheets to visualize your spreadsheet data
- Send data from Google Sheets to Datasets
- Grant admin consent to connect OneDrive or SharePoint to Geckoboard
Build widgets from spreadsheets
- How to build a spreadsheet dashboard
- Create leaderboard widgets from spreadsheets
- Create gauge widgets from spreadsheets
- Create line chart widgets from spreadsheets
- Create number widgets from spreadsheets
- Create column chart widgets from spreadsheets
- Create bar chart widgets from spreadsheets
- Create table widgets from spreadsheets
- Create text widgets from spreadsheets
- Create dynamic spreadsheet widgets
- Compare data within your Spreadsheets widgets
- Create multiple series charts using spreadsheets
- Create an event countdown with a Number widget using a Google Sheet
- Add milestones to a table widget
- Highlight table widget cells in spreadsheets using emoji
- Use Google Forms to collect information and display it on a dashboard
- How to build visualizations from raw data
- Refresh rates for Spreadsheets widgets
- 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
- Use GoogleFinance to display market data in Geckoboard
- Create a weather widget using Weatherstack and Google Sheets
- Import Looker data into Geckoboard using Google Sheets
- Display Google Calendar events on your dashboard via Google Sheets
- Export Power BI data to Excel and display in Geckoboard using Spreadsheets