I am running into a roadblock where I need to somehow export the data from a points KMZ/KML file into a tabular format where all fields in the dataset are accessible. So far, I have only had minor luck in using the KML to Layer tool to get a feature class with all the geometry appropriately visible, but the attribute table shows that all the original attribute data is shoved into one field called "PopupInfo" and formatted as XML.
I have seen other threads where they mention that Data Interoperability may be the best solution to fully export all KMZ/KML fields into a tabular format with all original fields present, but I was wondering if anyone in the community has ever gone through this workflow.
I do not have access to the original file that the KMZ was created from (at least, not yet) so for now, I am stuck.
My end goal is to be able to get all the data into a table where I can then append additional data and create a new dataset from it.
Any help is greatly appreciated.