What is revolutionary about GISconnector for Excel?


The GISconnector for Excel consists of a program, an Add-In (toolbar) for ArcGIS Desktop and an Add-In (tab) for Microsoft Excel. The two Add-Ins in ArcGIS and in Excel communicate with each other by means of the program and thereby combine ArcGIS and Excel into one ingenious overall system. The power of Excel becomes available in ArcGIS and vice versa.
Check out our video channel with demos and tutorials at Vimeo.
 
These are the essential functions of the GISconnector for Excel:
 
Bidirectional link between feature classes and Excel tables with data synchronization:
  • Create a connection to Excel data either by exporting your ArcGIS data to Excel or establish a connection between an ArcGIS dataset and existing Excel data
  • Synchonize data modifications between Excel tables and ArcGIS attribute tables without an editing session or locks on your Excel file
  • Save the data connection with settings: tell the GISconnector exactly which columns are to be transferred from ArcGIS to Excel or from Excel to ArcGIS, and which are not.
  • If you create new columns in Excel, you can transfer these changes to ArcGIS; this also works the other way round, of course.
  • When you transfer data from ArcGIS to Excel, the GISconnector for Excel does not overwrite your Excel formulas, thereby ensuring that your spreadsheet always remains fully dynamic.
     
Transfer of selections and definition queries to Excel:
  • Select features in an ArcGIS layer and transfer the selection to the linked Excel table as a selection.
  • Select features in an ArcGIS layer and transfer the selection to the linked Excel table as a filter.
  • Transfer definition queries of an ArcGIS layer to the linked Excel table as a filter.
 
Transfer of selections and filters to ArcGIS:
  • Select data in the Excel table and transfer the selection to ArcGIS as a selection.
  • Select data in the Excel table and transfer the selection to ArcGIS as a definition query.
  • Transfer filters of the Excel table to ArcGIS as a definition query.
  • Transfer filters of the Excel table to ArcGIS as a selection.
     
Exporting and importing data from and to ArcGIS:
  • Export attribute tables from ArcGIS directly to Excel (XLSX format)
  • Export Excel data directly to ArcGIS tables (dBase- or Geodatabase-tables)