Create text widgets from spreadsheets

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

Select data for your text widget

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. Text widgets can contain one column, or one cell.

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

Edits to your source spreadsheet

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.change the sheet by clicking in the bottom right corner

If you need to extract the data you need from one spreadsheet to another for your dashboard widgets, see our article on preparing your spreadsheet for Geckoboard

Preview your text widget

Next, you'll see highlighted visualization options for your selection. Click the text 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 >.

Switch to reading data in rows

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

Configure your text widget

Visualization type

The visualization picker allows you to switch between the available options.Widget config for text widgets built with spreadsheets

Text visualization options

If you select a column or multiple cells, you can either select Only show last message to display the last cell in your selection. For example, if cells A1:A10 are selected, only the message in cell A10 will be displayed.

Or select Loop through messages to display the text content of up to 5 cells in a 10 second loop. For example, if cells A1:A10 are selected, the messages in cells A6:A10 will be displayed. If you have a column title included in your cell selection, you can toggle the switch to Ignore the first selected cell.spreadsheets text widget with a loop of 5 messages

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.