I formerly used Google Fusion Tables but due to the product downturn I had to bulk-download a backup copy of my data. Right now I have them all saved in CSV format.
I have attribute columns in these tables but also a column simply named as "geometry" all bunched up together, in a single column.
It's in the format of
<Polygon><outerBoundaryIs><LinearRing><coordinates>[coord],[coord],[coord] [coord],[coord],[coord] [coord],[coord],[coord]</coordinates></LinearRing></outerBoundaryIs></Polygon> where
[coord] is something like
-129.83 for instance.
I'm trying to import this data into QGIS 3 and I've tried it both as a vector layer as well as delimited text file format. However, nothing actually shows up on the map.
What can I do to resolve this situation?