This software is an Excel add-in for spatial data analysis
GIS interface includes Map and Legend Panel. Into the map you can import spatial data from ESRI ShapeFiles. Using functions in the legend context menu you can edit visual properties of individual layers from the Map Panel.
Excel to GIS
Features from the Excel to GIS group allows you to add your Excel spreadsheet data to the Map Panel in the form of layers (shapefiles).
Function Create Layer allows you to create map layer from data in Excel table. Your data can create map layer in the form of points, lines and various types of polygons (convex hull, Delaunay polygons, rectangles, hexagons). In addition, selected data can be stored in the attribute table of ShapeFile layer.
Create Layer from WKT
Another option to create map layers (from the Excel spreadsheet) is through the geometry defined in the WKT format (points, lines or polygons geometrically defined in one cell). The WKT format is often used. You can find it, for example, when storing spatial data in databases (e.g. SQL Server).
Update Attribute Table
This function allows you to update the attribute table of selected ShapeFile using data from Excel table. Map layer and Excel table can be linked via coordinates or through values in selected columns (spreadsheet <-> attribute table).
GIS to Excel
The second group of add-in functions allows you to export data from map layer (shapefile) into an Excel table. In this case, you can export data from ShapeFile as new table or you can update existing table in Excel using data in the map layer.
Export ShapeFile Data
This function allows you to export data from map layer and create new table in Excel spreadsheet. You can export data from the ShapeFile attribute table and also the spatial characteristics of individual map objects, such as coordinates of the points, the length of lines, area polygons or geometry definition in WKT and GeoJSON format.
Update Excel Table
The second function allows you to add to your Excel table an information from selected map layer. In the following video two examples are shown. In the first example, we insert ID's of polygons (geology) from map layer according to the point coordinates in Excel table. In the second example, we calculate summary area of all map polygons that have the same identifier (in the attribute table) as in the Excel table.
The last group is Specific Functions. These can significantly increase your efficiency.
You can use this feature to calculate spatial and attribute statistics for one layer of polygons using data in another layer (points, lines, polygons). An example for this feature may be mentioned automated area calculations of lakes in individual districts. These calculations can be grouped. You can divide these lakes, for example, into groups of natural and artificial lakes. In the following video, we calculate the sum of springs yields (from point layer) for individual districts (polygons in the second layer).
If you need to crop the selected map layer according to polygon in another layer, this feature will help you. Simple but effective function for spatial data analysis.
Using this function, you can create buffer polygons around features in a selected map layer. These buffers can be created for points, lines and polygons.
Set Color Palette
The new version of GIS.XL add-in contains many new color scales that you can use to visualize your spatial data.
Change Visual Properties
Change selected visual property for all categories in one map layer at once.
Import from GPX
Work with / visualize your spatial data from GPX files directly in Excel (trackpoints & waypoints).
Export to Google Earth
The next function allows you to export your spatial data to a KML file (Google Earth). In this way, you can export (in vector form) individual layers or the whole map visualization (also with data from attribute tables.
Export to GeoJSON
The second option to export your spatial data is to create a GeoJSON file and publish it online using external tools (e.g. Leaflet.js). Add-in GIS.XL includes a simple tool for direct export of your spatial data into GeoJSON files.
Publish / Share Map
If you want to share your map results online or offline (outside of the add-in environment), you can take advantage of their publication in a form of HTML documents (vector format). Simple and fast option for automatic publishing of HTML map documents from your spatial data.
Add-in GIS.XL was developed with the condition that it does not require additional software, libraries or web services. The Installation package is less than 14 MB and it contains everything you need for installation and correct run. When you begin the installation process the program downloads all necessary libraries (.NET Framework 4.5) via the Internet (microsoft.com website) and installs them automatically. This is a great help if your computer is not updated regularly with libraries and the latest available tools. Your computer only needs the following:
- OS: Windows 7 or higher
- MS Office: desktop version of MS Excel 2010 or higher
Your computer may be 32 or 64-bit, and the same for your Office; and this program is operational in all combinations.