SpatialXL is an add-in to Microsoft Excel 2007, 2010 & 2013 which gives Excel mapping and graphics capability with the ability to link between the Excel workbook sheets and the graphics whether drawings or maps.

You can manipulate and analyse the data from Excel.  SpatialXL is used in different ways by users in different industries as the following shows:

Industries

• Mining
• GIS
• Business
• Engineering
• Logistics

 

An add-in to Microsoft Excel which adds full spatial functionality and intelligence to Excel, enables a direct link between client tables and maps, and enables users to quickly & easily create and share their own maps.  This tool is a full GIS tool which operates inside Excel.

Turn Spreadsheets into maps

Any spreadsheet with Spatial data can immediately be turned into a map in Excel.  
Spatial data can be Points e.g. Coordinates, Lines or Areas such as Suburbs, Towns, Municipalities etc.

Map updates ‘on the fly’, as data is changed or updated in the worksheet.

E.g. 30 000 stores with coordinates, mapped to show distribution:

 

 

 

 

 

 

 

 

 

Load data in various formats

Load existing map layers, such as Shapefiles or Map services, such as Google & Bing Maps, 

Connect directly to external databases e.g. SQL Server or Oracle.  

Build database queries directly in SpatialXL.

Supported Data formats:

 

 

 

 

 

 

 

 

 

 

 

 

E.g. Google Maps/Satellite

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Filter your maps

Filtering fields in your spreadsheet  instantly updates your map.  Filters can be carried out across multiple fields, numeric or text. 

E.g. Filter all supermarkets in the Western Cape 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

E.g. Filter all Municipalities in Eastern Cape

 

 

 

 

 

 

 

 

 

 

 

 

Theme (colour code) your maps

Use the Theming tools to quickly and easily colour code your data using any field in your spreadsheet.

E.g. Municipalities colour coded by District Name

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

E.g.  Stores colour coded by sales volume

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Search your maps

Use the Locate Tools to quickly find, highlight and zoom the map to any spreadsheet row(s), e.g. Schools, Towns, Suburbs etc.

 

 

 

 

 

 

 

 

 

 

 

Label and identify map features

Use the Labeling and Inspector tools to identify features on the map, and link back to your spreadsheet

 

 

 

 

 

 

 

 

 

 

 

 

 

Measure data

Use the Measure Tool to measure distances on your map. 
Use the Volume, Length and Area calculations for map layers, and move or copy results to your spreadsheet

 

 

 

 

 

 

 

 

 

 

 

Query your maps - Map selection tools

Choose from multiple Map Selection Tools to select and identify features on your map, and view your selection in your spreadsheet. 

 E.g. Select all schools within an area & immediately highlight these in your spreadsheet

 

 

 

 

 

 

 

 

 

 

 

Query your maps - Spatial analysis tools

Choose from multiple Spatial Analysis Tools to query and select features on your map, and view your selection in your spreadsheet. 
 
E.g. Single/Multiple Buffer Selections

 

 

 

 

 

 

 

 

 

 

 

Overlay census data

Map and theme Census and Demographic data, and link directly to internal datasets or map layers.

E.g. Dominant Race Group                             E.g. Dominant Language

Create your own data

Use the Map Drawing tools to draw (digitize) and create your own customized map data layers and boundaries. Export and save your data to a number of supported data formats.

GIS analysis tools

Choose from many GIS analysis tools and layer operations, such as heat mapping, voronoi diagrams, contouring, select by location, classification, clustering etc. 

Example of GIS Analysis Tools

E.g. Heat (Grid) Mapping

E.g.  Contouring