Community
Select to view content in your preferred language

Embed ArcGIS for Excel Map in Spreadsheet

109
1
2 weeks ago
Status: Needs Clarification
dcopple
by
Frequent Contributor

I am liking being able to see my map in ArcGIS for Excel in the side screen.  The problem is, I want a map for my users to see while they are working on a spreadsheet.  Allowing the user to select a point on the map, and getting data to fill certain fields on the spreadsheet from those fields in the data.  Much like we can do with a web experience and prefilling some fields in a survey123.  Excel provides some very powerful reporting functionality that I don't currently have in ArcGIS pro without exporting a table and opening it in Excel.  Excel also has powerful query tools for building power queries of data.  I have incorporated some of that between ArcGIS and Excel, but having the actual map available, embedded on a spreadsheet would be even better!  Could be under the dropdown and add an option to embed map. Below is a loose example, not embedded though.  The map window is just on the spreadsheet page. But showing an example if a user clicks the map, it could update the cell from a field in the GIS data.

dcopple_1-1746222249698.png

 

 

0 Kudos
1 Comment
ShannonCardoza
by Esri Contributor
a week ago
Status changed to: Needs Clarification

Good morning @dcopple, 

Thank you for the information and suggestions. So I do not assume any workflow here, can you elaborate on what is meant by, 'I want a map for my users to see while they are working on a spreadsheet'?

In the production version of ArcGIS for Excel, the map created can be detached from the side panel; the detached map stays on the spreadsheet page as users are working on the spreadsheet, see below: 

ShannonCardoza_0-1746552525979.png

I believe you are aware of this. If the goal is to 'allow the user to select a point on the map and get data to fill certain fields on the spreadsheet from those fields in the data', then embedding the map would not meet the need of this particular workflow. 

If the goal is to have the map available with the spreadsheet, regardless of whether the add-in is installed, with whom you share the Excel workbook, this is not possible. 

If you are looking to edit attribute table features, please see Add and Edit ArcGIS Layer Attribute Data in an Excel worksheet. 

I hope this helps! Please keep me posted...

-SC