Quick Start: Exporting to Excel

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Taking your comps from Report Writer and exporting them straight into the Excel template is a quick and easy process. You can take a single record and use it as a subject for a new file, or a collection of comps to use in an analysis grid.

1. Select Properties > Search

Begin by clicking on the Search tab from the navigation bar, and click on a property descriptor that matches what you are looking for.

2. Perform a Search

The Search page will offer a number of different filters for refining your results. Simply fill out your desired search parameters and perform a search.

3. Select Your Records for Export

The Search Results table will become populated and comprised of all records that matched your filters. Find the records that you wish to export to Excel. In the left-most column of the comp(s) you wish to export, click on the empty checkbox. Below the Search Results table, you'll find the Your Selection field filled with all of the IDs of your comp selections. Click Copy, and then open up your N1Appraisal.xlsm file.

Importing a New Subject

1. Select a Record for Export

From the Search Results page, note the record you wish to use as a subject, and find its corresponding ID from within the ID column.

2. Enter the ID > Click Import Subject

Within your N1Appraisal.xlsm Excel file, open the File Info worksheet . To the left of the page, you'll find a button that says Import Subject Data from DB. Below that will be a text field where you can enter the ID of the record you wish to import. Type in the appropriate ID, and click Import Subject Data From DB.

Importing Comps to a Grid

To import multiple records from Web to use within a grid worksheet:

1. Click Arrange Comps

Navigate to the appropriate grid worksheet (Land, Lease, Sales). In the top, left-hand corner, find and click on the Arrange Compsbutton.

2. Enter Record IDs > Click Add to Worksheet

This will produce a new window, where toward the bottom will be an empty text field titled Import Comps From N1-Web. The IDs that you paste within this text field are the same that appear within the Your Selection field on The Search Page. If you clicked Copy while in the Search Page, click Paste from Clipboard to paste in your IDs. Finally, click Add to Worksheet to have the information imported into your Excel file.

Was this article helpful?

What's Next

Quick Start: Viewing Comps

Table of contents

Importing a New Subject
Importing Comps to a Grid