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

Click 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. Table widgets display 10 or fewer columns.

When you're happy with your selection, click Create visualization.

If you need to make any edits to your spreadsheet you can manually refresh it from the bottom left corner of the screen. From here you can also switch to a different sheet.

If your source spreadsheet is large and complex you might benefit from extracting the data you need to another spreadsheet specifically for powering your dashboard widgets. For more information, see preparing your spreadsheet for Geckoboard.

Next, you'll see highlighted visualization options for your selection. Click the table icon. In the bottom corner a preview shows how your widget will look.

To select different cells, hover over the spreadsheet and click to edit selection.

When you're happy with your selection, click Continue >.

By default, Geckoboard reads the data in columns. When your data series is arranged in rows, click the Switch rows and columns.

The visualization picker allows you to switch between the available options.

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

Click drag each column to change the order that they'll appear on your widget.

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.