Notice that the sample place list has placeholder commas when the Latitude and Longitude are missing for 10 of the 11 rows. And this test data has the Place name in the flat form. After importing, you can use the [[Addon:PlaceUpdate_Gramplet#Generating_a_place_hierarchy|Generate hierarchy]] option of the {{man label|[[Addon:PlaceUpdate_Gramplet|Place Update]]}} add-on Gramplet to convert the flat form into a hierarchy. Then filter for Unknown types and use the Place Type option to set the State and County types to an extended selection of the enclosing Places.