1

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.

0

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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.