Convert Excel (XLSX) to GeoJSON
Free, private and fast: everything runs in your browser and your Excel (XLSX) file is never uploaded.
Excel (XLSX) to GeoJSON: why convert
Lists of shops, sample sites, customers or assets are often kept in Excel with one column for the latitude and one for the longitude. To put them on a web map, in Leaflet, Mapbox or geojson.io, they need to be GeoJSON. This converter reads your .xlsx workbook, finds the sheet with coordinates and the columns that hold them, and turns every row into a point with all the other columns as properties. Cell types from Excel carry over: numbers stay numbers, text stays text (a postcode such as 0150 keeps its zero) and dates are written as 2024-05-01. If the columns are named differently, pick them yourself; projected X/Y values such as UTM work too when you enter their EPSG code. You see the points on a map before you download.
How to convert Excel (XLSX) to GeoJSON
- Drop your .xlsx file in the box, or click to choose it.
- Check the coordinate columns the converter picked, and change them if needed.
- Look at the points on the map, then click Convert to GeoJSON and download the file.
What changes when you convert
Which sheet is read
A workbook can have many sheets. The converter reads the first sheet whose header row has coordinate columns, such as Latitude and Longitude, Lat and Lon or X and Y, and tells you which sheets it skipped. If none is recognised, it uses the first sheet with data and lets you pick the columns.
The first row must be the header
Every sheet is read with its first row as column names. Titles, notes or empty rows above the header turn into column names and make the data hard to read, so delete them in Excel first. Formulas are read as their last calculated values, and a merged cell has its value only in its first cell.
Coordinates as numbers
Latitude and longitude must be decimal numbers such as 55.6761. Degrees, minutes and seconds like 55°40'34"N are text and cannot be read; convert them in Excel first. Rows with an empty or invalid coordinate are kept with "geometry": null, and the converter says how many there are.
Old .xls files
Excel 97-2003 files ending in .xls use an older format that is not supported here. Open the file and save it as .xlsx (Excel Workbook) or as CSV.
About the formats
Excel (XLSX)
XLSX is the workbook format of Microsoft Excel since Excel 2007, also written by LibreOffice, Numbers and Google Sheets. Address lists, sample sites and asset registers often live in a spreadsheet with a latitude and a longitude column, but a spreadsheet is not map data until those columns become points.
- A workbook can hold several sheets; each sheet is one table with a header row.
- Cells keep their type: numbers, dates and text, so a postcode like 0150 can keep its leading zero.
- There is no geometry and no coordinate system; coordinates are just numbers in columns.
- The older .xls format (Excel 97-2003) is a different, binary format.
GeoJSON
GeoJSON is a plain-text JSON format for geographic features, standardized as RFC 7946 in 2016. It is the native format of web maps such as Leaflet, MapLibre and Mapbox, and of many APIs.
- Coordinates are WGS84 longitude, latitude (in that order).
- Points, lines and polygons can be mixed in one file.
- Properties can be any JSON value, with no limit on field name length.
Frequently asked questions
Is my spreadsheet uploaded?
No. The workbook is read by your browser with GDAL compiled to WebAssembly, on your own device.
Which column names are recognised?
Names starting with lat, lon, lng or long, and X, Y, easting and northing, in any letter case. A column of WKT text such as POINT (12.57 55.68) is recognised as well.
My coordinates are UTM or a national grid. Does that work?
Yes. Enter the EPSG code of the coordinate system, for example EPSG:25832, and the points are converted to longitude and latitude, as GeoJSON requires.
Does it work with Google Sheets or LibreOffice?
Yes. Download or save the sheet as .xlsx (Microsoft Excel) and drop that file here.