Google Mymaps allows the underlying data from a user created map to be exported via a KML/KMZ file. This appears to be a custom XML type file but a look at the file with a text editor suggests that it should not be difficult to do an automatic import. I could not get the solution at the following link to work.
Hello,
Not sure if this answers your question but in trying this I found no problem. Here are the steps used:
-
created map & entered some points of interest
-
created & downloaded KML file
-
changed extension from
kmltoxml -
Opened Calc
-
From menu
Data->XML Source...this started dialog -
Under
Source Fileclicked icon to select .xml file -
Once selected
Map to Documentwas filled with field names -
Selected
..Placemarksection ( subsequently selects all entries below) -
In
Mapped Cell:section used icon to select cell where data would start -
Returned to dialog & selected
Importbutton
Selected data was imported into sheet. Done on Linux Mint 18.3 with LO v6.1.3.2
I had three layers in my map. The first one was created by importing data from a table with four columns, the first headed name the second being latitude, the third being longitude and the fourth being address. The second layer was created using a table very similar to the first but the third layer was not created from a table but just by adding points to a new layer. If “open data table” is chosen from the menu for the third layer, the underlying table only has two columns,“name” and “description”. Exporting the data from the the third works as per the instructions in the answer but the data from the layers with tables that were imported with columns for latitude and longitude does not. To recreate the problem, create a table with three columns, name, latitude and longitude. Create a map by importing data from the table created and add a couple of points (adding the points is not strictly necessary). Try exporting the data to a KML file and importing to Calc as per instructions above.
@islandboy The information in your comment should have been part of the original question and not simply ‘…importing a collection of points’. Not certain I even comprehend your instructions. As the original question was answered, if inclined & have time, will try to understand what you are saying and once again look at the process.