GeoCSV (CSV with lat/lon columns)
Open BetaGeoCSV is the simplest geo-format: a plain CSV file with separate latitude and longitude columns that opens anywhere — from Excel and Google Sheets to pandas, QGIS, and DuckDB. That universality is why it is chosen for exchanging POI lists between the Excel team, analysts, and GIS engineers. Our exporter writes OSM features as rows with lat and lon columns, adding name, type, layer, and non-empty attributes; for lines and polygons the centroid is used. The file is encoded in UTF-8 with BOM so Cyrillic opens correctly in Excel. A single layer yields a .csv file, multiple layers a ZIP. Honestly: it is a flat table of points — the full shape of lines and polygons is not preserved here; for those use GeoJSON or GeoPackage.
주요 기능
GeoCSV 형식 소개
GeoCSV is not a separate technology but a convention: an ordinary CSV table in which two columns are set aside for latitude and longitude. There is nothing to comply with, but such a file opens everywhere — from Excel and Google Sheets to pandas, R, QGIS and DuckDB.
The format is chosen for people rather than machines: a list of features has to go to a colleague who does not work in GIS, be published on an open data portal, or be loaded into someone else's system that only accepts "a file with coordinates".
The file has a row per feature: lat and lon columns, next to them the name, the type, the map layer and the non-empty OpenStreetMap tags. For lines and polygons the centroid is used — one point per feature. The encoding is UTF-8 with BOM, so that non-Latin text opens in Excel with a double click, without the import wizard. One layer means one .csv, several layers mean a ZIP.
The shape of streets and blocks is not preserved in such a table. If you need the whole geometry rather than points, take GeoJSON, GeoPackage or Shapefile.
GeoCSV 파일을 여는 프로그램
다음 프로그램과 애플리케이션으로 OSM2CDR에서 내보낸 GeoCSV (CSV with lat/lon columns)(.csv) 파일을 열고 편집하고 작업할 수 있습니다:
Format specifications
- Open standard
- 2D only
- Lossy compression
- Stores feature attributes
- Output: 1 file
- A flat CSV with separate lat/lon columns plus attributes, UTF-8 with BOM for Excel; lines and polygons collapse to their centroid, so full shapes are not preserved.
GeoCSV 지도 사용자
GeoCSV 내보내기 방법
내보낸 뒤 여는 방법
- Excel, Google Sheets, LibreOffice Calc — open with a double click; if the columns end up glued into one, use "Data → From Text/CSV" and set the delimiter to comma.
- QGIS (free) — drag the .csv onto the canvas or use "Add Delimited Text Layer": the program will suggest the lon and lat columns as WGS84 coordinates on its own.
- Python — pandas.read_csv("map.csv"), then geopandas.points_from_xy(df.lon, df.lat) turns the table into a geo layer.
- Google My Maps and similar services — CSV import with latitude and longitude columns works out of the box, and the points land on the map.
- DuckDB — read_csv_auto('map.csv') reads the file directly, and from there the spatial extension's functions work.
GeoCSV 형식의 인기 지도
GeoCSV (CSV with lat/lon columns) 지도 내보내기 받기
OpenStreetMap에서 전문가용 GeoCSV 지도를 다운로드하세요. 즉시 생성, 모든 영역 지원.