Skip To Content

Export layer data

In the layer options 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.

Note:

You can export data only from layers created using Excel data, not from layers created in ArcGIS.

Export to a file

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

  1. Choose the layer that you want to modify: hover over the right side of the desired layer card to display its tools and click the Layer options button Layer options.
    Layer options pane
  2. In the layer options pane, click Export layer Export layer data.

    The Export layer pane appears.

  3. Optionally choose the spatial reference to use for the exported data.
    • Click Spatial reference to open the Advanced spatial reference pane.
      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 ArcGIS Maps for Office backstage configuration.

    • Choose a spatial reference from the drop-down menu.
    • To set the selected spatial reference as the default for future export functions, check the Use this selection by default check box.

      You can change this setting by clearing the Use specified spatial reference when exporting point data option in the ArcGIS Maps for Office backstage configuration.

  4. Click OK to return to the Export layer pane.
  5. In the Export selection to section, choose File and click OK.

    A Save as window appears.

    Note:

    To cancel exporting, click Cancel or Close Close to close the pane and return to the layer options pane.

  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 (the default) or CSV (Comma Delimited) and click Save.

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

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

Export to a worksheet

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

  1. Choose the layer that you want to modify: hover over the right side of the desired layer card to display its tools and click the Layer options button Layer options.
    Layer options pane
  2. In the layer options pane, click Export layer Export layer data.

    The Export layer pane appears.

  3. Optionally choose the spatial reference to use for the exported data.
    • Click Spatial reference to open the Advanced spatial reference pane.
      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 ArcGIS Maps for Office backstage configuration.

    • Choose a spatial reference from the drop-down menu.
    • To set the selected spatial reference as the default for future export functions, check the Use this selection by default check box.

      You can change this setting by clearing the Use specified spatial reference when exporting point data option in the ArcGIS Maps for Office backstage configuration.

  4. Click OK to return to the Export layer pane.
  5. In the Export selection to section, choose Worksheet and click OK.
    Note:

    To cancel exporting, click Cancel or Close Close to close the pane and return to the layer options pane.

    ArcGIS Maps for Office creates a 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 includes 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.