Exporting to Excel
An export to an Excel spreadsheet can be done “directly” or with the “form data”:
Export directly
With the “Export directly”, all controls/attributes present in the feature class can be exported.
 |
In the table, the columns are named in addition to the attribute name with the designation of the respective control. |
 |
Row 1: Control designation Row 2: Control/attribute Row 3/4: Example |
 |
All controls can be activated. |
 |
All controls can be deactivated. |
Export form data
With “Export form data”, all controls/attributes displayed in the form can be exported.
The exported data can then be edited and shared or re-imported.
Importing from Excel
The import on an Excel spreadsheet can be done as an import “directly” or as an “update”:
Excel import
With an Excel import, new data can be imported into a project. The names of the columns must correspond to the controls of the feature class into which the data is to be imported. This is easiest to understand if data was previously exported from this feature class.
If records already exist in the feature class, the query appears as to whether the existing records should be deleted. When importing additional records, this question must be answered in the negative. If there were no records before and the same records are imported again and again for testing purposes, these may of course be deleted before a new import.
After the import, the following message will appear:
If no coordinates are included in the data, a geometry must subsequently be assigned to the objects.
If these are feature classes that have both a line/point form and a detailed form, the import must be carried out in the respective line/point form. A query is then made as to which attribute feature is involved.
Excel update
The Excel update is used for faster processing of many records and their re-import into the project. The FIDs of the records must remain unchanged so that the attributes can be assigned to the correct record. After editing the data in Excel, the records can be updated during import.
The following query will appear:
The update could still be canceled here with “No”.
If the update is confirmed with “Yes”, then the update is completed with this message:
