# Prepare your spreadsheet

Prepare your spreadsheet for Geckoboard by importing data to it, formatting it, performing calculations and reducing errors.

## Articles

- [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)