CSV to Map
Open or paste a spreadsheet as CSV and see its rows as points on a map — from latitude/longitude columns or addresses — coloured by any column, and export to GeoJSON or KML.
CSV read per RFC 4180; commas, semicolons or tabs are detected from the first line. Coordinates can be decimal degrees or degrees-minutes-seconds and must be WGS84 (GPS). Addresses: OpenStreetMap via Photon. Map tiles: OpenStreetMap.
How to map a CSV file
- Open or paste the CSV. Save your spreadsheet as CSV; the first row must be column names.
- Check the columns. Latitude and longitude columns are detected automatically; or choose an address column.
- Find addresses if needed. Up to 200 addresses are looked up one at a time.
- Style the map. Pick a label column and a column to colour by.
- Export. GeoJSON for GIS or KML for Google Earth.
What people map from spreadsheets
Customer lists
See where customers are.
Store or branch locations
A quick map from a list.
Field data
Survey points with categories.
Event attendees
Where people are coming from.
Real estate
Listings by price band.
Research
Sites colour-coded by type.
How the CSV is read
The file is parsed in your browser according to RFC 4180; commas, semicolons and tabs are detected from the first line. Nothing is uploaded unless you choose to look up addresses.
Coordinates may be decimal degrees or degrees-minutes-seconds on WGS84 (GPS). Address lookups use the Photon geocoder (OpenStreetMap), one row at a time, up to 200 rows.
Colouring uses up to 12 distinct values of the chosen column.
Frequently asked questions
Which column names are recognised?
lat, latitude, y and lon, lng, long, longitude, x (and a few variants). You can also choose columns yourself.
My points are in the wrong place.
Check that latitude and longitude are not swapped and that western longitudes are negative.
Can I map an Excel file?
Save it as CSV first (File → Save As → CSV).
How many rows can it handle?
Thousands of rows with coordinates; address lookups are limited to 200.
Is my data uploaded?
No, except the address text when you ask for addresses to be found.
Related tools
KML Viewer
Open a KML file in your browser and see its placemarks, paths and polygons on a map with their names, lengths and areas, then convert it to GeoJSON, GPX or CSV.
OGC KML 2.2, read in your browser
GeoJSON Viewer
Open or drop a GeoJSON file and see every feature on a map with its properties, lengths and areas, then convert it to KML, GPX or CSV — without uploading it.
GeoJSON (RFC 7946), read in your browser
GPX Viewer
Open a GPX track from a watch, phone or bike computer and see it on a map with distance, climb, descent, time, average speed and an elevation chart.
GPX 1.1, read in your browser
Google Maps Embed Code Generator
Make the iframe code to put a Google Map on your website — a place, search, directions, view or Street View — with size, responsive layout and accessibility title set for you.
Google Maps Embed API parameters (Google documentation)
Draw on Map
Draw freehand, lines, shapes and markers on a real map, see each line's length and each shape's area, label them and download the drawing as GeoJSON, KML or GPX.
OpenStreetMap tiles; geodesic lengths and ellipsoidal areas
Map Legend Maker
Build a legend for any map — colours, area, point, pin and line symbols, labels, columns and a title — and download it as a PNG (transparent if you like) or SVG.
Made in your browser (SVG)