Excel plug-in and AGOL - Revision history

Alnaucler at 17:58, 19 June 2018

2018-06-19T17:58:50Z

← Older revision		Revision as of 19:58, 19 June 2018
Line 3:		Line 3:
	{{Under construction\| }}		{{Under construction\| }}
	{{Note \| Currently the Excel plug-in does not work with Windows 2016.}}		{{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__		=== Prerequisites===__NOEDITSECTION__
	# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office ArcGIS Maps for Office]		# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office ArcGIS Maps for Office]
	# ~~AGOL~~ account		# ArcGIS Online / Arc Portal / IMSMA Core account
	# Excel file with coordinates or a column that may be linked to an existing AGOL layer		# Excel file with coordinates or a column that may be linked to an existing AGOL layer

Alnaucler at 17:51, 19 June 2018

2018-06-19T17:51:08Z

← Older revision		Revision as of 19:51, 19 June 2018
Line 2:		Line 2:
	==Making a Map with Your Excel Data with Esri Maps for Office==__NOEDITSECTION__		==Making a Map with Your Excel Data with Esri Maps for Office==__NOEDITSECTION__
	{{Under construction\| }}		{{Under construction\| }}
			{{Note \| Currently the Excel plug-in does not work with Windows 2016.}}

	=== Prerequisites===__NOEDITSECTION__		=== Prerequisites===__NOEDITSECTION__
	# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office ArcGIS Maps for Office]		# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office ArcGIS Maps for Office]

Alnaucler at 17:49, 19 June 2018

2018-06-19T17:49:42Z

← Older revision		Revision as of 19:49, 19 June 2018
Line 1:		Line 1:
			{{TOC right}}
			==Making a Map with Your Excel Data with Esri Maps for Office==__NOEDITSECTION__
			{{Under construction\| }}
			=== Prerequisites===__NOEDITSECTION__
			# Excel plug-in from ESRI [http://www.esri.com/software/maps-for-office ArcGIS Maps for Office]
			# AGOL 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}}		{{NavBox AGOL Extension}}
	[[Category:PEW]]		[[Category:PEW]]

Alnaucler: Created page with "{{NavBox AGOL Extension}} Category:PEW"

2018-06-19T17:38:57Z

Created page with "{{NavBox AGOL Extension}} Category:PEW"

New page

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