Skip to main content

Insert a Dataset as a Table

Once you have created a dataset, you can bring its results into the worksheet two ways: insert it as a formatted Excel table from the task pane, or type an ASTRATO.TABLE formula. Inserting from the task pane is the usual choice because it applies the data

Insert from the Task Pane

  1. Select the cell where the table should start.

  2. Open the Astrato task pane and go to Datasets.

  3. Find your saved dataset and click the table icon beside it.

The add-in inserts the dataset's current result at the selected cell as a formatted Excel table, with the dataset's number and currency formats applied.

A dataset inserted as a formatted Excel table

To create a dataset first, see Create and Manage Datasets.

Or Use a Formula

You can also return a dataset with a formula:

=ASTRATO.TABLE("Sales")

This spills the dataset — a header row plus data rows — starting at the formula cell. Make sure the area below and to the right of the cell is empty so the result can spill.

A formula returns values only. The dataset's number and currency formats are applied when you insert or refresh from the task pane, not when a bare formula returns the data. See Excel Functions.

Refresh the Table

To update an inserted table with the latest data, use the refresh icon in the dataset list or dataset editor. Refresh reloads all known variants of the dataset. See Refresh, Cache, and Offline Behavior.

If the Table Does Not Appear

If a formula shows a #SPILL! error or the table does not appear, the spill area is probably not empty. Clear the cells below and to the right of the formula cell and try again. For other messages, see Troubleshooting.

Related Articles
Did this answer your question?