📄

CSV (Comma-Separated Values)

Price before payment

.csv · text/csv

CSV me gjeometri WKT është një format teksti universal për shkëmbimin e gjeodhënave. Hapet në çdo aplikacion fletëllogaritëse, importohet lehtësisht në baza të dhënash dhe përdoret në skripte përpunimi të dhënash.

OpenStreetMap data as of 26 October 2026 · 8 days ago

Eksporto CSV tani ✨ Open Beta — falas, pa kufizime

Veçoritë kryesore

✓Format teksti

✓Gjeometri WKT

✓Hapet në Excel

✓Importim i lehtë në bazë të dhënash

All map examples by format

Rreth formatit CSV

CSV is a simple table: a row per object, columns separated by commas. Geography is put into it in two ways, and we use both at once: the full geometry of an object is written as text in WKT format, and next to it come the latitude and longitude of a representative point — for a line and a polygon that is a point on the object itself, not a nominal center outside it.

The format is chosen when the map is needed as data rather than as a picture: to count objects in a table, to merge with an export from your own system, to load into a database, to hand to a colleague without a GIS, to run through a script. CSV is read by literally everything — from Excel to pandas.

The output is a single file in UTF-8 encoding. One layer gives an ordinary table; if several layers are selected, they are gathered into one file, and the first column _layer shows where the row came from — it makes splitting the data back apart easy. OSM attributes go as separate columns, and the coordinates are in WGS84 rounded to seven decimal places, which is about a centimeter.

Çfarë programi hap skedarët CSV

Programet dhe aplikacionet e mëposhtme mund të hapin, redaktojnë dhe punojnë me skedarë CSV (Comma-Separated Values) (.csv) të eksportuar nga OSM2CDR:

📈Excel 💻Google Sheets 💻Python (pandas) 📐R 💻PostGIS 🌎QGIS

Format specifications

Open standard
2D only
Lossless (no quality loss)
Stores feature attributes
Output: 1 file
RFC 4180 CSV with WKT geometry column or lat/lon pairs. UTF-8 encoded. Opens in Excel, LibreOffice, pandas, QGIS.

Kush përdor harta CSV

🏗

Shkëmbim të dhënash

Passing geodata to where there is no GIS: anyone can open a table.

💻

Importim në bazë të dhënash

Loading into PostgreSQL, MySQL or a warehouse with a single import command.

📊

Excel/Google Sheets

Work in a familiar spreadsheet: filters, pivots, counting objects by type.

🎨

Skripte përpunimi

Processing with Python or R scripts without installing geo libraries.

🗺

Tubacione ETL

An intermediate layer in an ETL pipeline between the export and the target system.

Si të eksportoni CSV

Zgjidhni zonën

Vizatoni një drejtkëndësh ose poligon në hartën interaktive te osm2cdr.ru

Zgjidhni CSV

Zgjidhni CSV (Comma-Separated Values) nga lista e 127 formateve të disponueshme të eksportit

Eksporto

Klikoni Eksporto dhe merrni skedarin tuaj .csv brenda 1-5 minutave

Shkarko

Shkarkoni skedarin e gatshëm CSV dhe hapeni në Excel

Si ta hapni pas eksportit

Excel — do not open the file with a double click, otherwise non-Latin text turns into gibberish: Data → Get Data → From Text/CSV, encoding UTF-8, comma as the separator.
QGIS — Layer → Add Layer → Add Delimited Text Layer; choose the WKT column as the geometry, coordinate system EPSG:4326.
Python — pandas.read_csv for the table, and for the geometry shapely.wkt.loads on the WKT column, or geopandas straight away if you need spatial analysis.
PostGIS — load the table with the COPY command and turn the text into geometry through ST_GeomFromText with SRID 4326.
Google Sheets and My Maps — accept the latitude and longitude columns directly, if a point representation of the objects is enough.

Harta popullore në CSV

Falas

Merrni eksporte hartash CSV (Comma-Separated Values)

Shkarkoni harta profesionale CSV nga OpenStreetMap. Gjenerim i menjëhershëm, çdo zonë.

Falas / eksport

Eksporto CSV tani →

Pyetjet më të shpeshta

A mund ta hap hartën CSV në Excel? ▼

Si ta importoj CSV në PostGIS? ▼

How do I open the file in Excel without garbled characters? ▼

What are the _layer, lat and lon columns? ▼

What coordinate system do the coordinates come in? ▼

Krahaso me formate të tjera

⚖ GEOJSON vs CSV ⚖ EXCEL vs CSV

Convert to CSV and back

⇆ CSV → AI ⇆ CSV → CDR ⇆ CSV → DWG ⇆ CSV → DXF ⇆ CSV → EPS ⇆ CSV → PDF ⇆ CSV → SVG ⇆ CSV → GeoJSON ⇆ CSV → GeoPackage ⇆ CSV → GeoTIFF ⇆ CSV → KML ⇆ CSV → Shapefile

CSV guides and tutorials

📖 Working with Shapefiles in QGIS 📖 Geo Analytics for Real Estate 📖 OpenStreetMap for Academic Research

Formate të ngjashme

Eksportohen shpesh së bashku

CSV+💻GeoJSON 🌎Shapefile 🗺GPX

format