📄

CSV (Comma-Separated Values)

Open Beta

.csv · text/csv

CSV yenye jiometri ya WKT ni umbizo la maandishi la kawaida kwa ubadilishanaji wa data za kijiografia. Hufunguka katika programu yoyote ya lahajedwali, huingizwa kwa urahisi katika hifadhidata, na hutumika katika hati za uchakataji wa data.

OpenStreetMap data as of 24 August 2026 · 46 days ago

Safirisha CSV sasa ✨ Open Beta — bila malipo, bila vikomo

Vipengele Muhimu

✓Umbizo la maandishi

✓Jiometri ya WKT

✓Hufunguka katika Excel

✓Uingizaji rahisi katika hifadhidata

Kuhusu Muundo wa 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.

Programu Gani Hufungua Faili za CSV

Programu na programu-tumizi zifuatazo zinaweza kufungua, kuhariri, na kufanya kazi na faili za CSV (Comma-Separated Values) (.csv) zilizosafirishwa kutoka 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.

Nani Hutumia Ramani za CSV

🏗

Ubadilishanaji wa data

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

💻

Uingizaji katika hifadhidata

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.

🎨

Hati za uchakataji

Processing with Python or R scripts without installing geo libraries.

🗺

Mfululizo wa ETL

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

Jinsi ya Kusafirisha CSV

Chagua eneo

Chora mstatili au poligoni kwenye ramani shirikishi katika osm2cdr.ru

Chagua CSV

Chagua CSV (Comma-Separated Values) kutoka orodha ya miundo 127 ya usafirishaji inayopatikana

Safirisha

Bofya Safirisha na upokee faili yako ya .csv ndani ya dakika 1-5

Pakua

Pakua faili tayari ya CSV na uifungue katika Excel

Jinsi ya Kufungua Baada ya Kuhamisha

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.

Ramani maarufu katika CSV

Bila malipo

Pata usafirishaji wa ramani za CSV (Comma-Separated Values)

Pakua ramani za kitaalamu za CSV kutoka OpenStreetMap. Uzalishaji wa papo hapo, eneo lolote.

Bila malipo / usafirishaji

Safirisha CSV sasa →

Maswali Yanayoulizwa Mara kwa Mara

Je, naweza kufungua ramani ya CSV katika Excel? ▼

Jinsi ya kuingiza CSV katika 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? ▼

Linganisha na Miundo Mingine

⚖ CSV vs GEOJSON ⚖ EXCEL vs CSV ⚖ GEOJSON vs CSV

Convert to CSV and back

⇆ CSV → AI ⇆ CSV → CDR ⇆ CSV → DWG ⇆ CSV → DXF ⇆ CSV → EPS ⇆ CSV → PDF ⇆ CSV → SVG ⇆ CSV → GeoJSON

CSV guides and tutorials

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

What people who already downloaded say

Reviews are quoted in the language their authors wrote them in.

Наконец-то карты можно скачать в векторе. Автору спасибо!

Ильяс, сентябрь 2026

всё очень круто, не ожидал что просто приду и скачаю кусочек карты! спасибо!!!

Сергей, сентябрь 2026

ОГРОМНОЕ СПАСИБО!!! ОЧЕНЬ ХОРОШАЯ ПРОГРАММА!!! Искал карту в векторе на стыке 3 стран - очень помогло!!

Андрей, сентябрь 2026

Ты - молодец! Сделал большое и нужное дело!

Артем, сентябрь 2026

Иван, спасибо огромное! Не просто человек - Человечище!

Константин, сентябрь 2026

иван, вы просто чудо. Спасибо за неимоверно крутой сервис

Студент-архитектор, сентябрь 2026

Miundo Inayohusiana

Husafirishwa Pamoja Mara kwa Mara

CSV+💻GeoJSON 🌎Shapefile 🗺GPX

format