A list of addresses with coordinates in a spreadsheet becomes far more useful as a map layer in Google Earth or Google My Maps. This tool reads a CSV with latitude and longitude columns and writes a KML document with one Placemark per row, using optional name and description columns for the labels and pop-ups.
Paste the CSV, confirm which columns hold the coordinates, name the file and download the KML. The file is built in your browser, so customer locations are never uploaded.
How to use CSV to KML step by step
Paste the comma-separated CSV with a header line into the text area.
Set the names of the latitude and longitude columns (lat and lon by default) and, optionally, the name and description columns.
Type the output file name (map by default).
Click "Convert and download KML". Open the file in Google Earth or import it into Google My Maps.
100% free and online: no payments, no software or extensions to install.
Privacy-first: processing happens in your browser, your data never leaves your device.
No sign-up: paste your data and get the result in one click.
Fast and reliable: handle small or large files in seconds, ready for Excel and other tools.
Common use cases
Plot a list of shops, clients or delivery stops on Google Earth for a sales territory review.
Create a Google My Maps layer of points of interest from a spreadsheet for an event or a trip.
Visualise field survey results (sensors, samples, sightings) recorded with GPS coordinates.
Share a map of properties or plots with someone who only has Google Earth.
Limits and tips
Coordinates must be decimal degrees (40.4168, -3.7038). Degrees-minutes-seconds or comma decimals (40,4168) are not converted and produce invalid points.
Rows without a value in the latitude or longitude column are skipped; the first row must have both, otherwise the conversion is rejected.
The CSV is split on commas without quote handling, so descriptions containing commas will shift the columns.
Name and description text is inserted as-is: characters such as & or < must be escaped as & and < or the KML will not open.
Frequently asked questions
In what order do latitude and longitude go in KML?
KML writes coordinates as longitude,latitude,altitude, the opposite of the usual spoken order. The tool takes care of this: you tell it which CSV column is latitude and which is longitude and it writes them in the correct KML order with altitude 0.
How do I open the KML file?
Double-click it with Google Earth Pro installed, or in Google My Maps create a map, click Import and choose the KML. QGIS, ArcGIS and most GIS tools also open KML directly.
Can I add colours, icons or lines?
No. Each row becomes a simple point with the default icon. To style the points or draw routes, import the KML into Google Earth or My Maps and edit the styles there, or generate a KML with Style elements by another means.
What is the difference between KML and CSV for maps?
CSV is a plain table that Google My Maps can import too, but only KML carries names, descriptions and geometry in a format that Google Earth, GPS devices and GIS software understand directly. KML is the safer choice when the map must be shared.
Is the CSV uploaded?
No. The KML text is assembled in your browser and downloaded locally; nothing reaches a server.