1. Import and export data
  2. Export basics
  3. Export data from modules

Workspace administrators can export module data from a model. This type of export includes a module's dimensions, line items, and cell data.

You must be a workspace administrator with a model role that has access to the module you want to export. If you are not a workspace administrator, you can only export module grid data from dashboards you have access to.

You can export module data in three ways. Navigate to the Modules pane to export high-level details for all modules in your model, go to the module grid view to export grid data, or go to the module Blueprint to export Blueprint data.

To export module data: 

  1. Select Data > Export.
  2. In the Export dialog, in the Layout tab, select the file type for the export. 
    • For unformatted file types, select the Use digits setting for unformatted exports checkbox to export numbers without decimal separators. For example, 1,000,000 exports as 1000000.
  3. In Layout, select the grid, single column table, or multiple column table layout for the export.
  4. Optionally, in the Labels tab, select the Include Row Label Headers checkbox to include row headers in the export.
    For example, in an XLS file, the model component positioned on rows in your module displays as a header in the A1 cell. This might be Line items, or the Call Centers list.
  5. Optionally, in Labels, select the list labels you want to include in the export.
    You can include list item names, codes, and properties. The default label is Name. You can select X next to a label to remove it from the export.
  6. If the export contains line items with list data types, in the Line Items of Data-Type "List" tab, select the dropdown under the list's name to export list item name or codes.
  7. If you want to save your export settings to run the export again, select the Save Export Definition checkbox at the bottom of the Export dialog. Then:
    1. In the Export Name field, type a name for the export.
    2. Choose whether to share the file with Administrators only or Everyone, or select Myself (keep private).
  8. Select Run Export.

If you saved the export definition, you can add the export to a process or publish it to a dashboard. Page builders can add it to an action card in the UX.

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.