What columns does the CSV need?

It needs a latitude and a longitude column. The tool recognises headers named lat, latitude or y, and lon, lng, long, longitude or x. A name and description column are optional and become the Placemark title and balloon text.

What coordinate order does KML use?

KML stores coordinates as longitude,latitude,altitude — the opposite order from most spreadsheets. This converter handles the swap for you, so you simply provide lat and lon columns and it writes them in the correct KML order.

What happens to rows with bad coordinates?

Rows whose latitude or longitude are not numbers, or fall outside the valid range (lat -90 to 90, lon -180 to 180), are skipped. The tool reports how many valid placemarks were generated so you can spot missing data.

Is my data uploaded to Google or any server?

No. Parsing and KML generation run entirely in your browser using JavaScript. Your spreadsheet never leaves your machine, which makes the tool safe for confidential location data.

Can I open the result in Google Earth?

Yes. Download the .kml file and double-click it, or drag it into Google Earth Pro or the web version. The placemarks appear under the document name you chose.

CSV to KML Converter

A CSV to KML converter turns a plain spreadsheet of coordinates into a Keyhole Markup Language file that Google Earth, Google Maps, and most GIS tools can read. If you have a list of stores, sensors, survey points, or any locations with latitude and longitude, this tool builds the KML for you in seconds — entirely in your browser, with no upload.

How it works

The tool parses your CSV with a proper quote-aware parser, so fields containing commas or line breaks inside double quotes are handled correctly. It then locates the coordinate columns by matching the header names: lat, latitude, or y for latitude and lon, lng, long, longitude, or x for longitude. Optional name and description columns become each placemark’s title and balloon text.

For every data row, it emits a Placemark element. The critical detail is coordinate order: KML writes points as longitude,latitude,altitude, which is the reverse of how spreadsheets usually list them. The converter performs that swap automatically and appends a zero altitude. Rows with non-numeric or out-of-range coordinates are skipped and the count of valid placemarks is reported.

Example

A row like Yerevan HQ,40.1792,44.4991,Head office produces:

<Placemark>
  <name>Yerevan HQ</name>
  <description>Head office</description>
  <Point><coordinates>44.4991,40.1792,0</coordinates></Point>
</Placemark>

Tips

Quote any name or description that contains a comma. All XML-special characters (&, <, >, quotes) are escaped automatically, so addresses with ampersands stay valid. Everything runs locally, so the tool works offline and keeps confidential location data on your machine.