# Create number widgets from spreadsheets

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

**Date:** May 29, 2025

This guide walks you through the various options available when creating number widgets from your spreadsheet data.

## Select data for your number widget

Select at least one numeric column or a specific cell from your connected spreadsheet. Then you'll be taken to the configuration page where you can make further adjustments if needed.

## Configure your number widget

### Add status indicators

Adding success and/or negative values to your number widgets allows you to draw attention to changes as they happen.

1. Navigate to the status indicator setting in your configuration menu.
2. Choose success or negative indicators as required.

### Add comparison visualization

The number widget allows you to compare the primary metric visually using four comparison visualizations: goal, number, percentage, and sparkline.

Click the **Comparison visualization** panel to display the options. Your spreadsheet canvas will automatically appear for you to select your comparison range.

### Goal

Displays a goal progress bar below the primary metric.

Enter your goal target value and, optionally, your starting value to define where your goal progress starts from.

### Number

Displays the number change from your initial selected cell. Click the up or down arrows to indicate whether an increased or decreased change is good.

### Percentage

Displays the percentage change from your initially selected cell. Click the up or down arrows to indicate whether an increased or decreased percentage change is good.

### Sparkline

Displays a small line chart of the values in the selected range (top to bottom or left to right). The more cells in your selected range, the more detailed your sparkline will be.

### 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).

### Add dynamic selection

The Dynamic selection menu enables you to expand your initial single-cell selection to a whole column or row. Your number widget will always display the last numeric value added to the column or row.

* * *