Creating Excel Import Maps
Before you can import an Excel spreadsheet, you must map the relationships between the Excel data and Strategic Finance data.
To create Excel import maps:
From any Strategic Finance view, select File, then Import, then From Excel File, then Create New Map.
In Select Excel-format Spreadsheet to Import, open an Excel file.
Using these procedures, edit the map:
Click OK.
In Save Map As, enter a name for the map (*.mpr), and click Save.