Importing and Exporting Plans

Extended Planning and Analysis enables you to export, import, and reimport plans in Microsoft Excel Spreadsheet (XLSX) format. This section provides information about export and import scenarios.

You can export a plan as an XLSX file to enable others in your organization to make changes and import the plan back into Extended Planning and Analysis. To export and edit a plan as an XLSX file and reimport it to Extended Planning and Analysis, the plan structure in Excel must remain the same as in Planning. Refer to the following criteria when creating your data import spreadsheet:

  • You can add, modify, or delete columns or rows and numeric values.
  • Cell values must be numeric.
  • Ensure all information you want to import is contained in one sheet of the XLSX file.
  • Dimensions and measures must remain the same. You cannot add, modify, or delete them.
  • All dimension value name combinations and column names must be unique.

Exporting Plans

Extended Planning and Analysis enables you to export a complete plan or a specific section as an XLSX file. You can export a specific section if you want to filter your results to show only a particular dimension or measure.

Notes:
  • Only plan owners and users with permission can edit an exported plan.
  • Read-only users do not have permission to export plans.
  • By default, an exported plan's file name matches the plan name.
  • All plan data is contained in one sheet of the XLSX file.
  • All cells that contain a formula are exported as numeric values.

To export a plan as an XLSX file:

  1. From the Plans tab, navigate to a specific plan.
  2. From the Plan quick actions, do one of the following:
    1. To export a complete plan, click Export as XLSX.
    2. To export a section of a plan, navigate to a specific section of the plan and click Export as XLSX.

Importing Plans

To import a plan from an XLXS file:

  1. From the Plans tab, navigate to a specific plan.
  2. From the Plan quick actions, click Import from XLSX.
  3. Click Upload Files.
  4. Select or drag and drop the file you want to import and click Open.
  5. Select a sheet.
  6. Select an import process type.
  7. Click Import.