Skip to main content

Annotation Spreadsheet View

Updated over a week ago

What's New? | April 2026 Enhancements

Discover the latest April 2026 enhancements to the Annotation Spreadsheet. Feel free to browse the new features by clicking the link below.

  1. Column Hide/Show – Show or hide columns to focus on relevant data

  2. Resizable Column Width – Drag column edges to adjust width

  3. Delete Annotations – Remove annotations directly from the spreadsheet

  4. Multiple Select Annotations – Select multiple annotations to download or delete

  5. Resizable & Full Screen Mode – Resize the panel or go full screen

  6. Annotation Icon Management – Add or remove icons from the spreadsheet

  7. Dropdown Fields with Icons – Icon-enhanced dropdown menus

  8. GeoJSON Export – Export annotations as GeoJSON for GIS tools

  9. GeoJSON Import – Import annotations from GeoJSON files

What is Spreadsheet View

Spreadsheet View displays annotations in a table where each row represents an annotation and each column represents an annotation field/property. Users can quickly scan data, apply filters, make bulk edits, and move annotation data in and out of the platform using CSV files.

Edit Annotation Properties

Users can edit supported annotation properties directly within the spreadsheet interface. Changes made in Spreadsheet View update the corresponding annotations in the project.

This makes it easy to:

  • Correct data

  • Update labels or attributes

  • Perform quick edits across multiple annotations

Follow the steps below to edit annotation properties.

  1. Click the ellipsis button (...) next to the annotation group to access additional layer settings.

  2. Click Spreadsheet View.

  3. Make sure the correct annotation template is selected.

  4. Single Select: Users can click on any field they want to edit.

    Note: 3D Shape field cannot be edited.

  5. Multiple Select: Users can select multiple cells by pressing Cmd + Click (Mac) and Ctrl + Click (Windows)

  6. For dropdown fields, select the appropriate value.

    For all other fields, a text box will be available for editing.

  7. Click Apply to make the changes.

  8. Users will be notified on the number of changes pending. They can also see the pending changes highlighted in light orange.

  9. Click Save changes to finalize and apply all changes.

Column Hide/Show [NEW]

Users can show or hide individual columns to focus on the data that matters most. This is useful when working with templates that have many fields, or when only a subset of properties needs to be reviewed.

How to hide or show columns:

  1. Click the ellipsis button (...) next to the column field to hide it.

  2. Click Hide Column to temporarily remove the column from the spreadsheet view.

  3. Filtered columns are displayed below the search box.

  4. Click Clear All to reset all active filters, including hidden columns, or click X next to a column name to restore it.

Resizable Column Width Support [NEW]

Users can adjust the width of any column by dragging to better accommodate long text values, notes, or other content.

Note: Each column has a minimum width to ensure content remains legible. Column widths reset when the spreadsheet is closed and reopened.

Delete Annotations [NEW]

Users can delete individual annotations directly from the spreadsheet view.

Note: Deleting an annotation is permanent and cannot be undone. The annotation will be removed from the project entirely.

Multiple Select Annotations [NEW]

Users can select multiple annotations at once to perform bulk actions. Selected annotations can be downloaded as a GeoJSON or CSV file or deleted in a single operation, making it faster to manage large datasets without editing annotations one by one.

Actions available for selected annotations:

Once one or more annotations are selected, two action buttons will appear in the toolbar:

  • Delete (n): Permanently removes all selected annotations from the project.

  • Export (n): Downloads a GeoJSON or CSV file containing only the selected annotations and their visible columns.

How to exit multi-select:

Click the Select button again to deselect all annotations and return to normal editing

mode.

Note: Filters still apply while selecting. Only annotations visible in the current filtered view can be selected.

Resizable and Full Screen Mode [NEW]

The spreadsheet panel can be resized vertically or expanded to full screen especially when working with large datasets.

Add/Remove Annotation Icon via Spreadsheet [NEW]

Users can assign or change an annotation's icon directly from the spreadsheet, making it easy to visually categorize or tag annotations.

Dropdown Fields with Icons [NEW]

Dropdown fields in the spreadsheet now display icons alongside their values for faster visual scanning and selection. This applies to fields such as Severity, Status, and Priority.

Note: The icons displayed correspond to the values defined in the selected annotation template. Custom templates may have different icons and values.

Right-Click Context Menu [NEW]

Users can right-click on any annotation row to access a context menu with quick actions. This provides a convenient shortcut to export the annotation row or delete it.

Note: The right-click context menu works on individual annotation rows. To perform bulk actions on multiple annotations, use Multiple Select Annotations instead.

Filter Annotations

Annotations can be filtered based on defined criteria, allowing users to narrow down the dataset and focus on relevant items only.

Filtering helps users:

  • Find specific annotations quickly

  • Review subsets of data

  • Prepare targeted exports

Below are the steps on how to filter annotations.

  1. Click the filter icon for the annotation field the user wants to filter.

  2. Users can select the value/s they want to filter.

  3. Click Apply Filter button to filter the annotation results by the selected field.

  4. Users can add multiple filters as well.

  5. Click Clear All Filters to restore the original data.

