1. Extensions
  2. Google Sheets Add-on
  3. View and edit Anaplan data in Google Sheets
  4. View dimensions

You can view which dimensions of your Google worksheet are assigned to rows, columns, or pages.

The Google Sheets Add-on is in early access (EA), and is only available to participants of the EA program.

Find out more about early access or how to register your interest in our current EA programs.

Only the connection owner can use Preview to view the connection dimensions.

If you are not the connection owner, the Add-on features are grayed out, and a message displays the name of the connection owner in the sidebar. If you need to view the dimensions for rows and columns, ask the connection owner to preview the connection dimensions. 

You can also view other connection details in the top left of the worksheet. This displays:

  • when the connection was last refreshed,
  • the workspace,
  • the model,
  • the module,
  • the saved view, 
  • page dimensions, and
  • the refresh status.

To have full use of the Add-on features, Create a new connection yourself in another spreadsheet.

Note: You can only pivot the dimensions of your worksheet in the Anaplan module you connect your worksheet to.

To view the dimensions of your worksheet:

  1. Click Preview in the Anaplan menu.
    The Preview connection dialog displays.
    Pages display in the Pages box at the top, rows display in the lower left Rows box, and columns display in the lower right Columns box.
    Next to each dimension name is a number in brackets displaying how many items there are in each dimension.
  2. Optionally, click Refresh to refresh the connection.
    If you pivoted the dimensions in Anaplan, the changes display.
  3. Click Cancel or the X in the top-right corner to exit the dialog and return to your worksheet.