Uploading a CSV

Uploading a CSV

Summary:

Admins have the ability to upload a CSV file into XMAP/PostGIS, as long as the csv file contains columns with coordinates or geom, in either a projection of 27700 or 4326.

Prerequisites:

Column names should not contain special characters, start with numbers and ideally follow the first three best practice for table/column names

The CSV file must contain named coordinate columns, and supports the following pairs: 
  1. lon, lng, long, longitude, x, easting, east
  2. lat, latitude, y, northing, north
Alternatively, if your CSV contains a column with wkt values, then any of these column names ares acceptable. 
  1. wkt, geom, geometry, the_geom, wkb_geometry

How to:

Go to Admin >> Data >> Upload File
  1. Change FORMAT to CSV
  2. Choose the destination database and schema
  3. Set a projection for the data (optional but recommended) either 27700 or 4326
  4. drag and drop or choose a CSV to upload. 
  5. Click on the UPLOAD button
  6. In the processing area, wait from the file to be ready. 
  7. Once ready, click on the Start Ready Files button. 
 
  1. Once the CSV is successful Done you can add the table into a Collection. 
    • Related Articles

    • Uploading GIS Files

      Overview File upload allows you to input ESRI Shapefile Mapinfo Tab files GeoPackages Geojson / JSON CSV into your XMAP database. Only an administrator can complete this action. How to upload files To upload your files: Open XMAP in your browser and ...
    • XMAP Updates

      XMAP version 2.20.1 (February 2026) Map - CSV uploader Map - Multi Query Filtering Map - Cookie cutter Map - Slide/extend/enlarge the side panel Admin - SAML Single Sign-On XMAP version 2.20.1 (January 2026) Map - Highlight Features Map - Create ...
    • Table View

      Overview Table or Table View allows users to quickly view all the attribute values of a feature in a spreadsheet style. This allows users to quickly look over all values within the layer, or run filters/query to retrieve a subset of the data and ...
    • QGIS Connector

      Overview This add-on for XMAP Cloud GIS allows layers to be viewed in QGIS. The layer can be edited and saved directly to your XMAP Cloud GIS account without downloading and re-uploading the data. Setup QGIS There are no plugins needed for viewing an ...
    • How do I share data to Parish Online?

      South Kesteven District Council, located in the East Midlands, comprises a diverse mix of urban and rural communities, including numerous parishes. Effective collaboration with these parishes is essential for local governance, planning, and public ...