To use the COMP upload feature go to Managers, Comp Manager... and left click on the Upload Comps.
Then Choose File. Locate and select the CSV (Comma delimited) file to upload from your computer and Open.
And finally, left click on Upload File. There is no Save button. The COMP Manager screen will re-appear and your comps are uploaded and saved. See picture below.
You then need to exit Comp Manager (you can click on Home) and re-select Managers, Comp Manager to see your uploaded comps.
The file you upload must be in a specific format and a sample csv file is available.
The "price" must be in 'General' format: numbers only, no dollar ($) sign.
All cell formats are General except the Sale Date, which must be 'Date' (4/28/2016)
The .csv file you upload must have the exact amount of columns and the exact ordering of the columns as the sample file; and the Numeric Data Fields must contain the appropriate numerical value.
CSV (Comma delimited): to create a .csv file from an open Excel file "Save As" and select this file type from the 'Save as type' drop down menu.
Exact Amount and Ordering of Columns: You must have the exact amount of columns and the exact ordering of the columns. The data is not read by description of column but by the column location. If you do not have data for some columns you must still create the columns and leave them blank without data.
Numeric Data Fields: Due to the fact that that the Investment Analysis program has dropdown selections for 2 data fields - Property Type and Lot Type. – you must change the text data in each column to an appropriate numerical value for the corresponding selection. Here are the columns and the appropriate numerical fields for your text.
Column B, Property Type
Residential = 0
Commercial = 1
Land = 2
MultiFamily = 3
Retail = 4
Shopping Center = 5
Industrial = 6
Self Storage = 7
Office = 8
Hospitality = 9
Health Care = 10
Column M - Lot Type
Sq Ft = 1
Acres = 2