CSV to KML / GeoJSON

About This Tool

The CSV to GeoJSON / KML converter transforms a tabular CSV file containing coordinate columns into a spatial format and previews the points on a map. It bridges the gap between spreadsheet-based data collection and GIS workflows — allowing field data, address lists, or IoT sensor logs to be imported directly into mapping tools.

Input

A .csv file with at least two columns containing latitude and longitude values. Column headers are detected automatically; common names (lat, latitude, lng, lon, longitude, x, y) are recognised without configuration. All remaining columns are preserved as feature properties. Rows with absent or non-numeric coordinate values are silently skipped.

Output

The detected points rendered as markers on the map, plus the converted file available as GeoJSON or KML download. GeoJSON output is a FeatureCollection of Point features; KML output is one <Placemark> per row.

Key Concepts

CSV (Comma-Separated Values)

A plain-text tabular format where each row is a record and columns are separated by commas (or occasionally semicolons or tabs). There is no formal spatial standard for CSV — coordinate column naming varies widely between data sources, GPS loggers, survey apps, and database exports.

GeoJSON Point feature

Each valid CSV row becomes a Feature object: {"type": "Feature", "geometry": {"type": "Point", "coordinates": [lng, lat]}, "properties": {...}}. Note that GeoJSON coordinate order is [longitude, latitude], which is the reverse of the conventional [lat, lng] display order.

Encoding

The tool reads files as UTF-8. CSVs exported from Microsoft Excel may use Windows-1252 encoding, causing mojibake with accented characters or non-Latin text. Save as "CSV UTF-8 (Comma delimited)" from Excel, or use Google Sheets which exports UTF-8 by default.