Exported As Excel Geometry Field

Permanently deleted user

March 19, 2019 17:13

Afternoon,

 

When clients export elements from a feature class into an Excel file, with the intention of adding addidtional fields to the Excel and reimporting it back in again, they are faced with problem of splitting apart the geometry field in the exported file. In order to achieve this, they need to utilize the Excel mid function and create two new columns with the x and y coordinates separated.

 

Why is the geometry field exported in the fashion? Why not have the export to excel automatically separate the x,y values into two separate columns?

 

Walter

 

0

• 

  Permanently deleted user

  March 19, 2020 21:16

  Hi Walter,

   

   

  I believe that the geometry field is considered a single column when exporting the data, so it ends up being formatted as a coordinate pair rather than new X and Y columns.

   

   

  This does make sense to do, though, so please post to our Ideas section for Essentials so we can consider this for part of the product!

   

   

  If you need it sooner then a custom workflow might be able to help split the points into X and Y coordinates.

   

   

  Regards,

   

  -Malcolm

  0

Please sign in to leave a comment.