1. Anaplan User Experience
  2. Build apps and pages in the User Experience
  3. Build pages
  4. Manage actions for a page
  5. Add import actions to a page

Import actions enable you to easily import large amounts of data into your apps. This removes the need for end users to manually input data.

Your import actions must be configured in the source model by a workspace administrator before being added to a page.

Configure imports on a worksheet toolbar to enable users to update modules and pages with the latest data for planning activities.

Users can import data from spreadsheets, databases, or other accounting and reporting systems to populate and update Anaplan models.

Imports are typically performed using flat files that are tab separated or comma separated (.csv), but you can specify a different separator, such as a semi-colon (;) or a pipe (|).

You can also use action cards to enable end users to run import actions on a worksheet or a board. To learn how to add an action card to a board or worksheet, see Configure an action card.

Note: Import actions in the user experience behave differently from the modeling experience. In this case, the import:

  • is always private.
  • data source does not save to the model.
    This means that every time you run an import it will ask you to pick a file and upload again.
  • does not replace or alter any imports set up in the model.

Add an import action to a worksheet toolbar

To add an import action to the toolbar of the worksheet you are building:

  1. Open your worksheet in designer mode.
  2. Click Edit toolbar actions.
  3. Select Imports.
    The import actions displayed are defined in the source module.
    Type part of the name of an action into the Find... field to narrow down the list of imports.
The Edit toolbar actions dialog, with the Import tab highlighted.
  1. In the Enable column, move the toggle to the right to add an action to a worksheet's toolbar.
    Move the toggle to the left to remove an action from a worksheet's toolbar.
  2. Optionally, type into the field under Toolbar label to change the label for an enabled import action. The default label is the name defined for an action in the source model.
    Use an easy-to-understand label to ensure end users know what the import action is for.
A action titled 'Region L2 from Region L2.csv' is enabled, and therefore a field to edit the Toolbar label has appeared.
  1. Click Update.
    You can continue to design or edit the worksheet.
  2. When you have finished designing or editing the worksheet, click Publish.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.