Feature Spreadsheet

The Feature Spreadsheet allows you to view properties for all of the processed features contained in your project, and make changes to attribute values as necessary.

To view a Feature Spreadsheet:

Select Feature Spreadsheet in Home > Data.
Right-click a feature, and select New Feature Spreadsheet in the context menu.

Note: The feature codes in your project must be processed before you can view feature data in the Feature Spreadsheet.

To specify what feature data is displayed in the spreadsheet:

Two drop-down lists located at the top of the spreadsheet enable you to select the feature data you want to display in the spreadsheet:

Features to display - Select one or more features to display in the spreadsheet. Each instance of a selected feature is represented by a row in the spreadsheet.
Attributes to display - Optionally, select one or more feature attributes to display in the spreadsheet. All attributes assigned to the selected feature type(s) are displayed in the list. Each unique attribute selected is represented by a column in the spreadsheet.
Note: Some attribute names apply to a single attribute that can be assigned to multiple features (for example, Photo). In this case, the attribute is represented by a single column in the spreadsheet. Other attribute names may apply to multiple attributes, each with different properties. For example, the project might include two attributes named Size: one that supports numbers and another that supports integers. In this case, each of the two Size attributes would be represented by a unique Size column in the spreadsheet.

To view data in the spreadsheet:

All applicable features and attributes are displayed in the spreadsheet. The first column includes either a point ID (for point features) or a feature name (for line and polygon features). You can click Expand button (+) located to the left of a line or polygon feature row to display a list of the points that define feature.

To display properties for any feature or point included in the list, right-click it and select Properties.

To sort and filter items in the spreadsheet:

Click any column heading to sort the items in the list based on the alphanumeric listing of items in the column (ascending or descending).
To filter items displayed in the spreadsheet, click the Filter icon icon at the top of any column and select an option from the drop-down menu.
To change the order of columns in the spreadsheet, click and drag the column heading in the spreadsheet itself to a new location.

To specify whether grid, global, and/or local coordinates are displayed in the spreadsheet, select Project Settings in the Quick Access Toolbar. Then click View > Feature Spreadsheet. For each type of data, select to Show or Hide the column in the spreadsheet.

To edit attribute values directly in the spreadsheet:

Editable attributes are displayed in blue. To change an attribute value, either type in a new value or select it from a drop-down list, depending on the attribute type.

To copy data and paste spreadsheet data into a different application

Use click-and-drag, Shift + click, and/or Ctrl + click to select the data you want to copy. Then right-click and select Copyin the context menu, or press Ctrl + C. You can now paste the copied data into a spreadsheet or word processing application.