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

In Anaplan, page selectors enable you to include more dimensions in a grid than you can display with rows and columns alone. You can select different items in page selectors to change the data that displays. The Google Sheets Add-on enables you to change page selection in your worksheet, just as you would in Anaplan.

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.

Make sure you are in a Google spreadsheet that is connected to an Anaplan module.

You must be the connection owner to change page selection.

If you are not the connection owner, the Add-on features are greyed out, and a message displays the name of the connection owner. You can ask the connection owner to change the selection, or you can create a new connection in another spreadsheet and change the selection there.

When you change page selection, the connection refreshes with the latest data from Anaplan. Anaplan data replaces any edits you've made.

If you have a read-write connection you can send and refresh your worksheet before you change page selection. Send and refresh updates Anaplan with any edits you've made, so these are not lost when you change page selection.

The page selectors display in the Anaplan sidebar:

A worksheet with the Anaplan menu open in the side bar. The Pages section is highlighted, showing page selectors for Versions. The page selected, Budget, displays in blue.

To change the dimensions that display in a Google worksheet:

  1. In the Anaplan sidebar, click the arrow next to the dimension you want to change.
    The Pages menu opens.
    The current dimension displays in a drop-down menu.
    The pages for that dimension display beneath, with the current selection highlighted in blue.
A worksheet with the Pages menu open in the side bar. Underneath Pages is a drop-down menu with the current page selected. Beneath the drop-down menu is a list of the dimensions available for that page. Budget is highlighted in blue.
  1. Optionally, select a different dimension from the drop-down menu.
    The pages for the selected dimension display.
    You may swap back and forth between the dimensions and select new pages for each. All changes you make update when you refresh at the end of the procedure.
A worksheet displays with the Pages menu open. A different dimension has been selected in the drop-down menu and different pages show beneath.
  1. Select the page you want to use. To find the page, either:
  • select from the list displayed, or
  • enter the name of the dimension item in the search field.
    Any item that matches your search criteria displays and you can select the page you want to use.
A worksheet with the Pages menu open. Digital has been entered in the search field. Two pages named Digital display in a list beneath, along with the pages above them in the hierarchy.
  1. Click Refresh.
    The data in the current sheet refreshes and you're returned to the Anaplan sidebar. The connection description and Anaplan sidebar update to show your selected dimension.