TransWikia.com

Table join to KML file

Geographic Information Systems Asked by Chad FHC on August 7, 2021

I want to add a classification to photos which are in an excel spreadsheet within a KML file.

Need a way to combine/join fields that are in an Excel spreadsheet to a KML file.

One Answer

It should be possible with the open-source program QGIS. I recommend installing the LTR (long-term release) version, QGIS 2.18, because the documentation is much better than for the newest version.

  1. Save the Excel file in CSV (comma-separated value) format.

  2. Load the KML into a QGIS project.

  3. (optional, but a good idea) Install the plugin QuickMapServices, and use it to add a basemap to your project. Compare the KML to the basemap and make sure it's in the correct location. If it's not, do not proceed until you resolve the issue. Otherwise your final export will be incorrectly geolocated.

  4. Load the CSV file as an attribute-only table in the same QGIS project.

  5. Join the table to the KML.

  6. Export the joined layer in KML format.

See also:

Answered by csk on August 7, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP