Convert CSV to KML Online — Free & Instant
Converting a CSV file with latitude and longitude columns to KML lets you visualise your spreadsheet data in Google Earth, Google Maps, or any KML-compatible application. Maparz detects coordinate columns automatically and converts each CSV row to a KML placemark, with all other columns appearing as placemark attributes.
File converter
When to convert CSV to KML
- Plotting Excel or Google Sheets location data in Google Earth
- Importing business location CSVs into Google My Maps for sharing
- Visualising survey point data on Google Earth for client presentations
- Converting geocoded address data from a spreadsheet to KML
How to convert CSV to KML
- 1
Prepare your CSV
Ensure your CSV has columns named lat/latitude/y and lon/lng/longitude/x.
- 2
Upload the CSV
Drop your .csv file on the upload zone.
- 3
Select KML
Click KML in the format panel.
- 4
Open in Google Earth
Double-click the downloaded .kml to open in Google Earth.
About CSV
CSV (Comma-Separated Values) files containing geometry data typically include latitude and longitude columns (or X/Y columns for projected data). Many data providers distribute point datasets as CSV because they are easy to open in Excel, Python, and R. When converting from a vector format to CSV, Maparz outputs an X (longitude) and Y (latitude) column along with all attribute data. To convert CSV to GeoJSON, your file must have columns identifiable as longitude (x, lon, lng, longitude) and latitude (y, lat, latitude).
Strengths
- +Opens in Excel, Google Sheets, any spreadsheet
- +Human-readable and editable
- +Lightweight for point data
About KML
Keyhole Markup Language (KML) is an XML-based format developed for Google Earth and now maintained by the OGC. It is widely used in Google Maps, Google Earth, and many consumer-facing mapping applications. KML supports styled geometry, network links, folders, and time-based animations. It always uses geographic coordinates (WGS 84) and is stored as plain XML text. KMZ is simply a ZIP-compressed KML file, which can also include embedded images and other resources.
Strengths
- +Native in Google Earth and Google Maps
- +Supports rich styling and labels
- +Human-readable XML
Frequently asked questions
Q.Will my CSV column data appear in Google Earth?
Yes. All CSV columns (except the coordinate columns) become placemark description attributes visible when you click a placemark in Google Earth.
Q.Can I import the KML into Google My Maps?
Yes. In Google My Maps, click Import and upload the KML file. Each CSV row becomes a map marker.