View source for Excel plug-in and AGOL

{{TOC right}}
==Making a Map with Your Excel Data with Esri Maps for Office==__NOEDITSECTION__ 
{{Under construction| }} 
{{Note | Currently the Excel plug-in does not work with Windows 2016.}}

By using the Excel plug-in it is not necessary to 
# create a shape file with ArcGIS desktop
# upload layer to ArcGIS Online /Arc Portal

=== Prerequisites===__NOEDITSECTION__ 
# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office  ArcGIS Maps for Office]
# ArcGIS Online / Arc Portal / IMSMA Core account
# Excel file with coordinates or a column that may be linked to an existing AGOL layer

=== Excel===__NOEDITSECTION__ 
1. Open the Excel workbook that contains your data and click the
Esrl Maps tab in the Excel ribbon.

2. Click the Insert Map button at the top left of the Excel ribbon and
enter your ArcGIS Online subscription account usar nama and
password in the sign-in window. A map window with a default
basemap opens.
Note: You can change the default basemap by clicking Bas a map
in the ribbon and clicking one of the other basemaps.

3. Click the Add Excal Data button or right-dick on the map and
select Add Excel Data from the menu.

4. Choose Cell Range to manually select the data you want to add to
the map. (The Table or Named Range option is described in the
Esri Maps for Office Help.)

5. Select the cells that contain your data. Include column headers in
your selection-they will be useful in a later step. Click OK.

6. Select the loc:ation type that best represents your data-for
example, Addreas-and dick Next. The Location Columm window
will show all the columns you selected. If you included column
headers in step 5, they are displayed in the drop-down list, and the
Firat row contaim header~ check box is automatically chetked.

7. Click the Add Data to Map button to finish adding the data. A
layer containing your data is added to the map.

8. The layer is listed on the Map Contents tab in the Esrl Maps task
pane in the right side of your Excel window. Right-click on the layer
and select Go To from the menu to zoom to the layer's extent.

9. To add services homd from Arc(jiS Online, click the Search tab in
the E1ri Map• task pane and enter a keyword.

10. Choose the service you want to mash up with your mapped data
and dick the Add button next to the thumbnail in the list of your
search results.

Note: To share your map in ArcGIS Online and publish it as a
feature service, you must have the publisher or administrator role.
Use the Esri Maps for Office add-in to make
a map of your spreadsheet data without
leaving the Excel environment. If you haven't
downloaded the add-in yet, you can get it at
esri.ccm/mapllforofficadownload in one of
the supported languages. Please note that Esri
Maps for Office requires Microsoft Office 2010
or higher.



{{NavBox AGOL Extension}}
[[Category:PEW]]