KML data from Google Map to Pivot Table in Excel

I have a kml file with data that I need to import as fielded data into excel so I can create pivots against it.

Simple for anyone with experience.