Importing Period Mappings from Excel

import period mappings from an Excel spreadsheet.

You can import period mappings from an Excel spreadsheet. Imported period mappings are populated automatically on the Period Mapping page.

To import period mappings from Excel:

  1. From the Data Integration home page, then from Actions menu, and then from the Setup drop-down, select Period Mapping.
  2. From the Period Mapping page, then from Actions menu, select Import From Excel.
  3. From Select File to Import page, then File, specify the name of the Excel file from which to import the period mapping.

    You can also click Image shows the File Select icon. from the File Browser page, and navigate to the Excel file.

    If the Excel spreadsheet is stored locally or on another drive, navigate to the file and then click Upload.

    Optional: To download an imported period mappings from an Excel spreadsheet, select the spreadsheet (with an xls or xlsx extension) on the File Browser page, and then clickImage shows the Download icon.. You are prompted to open or save the spreadsheet.

  4. Click OK.