# Create leaderboard widgets from spreadsheets

Learn about the various configuration options available when creating leaderboard widgets from your spreadsheet data.

May 29, 2025

# Select data for your leaderboard widget

A Leaderboard requires at least:

- 1 string series
- 1 numeric series

Click and drag to select the spreadsheet cells you want to visualize. You can also select entire rows and columns or enter the data range into the field.

# Configure your leaderboard widget

## Selection contains headers

Toggle off if your first selection cells don't contain headers.

## Reverse sort order

Toggle the switch to rank the leaderboard by lowest value first.

## Formatting

The Formatting menu allows you to overrule the automatically set number of decimal places used or add additional information about the values on your widget. For more information, see our [guide to using the data formatting options](https://support.geckoboard.com/en/articles/6055761-set-the-format-of-widget-numbers).

# Use CONCATENATE for multiple columns

If the information you want to include about the ranked items in your leaderboard spans multiple cells in your spreadsheet, you can use the `CONCATENATE` function. Available in Google Sheets and Excel, `CONCATENATE` enables you to combine the contents of two or more cells into a third separate cell.

In our example, we want to add information about the sales team each rep belongs to. `Column A` lists the name of each rep, `B` includes a dash `–` separator (to avoid a result like `NathanRed`), and `C` lists the team they belong to.

For each cell in `column D` starting from `A2`, we'll use the formula `=concatenate(A2, B2, C2)` to return `Nathan – Red`. Now, when you select `Column D` as part of your cell selection, you'll see your merged cells.