# Create text widgets from spreadsheets

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

May 29, 2025

## Select data for your text widget

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. Text widgets require at least one date or string column.

## Configure your text widget

### 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 the 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**.