Skip to main content
Back to top

Export Excel/CSV spreadsheet

Updated

Related to

Export asset list data from a project to an Excel/CSV spreadsheet. This makes it easier to create mailers/letters of intent (LOIs) and upload the data into CRM or other land-tracking systems.

Overview

Export project asset tables as an excel/CSV file, including:

  • Parcel/landowner mailing lists
  • Parcel metadata/buildable area analysis calculations
  • List of POIs (substations, lines)

Export asset lists as Excel/CSV

  1. On a project, click Export (top-right corner of the project page)
  2. Select Export Excel/CSV from the menu
  3. Then, select the desired list to export (e.g. Parcels)
Prospect_Projects_Export-data_Excel-CSV_01.png

This will expand the list export tool automatically.

  1. Select desired columns for export
  • Either check the Select All Columns box

OR

  • Select columns individually by clicking the Select Columns menu
Prospect_Projects_Export-data_Excel-CSV_02.png

 

Create an Excel/CSV export template

Save time and create a consistent export process by saving a template for future use. Saved templates will appear at the top of the export sidebar window and will be available to all users within your organization. 

Here's how to save a template:

  1. Select the desired columns to include in template — either check the Select All box or add individual columns via the Select Columns option. 
  2. Expand the View Columns section
Prospect_Projects_Export-data_Excel-CSV_Create-template_01.png
  1. Change the column export name (if desired) by clicking the export name link and inputting the new column name you'd like to use instead.
  2. Change the sort order of columns as desired by clicking the arrows to the right of the column names.
  3. Add a name for the new template in the Template Name field at the bottom
  4. Click Save Template 
Prospect_Projects_Export-data_Excel-CSV_Create-template_02.png

The newly saved template will appear at the top of the Export sidebar window for future use by any users on the company 

Prospect_Projects_Export-data_Excel-CSV_Create-template_03.png

Click the name of the template to apply the export template. 

 

See how to address the issue of missing leading zeros (e.g., for APNs) in Format leading zeros in Excel

 

 

 

×