Turns a spreadsheet with coordinates into a GeoJSON FeatureCollection. Every other column becomes a property, so the data travels with the points.
How the coordinate columns are found
lat, latitude or y; longitude from lon, lng, long, longitude or x. Elevation from ele, elevation, alt, altitude, height or z.
Whichever columns are used is stated in the conversion notes, so you can see the guess rather than trust it. If it picks wrong, name the columns explicitly in the options.
Degrees-minutes-seconds are refused, on purpose
59°54'50"N is rejected rather than parsed. This is a deliberate choice worth explaining.
The obvious implementation reads the leading number and discards the rest, turning 59°54'50" into 59 — an error of about six kilometres, applied to every row, with no warning. That is far worse than a refusal, because it produces a map that looks plausible and is wrong.
Convert the column to decimal degrees first: degrees + minutes/60 + seconds/3600, negated for south and west. Then this tool will take it.
Comma decimal separators
59,9139 rather than 59.9139, and arrive semicolon-delimited so there is no ambiguity. Those are accepted and converted. A comma decimal in a comma-delimited file is genuinely unresolvable and will not parse.What you get
Other names for this
Also searched as “csv to map”, “spreadsheet to geojson”, “excel to geojson”.
Questions
- It cannot find my coordinate columns.
- The error lists the columns it did find. Rename yours to latitude and longitude, or name them explicitly in the options.
- My coordinates are in degrees-minutes-seconds.
- Convert them to decimal degrees first. Parsing the leading number would introduce a several-kilometre error in every row without telling you.
- Can I create lines or shapes from a CSV?
- Not yet — every row becomes a point. Building a line needs a convention for which rows group together and in what order.
- Some rows are missing from the output.
- Their coordinates did not parse as numbers. The count is reported rather than placing them at (0, 0).
- Is my file uploaded?
- No. Everything runs in this tab. That matters more here than almost anywhere else on the site — a calendar is your movements, an address book is other people’s personal data, and a GPS track is where you live and where you run. None of it is sent anywhere.