GeoCSV 📊

GeoCSV (CSV with lat/lon columns)

Open Beta
.csv · text/csv

GeoCSV 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 exportálása most ✨ Nyílt béta — ingyenes, korlátozás nélkül

Fő jellemzők

Separate lat and lon columns — understandable without GIS tools
OSM attributes as plain columns: name, type, layer, and non-empty tags
Centroid is exported for lines and polygons
UTF-8 with BOM encoding for correct opening in Excel
Single layer — a .csv file, multiple layers — a ZIP archive

A(z) GeoCSV formátumról

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.

Milyen program nyitja meg a(z) GeoCSV fájlokat

A következő programok és alkalmazások képesek megnyitni, szerkeszteni és kezelni az OSM2CDR-ből exportált GeoCSV (CSV with lat/lon columns) (.csv) fájlokat:

📈Microsoft Excel 💻Google Sheets 🌎QGIS 💻pandas / GeoPandas 💻DuckDB

Format specifications

Ki használ GeoCSV térképeket

🏗
Exchanging a POI list with colleagues working in Excel or Google Sheets
A simple table a colleague will open with a double click and filter with the tools they already know.
💻
Importing points into pandas or R for statistical analysis
A ready input for statistics: points become dataframe rows with no geo wrapping.
📊
Quickly loading points into QGIS via drag-and-drop with no setup
QGIS recognizes the coordinate columns itself — the layer appears on the map with no setup.
🎨
Publishing tabular geodata on an open-data portal
A format that open data portals and municipal catalogs accept.

Hogyan exportáljon GeoCSV formátumba

1
Terület kijelölése
Rajzoljon egy téglalapot vagy sokszöget az interaktív térképen az osm2cdr.ru oldalon
2
GeoCSV kiválasztása
Válassza ki a(z) GeoCSV (CSV with lat/lon columns) formátumot a 127 elérhető exportformátum listájából
3
Exportálás
Kattintson az Exportálás gombra, és 1-5 percen belül megkapja a(z) .csv fájlt
4
Letöltés
Töltse le a kész GeoCSV fájlt, és nyissa meg a(z) Microsoft Excel programban

Hogyan nyissa meg az exportálás után

Népszerű térképek GeoCSV formátumban

Ingyenes

Szerezzen be GeoCSV (CSV with lat/lon columns) térképexportokat

Töltsön le professzionális GeoCSV térképeket az OpenStreetMap adataiból. Azonnali generálás, bármilyen terület.

Ingyenes / export
GeoCSV exportálása most →

Gyakran feltett kérdések

Is the full shape of lines and polygons preserved?
Why does the file open with garbled text in Excel?
Which coordinate system are the lat/lon columns in?
Can I open the result directly in QGIS?
Which columns will be in the file?
How is this different from a CSV export with a WKT column?

Kapcsolódó formátumok

Gyakran együtt exportálva

Related Articles