Question: how to extract data from kmz file to excel?
Answer:  create a folder with all the pin points in google earth.
Save the folder in kml format (not kmz).
Go to Ms Excel and click open (all files option).
Open the kml file in excel as an XML table.
The "name" Latitude and longitude columns are the names of the pins and the respective coordinates.