Export Annotations to CSV or GeoJSON [NEW]

Users can export annotations as a CSV or a GeoJSON file. The exported file can be opened and edited using common spreadsheet, word processing, or code editing applications.

This supports offline editing, bulk updates, and external review workflows.

Follow the steps below on how to export annotations.

  1. Click Export to save the data in a CSV or GeoJSON format.

  2. View and edit the data in any third-party software.

Note: Images and attachments associated with exported annotations are not included in the CSV or GeoJSON file. Image and attachment fields will appear as null in the exported data. To access these files, use the SKAND platform directly.

Import Annotations from CSV

Users can import annotations from a CSV file to update existing annotations or create new ones. This enables bulk creation and modification without manual entry.

Imported annotations are validated before being added to the project to ensure data consistency and correctness.

  • CSV Import Guidelines for Annotations

    When importing annotations using a CSV file, the following rules must be followed.

    1. Mandatory Fields

      The following fields must not be empty:

      1. Color

      2. Points

      3. Shape Type

      If any of these fields are missing or empty, the import will fail.

    2. Points/Polygons Validation

      Points and polygons must correspond to the specified shape type.

      Point-based shapes must be labeled as POINTS, while polygon-based shapes must be labeled as POLYGONS.

      If the points or polygons do not align with the shape type, the annotation will not be imported.

    3. Point and URL Fields
      Fields that store arrays, such as Points and URLs, must be enclosed in double quotes and formatted as an array.

      "[]"

      Failure to follow this format will cause import errors.

    4. Date Format

      All date fields must use the following format:

      MM/DD/YYYY

      Dates that do not follow this format will be rejected during import.

    5. Dropdown Fields
      Values in dropdown fields must match the values defined in the selected annotation template.

Here's how users can import annotations from a CSV file:

  1. Users must ensure that all edits in the CSV file are validated (see CSV validation) before importing.

  2. Click Import to initiate the process. Select CSV.

  3. Select the CSV file and click Open.

  4. Any changes or additions to the current data will be highlighted in light orange.

  5. Click Save Changes to finalize.

Note: Refer to this example CSV file for a proper reference when importing annotations.

Import Annotations from GeoJSON [NEW]

Users can import annotations from a GeoJSON file to create new annotations or update existing ones. This is useful for bringing in geospatial data from external GIS tools, field survey applications, or other platforms that export in GeoJSON format.

Imported GeoJSON features are validated before being added to the project to ensure data consistency and correctness.

  • GeoJSON Import Guidelines for Annotations

    When importing annotations using a GeoJSON file, the following rules must be followed.

    1. Valid GeoJSON Structure – The file must be a valid GeoJSON FeatureCollection containing one or more Feature objects. Each Feature must include a geometry object and a properties object.

    2. Supported Geometry Types – The following geometry types are supported:

      POINTS and POLYGONS. Unsupported geometry types will be skipped during import.

    3. Coordinate System – Coordinates must be in WGS 84 (EPSG:4326) format as specified by the GeoJSON standard: [longitude, latitude] or [longitude, latitude, altitude].

    4. Property Mapping – Properties in the GeoJSON properties object are mapped to annotation fields based on matching field names. Property names are matched case-insensitively. Any properties that do not match a field in the selected annotation template will be ignored.

    5. Mandatory Fields – The following fields must be present either in the GeoJSON geometry or properties:

      • Color – Must be provided in the properties object. If missing, a default color will be assigned.

      • Points – Derived automatically from the GeoJSON geometry. Users do not need to include this manually.

      • Shape Type – Derived automatically from the GeoJSON geometry type. Users do not need to include this manually.

    6. Dropdown Fields values for dropdown fields (such as Severity, Status, Priority) must match the values defined in the selected annotation template. Unmatched values will cause the annotation to fail validation.

    7. Date Format If date fields are included in the GeoJSON properties, they must use the following format:

      MM/DD/YYYY

      Dates that do not follow this format will be rejected during import.

Here's how users can import annotations from a GeoJSON file:

  1. Users must ensure that all edits in the GeoJSON file are validated (see GeoJSON validation) before importing.

  2. Click Import to initiate the process. Select GeoJSON.

  3. Any changes or additions to the current data will be highlighted in light orange.

  4. Click Save Changes to finalize.

Importing New Annotations while Preserving Existing Ones

When importing new annotations:

  • All fields available in the CSV must be included.

  • Annotation ID must be excluded.

These rules ensure that new annotations are generated correctly during import.

Here's how users can import new annotations:

  1. When working with a large number of annotations, users can add annotations in SKAND by importing them.

    Read this section that also covers the data validation requirements that must be met before importing.

  2. Users can manually add rows to the CSV file, as long as all fields are populated except for the annotation ID.

  3. Once data from the CSV has been validated, click Import.

  4. Select the CSV file and click Open.

  5. The additions to the current data will be highlighted in light orange.

  6. Click Save changes to finalize.

Note: Refer to this example CSV file for a proper reference when importing new annotations.

Related Articles
How to Share and Export Annotations
Getting Started with Annotations
Create Annotations
Project-Level Annotation Templates
Executable Annotations
Did this answer your question?