Ask Your Question

Will Calc be able to import dat from .KML file containing a collection of points of interest from Google Mymaps?

asked 2018-12-18 01:06:00 +0200

islandboy gravatar image

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.

Importing KML (XML) from Google Maps into Calc

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-18 02:43:06 +0200

Ratslinger gravatar image


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 kml to xml

  • Opened Calc

  • From menu Data->XML Source... this started dialog

  • Under Source File clicked icon to select .xml file

  • Once selected Map to Document was filled with field names

  • Selected ..Placemark section ( subsequently selects all entries below)

  • In Mapped Cell: section used icon to select cell where data would start

  • Returned to dialog & selected Import button

Selected data was imported into sheet. Done on Linux Mint 18.3 with LO v6.1.3.2

edit flag offensive delete link more


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 ...(more)

islandboy gravatar imageislandboy ( 2018-12-20 14:45:28 +0200 )edit

@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.

Ratslinger gravatar imageRatslinger ( 2018-12-20 16:42:07 +0200 )edit

The 'ExtendedData' is the problem. Best to file bug report -> Bugzilla

Ratslinger gravatar imageRatslinger ( 2018-12-21 03:25:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-18 01:06:00 +0200

Seen: 242 times

Last updated: Dec 18 '18