Export Excel data to ArcGIS without connection
Export Excel data to ArcGIS (without implementing a connection).
Click on the button
"Export data" in the Excel toolbar.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom.png)
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_2.png)
Within a new worksheet the button
"Create connection" is deactivated. It will be activated after saving the worksheet.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_3.png)
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_4.png)
Choose the upper left column heading of your data table in your spreadsheet. In this example, the table origin resp. the column headings start at A1.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_5.png)
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_2.png)
The GISconnector assumes that all columns and rows adjacent to the table origin (here: A1) belong to this table. The recognition of further columns can be prevented by an empty column or a column without heading respectively. The recognition of further rows can be avoided by an empty row.
1. Here you see a summary of your Excel data source, the name of the worksheet and the table origin.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_6.png)
Press "Next >".
2. Select the name and the storage location of the table you are about to create.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_7.png)
Press "Next >".
3. Select the scope of the export.
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_8.png)
Press "Finish >".
![](Daten/drex_export_excel_data_to_arcgis_without_connection_custom_2.png)
If you have activated the Expert mode you can additionally define which columns should be exported to Excel.