CSV to GeoJSON

ALPHA

Create a GeoJSON file from a valid CSV file that contains columns for Latitude/Longitude, OS Grid References, LSOA, MSOA, Ward, Parliamentary Constituency, Local Authority District, or Combined Authority. More details about column headings below.

Drop CSV file here (or click to browse files)

Table
Map
GeoJSON

Notes

Geography

Detecting geography requires us to spot column headings in your CSV file. That means your CSV will need to contain one of these columns:

latitude/longitude (WGS84) - two columns titled Latitude/Longitude, lat/lon or geox/geoy.
OS Grid References - two columns titled Easting/Northing.
LSOA - a column titled LSOA21CD, LSOA11CD, LSOA01CD, or LSOA (interpreted as 2021 codes) and that column will need to contain valid ONS LSOA codes e.g. E01012334. Polygons derived from the ONS Lower layer Super Output Areas (December 2021) Boundaries Generalised Clipped EW (BGC) or Lower Layer Super Output Areas (December 2011) Boundaries EW BGC (OGL).
MSOA - a column titled MSOA21CD, MSOA11CD, or MSOA (interpreted as 2021 codes) and that column will need to contain valid ONS MSOA codes e.g. E02002273. Polygons derived from the Middle layer Super Output Areas (December 2021) Boundaries Generalised Clipped EW (BGC) or ONS Middle Layer Super Output Areas (December 2011) Boundaries EW BGC (OGL).
Ward - a column titled WD21CD, WD20CD, WD19CD or Ward (interpreted as 2021 wards) and that column will need to contain valid ONS 2021 Ward codes e.g. E05000026. Polygons derived from the ONS Wards (December 2021) Boundaries UK BGC, Wards (December 2020) Boundaries UK BGC V2 and Wards (December 2019) Boundaries EW BGC (OGL).
Constituency - a column titled PCON17CD or Constituency (interpreted as 2017 Westminster Constituencies) and that column will need to contain valid ONS 2017 Constituency codes e.g. E14000530. Polygons derived from the ONS Westminster Parliamentary Constituencies (December 2017) UK BGC (OGL).
Local Authority Districts - a column titled LAD23CD, LAD21CD, LAD20CD, LAD19CD or Local Authority (if no year is included it is interpreted as the most recent Local Authority Boundaries) and that column will need to contain valid ONS Local Authority codes e.g. E06000001. Polygons derived from the ONS Local Authority Districts (May 2021) Boundaries UK BGC, Local Authority Districts (2020) Boundaries UK BGC and Local Authority Districts (April 2019) Boundaries UK BGC (OGL).
Combined Authorities - a column titled CAUTH21CD or Combined Authority and that column will need to contain valid ONS Combined Authority codes e.g. E47000003. Polygons derived from the ONS Combined Authorities (December 2021) EN BGC (OGL - Contains OS data © Crown copyright and database right 2021).

WGS84 and OSGB86 will result in a GeoJSON file containing points. LSOA/MSOA/LAD/CAUTH-based data will add polygons derived from the ONS geographies. Other columns in the CSV file will be added as properties to each feature in the GeoJSON.

Privacy

If your file contains coordinates (WGC84 or OSGB86) no data is sent from this page. If your file is area-based - e.g. LSOA, Ward, Constituency, Local Authority - this page will have to make a series of requests to the server for the polygons for each area in your dataset. This means the server gets to know which areas are in your data. Please don't add area-based data if this is a problem. If your CSV file contains a huge number of areas your browser may struggle.

Credits

Created by Stuart Lowe, Open Innovations 2020. MIT Licence. Find the code on Github.