This article will walk you through how to convert .CSV to .KML using QGIS

Prerequisites

  • QGIS on your computer. Don't have it? Follow these instructions to install it.
  • A .CSV file with label, latitude, longitude, and heights.
    Note that for jobs on a local grid, you need to have ellipsoid heights. If your site is local grid, please follow these instructions to convert your heights.
  • A site with working with global projections (has EPSG codes).

Instructions

  1. Prepare your .CSV file with the format: Label, Latitude, Longitude, and Height. 

2.  Launch your QGIS. In the Menu tab, navigate to Layer > Add Layer > Add Delimited Text Layer. 

3. This will prompt the Create Later dialogue box. Import your .CSV file and make sure to correctly define the File Format and Geometry Definition for Lat and Long. Click OK. 

4. The Coodinate Reference System Selector will enable you to select the correct reference system for your data. Since our Viewer operates on WGS84 and your csv values are in lat and long, select EPSG 4326. Click OK.  

5. This is how it would look like in the Viewer panel of the QGIS.

6. To export it in .KML, right click the layer, select Save As. This will prompt the save vector dialogue box. Select .KML as the file format and set the CRS to WGS84.

Make sure to set the altitude as "clampToGround" so that it will work properly in the Viewer. 

7. Upload it into the platform by clicking on the Upload button on the left side of the Viewer. Toggle on the KML layer and the Clamp to Ground tool.


 I still can't do it!

We wrote these articles to arm you with everything you need to get the job done on your own, but we understand that sometimes this isn't sufficient.

If you're stuck, the Propeller data specialists team can help for an hourly consulting rate. Email us at support@propelleraero.com or talk with us right now from the chat bubble and we'll do our best to help.

Did this answer your question?