Skip To Content

Export layer data

In this topic

From the map Contents pane, you can export data from a map layer to a separate file or to a new worksheet in the current workbook. The exported data includes all information about the features on the layer, including location attributes for point layers.

When you export data from a point layer on the map, ArcGIS Maps for Office generates latitude and longitude coordinates relative to the current basemap's coordinate system by default. You can specify the spatial reference system to use, and optionally define that coordinate system as the default for all future export functions. The default setting applies to both exporting to a new file and exporting to a new worksheet in the current workbook.

Export to a file

To export layer data to a file, do the following:

  1. From the map Contents pane, select the layer that you want to export.
  2. Click More Layer options to display the layer options menu and choose Export layer to file.

    The Export layer to file pane opens.

    Note:

    If ArcGIS Maps for Office is configured to use a specific spatial reference by default, this pane will not appear. To change the default spatial reference, uncheck the Use specified spatial reference when exporting point data option in the backstage configuration.

  3. Choose the spatial reference to use for the exported data.

    Click the radio button to choose one of the options. If you choose Other, choose a spatial reference from the drop-down menu.

  4. To set the selected spatial reference as the default for future export functions, check the Use this selection by default check box.
  5. Click OK.

    A Save window opens.

  6. In the File Name field, type a name for the new file.
  7. From the Save as type drop-down menu, choose Excel Workbook or CSV (Comma Delimited) and click Save.

    ArcGIS Maps for Office creates a new file that includes all the information about each feature on the selected layer. If the selected layer contains point features, the file will include the coordinates for each feature. Polyline and polygon geometries are not exported.

    When you export to an XLSX file, ArcGIS Maps for Office formats the information as an Excel table in a new workbook.

    Note:

    If you export to CSV, you must convert the file to XLSX before you can use it with ArcGIS Maps for Office.

Export to a worksheet

To export layer data to a new worksheet, do the following:

  1. From the map Contents pane, select the layer that you want to export.
  2. Click More Layer options to display the layer options menu and choose Export layer to worksheet.

    The Export layer to worksheet pane opens.

    Note:

    If ArcGIS Maps for Office is configured to use a specific spatial reference by default, this pane will not appear. To change the default spatial reference, uncheck the Use specified spatial reference when exporting point data option in the backstage configuration.

  3. Choose the spatial reference to use for the exported data.

    Click the radio button to choose one of the options. If you choose Other, choose a spatial reference from the drop-down menu.

  4. To set the selected spatial reference as the default for future export functions, check the Use this selection by default check box.
  5. Click OK.

    ArcGIS Maps for Office creates a new worksheet in the current workbook that includes all the information about each feature on the selected layer. If the selected layer contains point features, the file will include the coordinates for each feature, using the specified spatial reference. Polyline and polygon geometries are not exported. The data is formatted as an Excel table.

You can also export details about features selected on the map; for more information, see Select features and Find nearby features.