Skip to content

Import and export ​

Import a file ​

Choose Import data, or drop a file on the map. The Portal reads GeoJSON, coordinate CSV, Excel XLSX, KML/KMZ, zipped Shapefiles, GeoPackage and ASCII DXF, up to 20 MB. A failed import adds nothing.

  • Excel: choose the worksheet, review its columns and pick X and Y when they are not clearly longitude and latitude. Identifiers keep their leading zeros, and formulas use their saved values; they never run.
  • Coordinate systems: see below.

It also reads the table in a text PDF, and rows you paste under Or paste a table: see Tables without coordinate columns.

After an import, Geova Audit says what the new layer has to look at.

Tables without coordinate columns ​

Import also takes a table it cannot place by itself: a CSV or worksheet whose columns are not named as longitude and latitude, a table in a text PDF, or rows pasted under Or paste a table (from a spreadsheet, a message, or text your device copied from a photo), then Read pasted text. Import says first what it will do, for example Import will find where these points are, and Import goes on under the same title. All of it is worked out in your browser.

  1. Choose where the points belong. Up to three small maps show where the same rows would land, each read in a different coordinate system or order. Each card names the place and says why it comes first: beside your map's layers, in your region (from your device's time zone, which stays in your browser), or among mapped roads. Choose Use this placement on the one that lands where you expect; a placement is only a reading of the cells and moves nothing. If none fits, move the map to the area and choose Show possible placements again, or open Set the reading by hand to choose the columns, their order, the coordinate system and the number format yourself.
  2. Check the rows. The review shows the points on the map, under a You chose line with Change to go back to the cards. Rows to check first, then the rest lists the rows that need a look: cells that do not read as coordinates, positions far from the rest, and positions In water on the map. Far and wet positions stay out of the layer until you include them, one by one or with Include all.
    • Typing slips. When undoing one slip (a decimal point left out or doubled, a space or comma inside a number, the two values swapped, or two digits swapped) puts a row among the others, the review proposes it: Use the fix, or Use all the proposed fixes. The cell keeps what was written.
    • Streets from addresses. When the table has an address column and a district column, Look for the streets named in the held rows' addresses places each on the street its address names, read from the basemap's own street names. The point is the street, not the building. Matching runs in your browser, and no address is sent anywhere.
  3. Add reviewed layer adds the rows you kept as a new layer. A PDF read only in part asks first, with Add only the reviewed records from this PDF.

The next time you import a table laid out the same way, Reuse the reading of an earlier layer applies that reading and checks the new rows again.

  • Grid references: for a column of MGRS or USNG references such as 38S MB 44 88, choose MGRS / USNG (WGS 84) as the Coordinate format under Set the reading by hand. Each point goes to the centre of its grid cell, and the review gives the cell's size, which is not survey accuracy.
  • Both values in one cell: choose Both axes in one column and which value comes first; the order is never guessed.
  • PDFs: text PDFs up to 100 pages, with a table whose headings name the coordinates on every page. Scans and photos are not read: copy their text with your device's own text reader, and paste it.
  • Roads and water are read from the Light, Dark, Streets and Detailed basemaps only. That basemap's provider sees the areas of the placements offered, as it sees your map.

Export ​

  • One layer: from its ⋯, choose Export layer: GeoJSON, CSV, KML/KMZ, Shapefile ZIP, GeoPackage or DXF. GIS and CAD formats can be written in another coordinate system.
  • The whole map: Export all layers (GeoPackage) in the map menu writes one GeoPackage with each layer as its own table, as the Mapplex app exports a project. Untick a layer under Layers in the file to leave it out.
  • A selection: Export selection on the selection bar.
  • Area and length: for a layer with areas or lines, Include area and length writes them as ordinary columns named with their unit (area_m2, perim_m, length_m), calculated as the file is written. It starts ticked where the layer's table shows those columns, and unticked for the whole map.

Exporting a linked Mapplex layer writes the records loaded for the current view, and asks you to confirm that first. Read the notes an export returns: CAD curves may be segmented, and styles stay in the Portal.

Live Google Sheets ​

A Google Sheet can be a live layer: points that follow the sheet as people add or change rows, for example the responses of a Google Form.

  1. Publish the tab. In Google Sheets choose File → Share → Publish to web, pick the tab and Comma-separated values (.csv), then Publish and copy the link. Anyone with that link can read the whole tab, so publish one without personal columns.
  2. Add it. In the map menu choose Add Google Sheet, paste the link and choose Read sheet. An editing link is refused, with the steps to publish.
  3. Coordinates. One column holding both (latitude, longitude, as Google Maps and phones copy them), or two columns. Arabic digits and decimal commas are read. Rows that cannot be read are listed by row number, never guessed.
  4. Columns. Choose the columns to show. Columns that look personal (email or phone) start unticked.

The layer reads the sheet again every 5 minutes (or 1, 15 or 60 in Sheet settings) while the Portal tab is visible; Refresh now reads at once. Sheet layers are read-only: edit rows in the sheet, or Make an editable copy for an ordinary layer. The Portal saves only the link and your choices, never the rows. Sheet layers are not offered in public links; share an editable copy instead. Limits: 8 MB and 100,000 rows, coordinates in WGS 84.

Coordinate systems ​

The Portal reads and writes coordinates in any of the 5,872 EPSG coordinate systems of the worldwide catalogue it shares with Mapplex, each with its area of use and its shift to WGS 84.

  • Choose a system under Coordinate settings: keep the file's own, pick WGS 84 or Web Mercator, search all systems by EPSG code or name, or type an EPSG code or WKT. When a file needs a system, the search suggests the ones that place its numbers inside their area of use, nearest your map view.
  • Datum shifts are never guessed. A file on another datum is converted with its system's published shift. A datum the catalogue cannot identify, or one that needs grid files, is refused until you choose the system: an assumed zero shift, which can put data hundreds of metres off, never happens.
  • Approximate systems (about 850 with no published shift) can be imported only after you confirm that positions may be off by up to a few hundred metres, and are never used for export.
  • Export to Shapefile, GeoPackage and DXF in any catalogue system with a published shift whose area of use contains the data; the search suggests the systems made for where the data is.

Spatial intelligence. Clear next steps.