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
