# Refresh rates for Spreadsheets widgets

Spreadsheets refresh rates vary depending on the source location and configuration of your data.

April 15, 2025

## Table of contents

- [Refresh rates for Google Sheets](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_a20c3a5833)
- [Refresh rates for .xlsx files](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_1f02b1aefa)
- [Refresh rate when using import functions](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_46edd84801)
- [How to manually refresh widgets](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_34b05d4085)
- [Manually refresh your spreadsheet while adding a new widget](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_4823770a49)
- [Manually refresh your spreadsheet while editing a widget](https://support.geckoboard.com/en/articles/6055673-refresh-rates-for-spreadsheets-widgets#h_ecca4fab33)

## Refresh rates for Google Sheets

Google Sheets [connected via Google Drive](https://support.geckoboard.com/en/articles/6055517-connect-your-google-sheet-to-geckoboard) automatically refresh within **3 minutes** from the spreadsheet's last update.

Google Sheets [connected via a direct link](https://support.geckoboard.com/en/articles/6055642-make-your-connected-google-sheet-private) will refresh **every 15 minutes**.

## Refresh rates for .xlsx files

For `.xlsx` files hosted in Google Drive, Dropbox, or OneDrive, the refresh rate is around every **15 minutes**.

## Refresh rate when using import functions

Widgets powered by [import functions](https://support.geckoboard.com/en/articles/7883050-use-import-functions-to-get-data-into-a-spreadsheet), such as ImportRange or ImportData, automatically refresh around every **15 minutes**.

Be aware, though, that using data from multiple import functions with their own refresh intervals in the same connected spreadsheet can affect the accuracy of the data displayed.

Need a faster refresh? Learn how to use Apps Script to [speed up the refresh rate](https://support.geckoboard.com/en/articles/6055647-set-refresh-rate-for-spreadsheets-widgets-powered-by-import-functions).

## How to manually refresh widgets

### Manually refresh your spreadsheet while adding a new widget

After connecting your spreadsheet to Geckoboard, you'll reach the select data screen.

Click the **Refresh sheet** in the bottom left corner:

### Manually refresh your spreadsheet while editing a widget

To manually refresh a spreadsheet that's powering an existing widget, simply edit the widget. Then click **Reload spreadsheet**.