Narrative1's Upload Excel is an optional installation utility that allows you to import a collection of comps stored within a Microsoft Excel file into your database. This is an effective means of adding comp data to your database if it was downloaded from a Multiple Listing Services (MLS) file export, or from another N1 user.
Download the latest version of Upload Excel:
Upload Excel can be accessed from the following location:
- From the Windows Start menu:
- Start > All Programs > Narrative1 > Narrative1 Utilities > Upload Excel
Please refer to the below image to learn if your Excel file is compatible with the Upload Excel tool.
The Excel file should be formatted as a "flat file", meaning the top row should include data headers (Street Name, Town, State, Etc), and each row under the header should be a comp record.
Be sure the Excel file does not have blank rows or any cells with errors if there are calculations on the worksheet.
Fields with numeric and date values should be free of text. For example, GBA should only have a number such as "65,000", and not "65,000 SF".
The data must be on the first worksheet in the Excel workbook.
- The Appraisal Usage field is set to "comparable" by default.
- ReadyForUse is set to "not ready for use" by default. Toggle with 0 (not ready) or 1 (ready).
- Is Ground Lease is set to "False" by default. Toggle with 0 (not a ground lease) or 1 (is a ground lease).
How to Upload a File Using Upload Excel
1. Select File to Upload
Begin by clicking Select File to Upload, and selecting the Excel file you wish to upload. Ensure that the selected file follows the guidelines depicted in the File Requirements section above.
2. Match Your Data Headers to the Database Fields
Once you select a Data Field Type, two columns will appear: the left-most column represents the column data headers in your Excel file, and the right-most column contains the database fields.
Click into the empty left-most fields and match them with the adjacent database fields. For example, if your Excel file had a column dedicated to Property Types, you would match it with the Property Type field.
3. Optional: Add Field
If you have a particular field that exists within your Excel file, but not in the database, you can utilize the Add Field button to create the required field.
The Add Field menu - illustrated above - allows you to create and format your desired field.
Field Name: Type in the name of your custom field.
Insert After: Select an existing field for your new field to be placed after. This is only for organizational purposes and determines where it is located in your list.
Data Type: Select the data type relevant to your field. Fields containing words should be entered as Text, whereas fields containing numbers that might be a measurement or currency type should be entered as Number. Dates are simply dates.
Format: Your selection will determine how your field will be represented. For example, selecting #.### will display your Number field with three decimal places. A single # will display only the Number as a whole number. Texts or dates should simply be General.
Mapping Comm Lease and Unit Type Data
Unlike other fields, No. of Type and Comm X lessee fields need to correspond exactly to database fields. These fields are found at the bottom of the Upload Excel mapping screen.
Aside from the first iteration of each of these fields, the database fields will not appear in the Database Fields column of Upload Excel unless there is a corresponding header in your Excel file. For example, the Comm 1 Lease Date field will always appear in the Upload Excel Database Fields column, but Comm 2 Lease Date (and all other fields related to Comm 2) will only appear if there is a Comm # SF header in the Excel file.
For the No. of Type fields to appear past 1, there must be a No. of Unit Type # (such as No. of Unit Type 2) header in the Excel file.
4. Optional: Save This Map
After you've successfully mapped all of your fields, you can save the mapping to help expedite the process in the future.
Oftentimes, if you are repeatedly downloading information from a specific MLS vendor, it is likely that the column headers will be configured in the same way with each release. By saving the data map for a specific vendor's MLS file, you can refer to it again when working with that vendor's data.
Upon selecting Save This Map, the software will alert you of any fields you have not mapped, and if you haven't checked Duplicate Check. You may then specify a name for the map. It will be accessible from the Saved Data Maps drop-down.
When you're finished with the mapping process, you can finally upload your comp data to your database. The software will alert you of any unmapped fields.
You can view the progress bar from the bottom of the window.