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. In Select File to Import page, click File Browser and specify the name of the Excel file from which to import the period mapping.
    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.