How to use it
- Paste the CSV or drop the file. The first line must hold the column names.
- Choose the column for labels and, if you like, a column to colour by.
- Click a point on the map for the full row. Click a row in the table to fly to it.
- Export as GeoJSON or KML, or PNG for a picture.
5 practical uses
- See customers, stores or sites from a spreadsheet on a map.
- Check a set of coordinates for errors by looking at them.
- Map survey points, sensor locations or samples.
- Colour points by type, status or region.
- Turn a spreadsheet into GeoJSON or KML for another tool.
The maths behind it
The CSV is parsed with a small state machine that handles quotes, commas, semicolons and tabs. The latitude and longitude columns are found by name, each row becomes a GeoJSON point, and the map engine projects the points to Web Mercator. Colours by category assign one of ten colours to each distinct value in order of first appearance.
Notes
Commas, semicolons and tabs all work as separators, so a paste from a spreadsheet is fine. Rows without valid coordinates are skipped and counted. Colouring by a column with many different values gives many colours; it works best for a handful of categories. Nothing is uploaded: the file is read in the browser.
To make the coordinates first, see address to coordinates (batch mode).