SpatialXL – Map Pivots

Link your Pivot Tables to your Map layers. Map layers will automatically update as your pivot changes.

You can pivot and link your spreadsheet data to any map layer you have open in SpatialXL

 

 Pivots

 

 

 

 

LocateXL – High speed bulk geocoder for Microsoft Excel

LocateXL is an open extensible Geocoder that works within Microsoft Excel or as a standalone application if you need to process more than a million records at a time.

LocateXL

LocateXL uses a revolutionary full text and structured approach to process all kinds of datasets. Datasets may be totally unstructured or have some or all address fields specified. LocateXL is able to work with fields holding possible two address fields in one column extending the precision of the geocoding and the range of datasets it can successfully process.

With LocateXL you are even able to build your own geocoding reference data for your country and region, from SQL databases, Shape Files or other sources.

We supply datasets for South Africa right out of the box.

Using the familiar Microsoft Excel environment you are able to filter out bad records, geocode subsets and change settings to match filtered subsets to easily geocode almost any dataset. During the geocoding process the correct canonical address is given back.

Reverse geocoding is also possible one on one or in batch at very high speed.

Borehole Desurvey

BoreHole Desurvey

In SpatialXL or any of our other Spatial products (SurveyXL, GeologXL, EvaluationXL) you can de-survey borehole data on the fly.

All one does is specify the borehole collars, the surveys and then the lithography data and assay data. These data sets can come right from an Excel workbook, a SQL Server or Oracle database or any data source supported by our spatial engine.

The data is rendered on the fly, so if the data source is updated, the boreholes are automatically updated when the layer is opened the next time.

Use Excel Macros to control the Map in SpatialXL

Excel Macros

SpatialXL allows you to develop custom spatial analytic applications in Microsoft Excel using VBA and custom worksheet formulae.
You can programmatically select features in the map, and detect what features are selected by the user in the map to create visual what if scenarios and dynamic calculations involving Spatial data.

Downloads