Converting a KML to a Layer, how to convert popupinfo data to fields?

Question

Often I am given a KMZ with features that have a lot of information that shows up in the pop-up, but when it is converted to an Esri feature layer, all of that info resides in a single "popupinfo" field as a block of HTML.  Is there a function or process that can easily take that block of text and, using the HTML tags, convert it into fields and data?

PopupInfo.PNG

waxg_2-1626458934353.png

DavidBranca · Answer

I posted a simple solution on another thread linked below. a small python script that can be loaded into a tool and run on a layer converted from a KML file (using AGP's kml to layer tool). the scritp scrapes the html table and converts it to feature attributes.

https://community.esri.com/t5/data-management-questions/extracting-attributes-from-kml-descriptions/m-p/1341955/highlight/true#M44753

Zachary-Smith · Answer

You could try the KML-to-Layer-Post-Process tool on GitHub. It is meant to use the popup HTML information and convert it to fields. I've had a hard time making it work, but maybe it could for others.

https://github.com/cam-mcevenue/KML-to-Layer-Post-Process

MarcusVowell_Uniti · Answer

Thanks, Bruce!  I was afraid it would be a complicated process.  I guess I was hoping there was a magic Esri tool that parsed the HTML into an attribute table automatically, but this will at least give me a starting point from which to work.  Thanks again!  Much appreciated!