New Bulk Attribute Updates Using Spreadsheets Feature

By Paul Burkett

Updated 15 March, 2024

New Bulk Attribute Updates Using Spreadsheets Feature

What Is the Import Feature Updates Tool?

The Import Feature Updates tool is designed for users who need to update large amounts of data at once, such as utilities needing to adjust station numbers or structure heights across multiple features. This new feature works seamlessly with data that is set up as OpenPoint feature layers. Whether you're managing utility infrastructure or other geographic data, this tool helps you keep your information accurate and up-to-date with minimal effort.

How Does It Work?

The process starts with preparing a simple "data source" spreadsheet. The spreadsheet contains the GlobalId of each feature you want to update, along with the attributes you need to modify. Each attribute must exactly match the Field Name from your feature's data design. This ensures that the tool correctly identifies and updates the relevant fields.

For example, if you're updating the station number and height of a set of utility poles, your spreadsheet might include columns like GlobalId, StationNumber, and StructureHeight. The global ID is a unique identifier for each feature, and it’s crucial for accurately mapping the changes.

Attributes associated with domains should use the Code value from the domain, not the description. This ensures that domain-based attributes (like choosing between pre-defined categories or statuses) are updated smoothly.

An Example in Action

Imagine a utility company, Brightville Electric, needs to update attributes for several utility poles. Before the update, poles had outdated station numbers and structure heights that needed correction. Using the Import Feature Updates tool, Brightville Electric used spreadsheet data to bulk update the data.

The import process was straightforward: the spreadsheet was uploaded, and the data was automatically synchronized with the OpenPoint feature layer. The result? Updated records showing the new station numbers and structure heights, with the changes reflected in OpenPoint Map.

Notably, if the data involves a measurement value—like height in feet—the tool handles necessary formatting, such as adding units or symbols. In the Brightville example, the updated StructureHeight values displayed correctly with footage notation.

Why This Feature Matters

Updating large numbers of attribute values has always been a tedious, error-prone process. The Import Feature Updates tool removes that frustration, providing a more efficient way to ensure data accuracy across your maps. By leveraging spreadsheets, users can take advantage of a familiar format to make updates without needing to work directly in a GIS environment, saving time and reducing the risk of manual errors.

Ready to Get Started?

The Import Feature Updates tool is available now in OpenPoint Map. If you're ready to start streamlining your data updates, give it a try today. If you need further assistance, check out our support documentation or reach out to our customer support team—we’re always here to help!

© 2019-2025 OpenPoint, LLC.

Trademarks provided under license from Esri